List all Simple addresses in use

Åsa Sikström

Vote:

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

#45287

Nov 04, 2010 11:24

Petter Klang

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.

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

#45346

Edited, Nov 04, 2010 14:06

Marek Musielak

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

Åsa Sikström

Vote:

thank you

#46153

Nov 30, 2010 13:55