A critical vulnerability was discovered in React Server Components (Next.js). Our systems remain protected but we advise to update packages to newest version. Learn More

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.