List all Simple addresses in use

Vote:
 

Is there any way to list all simple addresses that are in use on a site?

#45287
Nov 04, 2010 11:24
Vote:
 

Hi Åsa,

 

Yes, In the report center there is a report that will show a list of simple addresses used. Check page 135 in the Editors manual. 

http://world.episerver.com/Documents/Manuals/EPiServer%20CMS/EditorManuals/EPiServer%20CMS%206.0/Editors%20Manual%20EPiServer%20CMS%206.0%20Rev%20A%20(English)_LowRes.pdf

 

edited: I checked a cms 5 site and its in there as well.

#45346
Edited, Nov 04, 2010 14:06
Vote:
 

You can use the following SQL query (EPiServer 5):

SELECT DISTINCT fkPageID as 'PageId',  ExternalURL as 'SimpleURL'
FROM tblWorkPage
WHERE ExternalURL IS NOT NULL

#45347
Nov 04, 2010 14:07
Vote:
 

thank you

#46153
Nov 30, 2010 13:55
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.