CODEWITHSUNDEEP
umbracoumbraco7
user3336627
user3336627

Reputation: 41

List of all published site

My company is using Umbraco for a project having many nodes, in turn having published and unpublished sites. My requirement is to get a list of all published site across all node in an xslx, csv etc. Is there any way to get this without hitting Umbraco extented APIs?

Can some help?

Upvotes: 1

Views: 145

Answers (1)

Mark
Mark

Reputation: 3271

If you don't want to use the Umbraco services, SQL is probably the best solution

The following query returns all hostnames that are linked to published nodes:

SELECT domainName
FROM [dbo].[umbracoDomains] as domains
INNER JOIN [dbo].[cmsDocument] as documents 
ON domains.domainRootStructureID = documents.NodeId
WHERE documents.Published = 1

Upvotes: 2

Related Questions