Goal

I want to be able to run a report that will tell me which pages in a portal are structures (vs freeform or layout or URL). Ideally, I'd like to see URL or maybe page name; need to be able to identify the page

Query

Run the following query on the Production_Portal_PortalFx database. Naming conventions may vary from portal to portal. 

SELECT PageID AS PageURL, DisplayText AS PageName, IsPublic, PageType, TemplateID, Tags, CreatedDate, PageTemplateID
FROM PWPages
ORDER BY PageType

To export the results to Excel, copy the query results. If the column headers do not copy over, follow the instructions on this article. 

What do the PageType numbers mean? 

​PageType = 1 and TemplateID ends in Blank for Freeform (displayed as Passageways.IslandPageTemplates.Blank on query results)

PageType = 1 and TemplateID doesn't end in Blank for Layout

PageType =3 is a URL page

PageType = 4 for Structure pages