Search code examples
episerver

Where does Mogul Episerver SEO Mangager store it's data

A long shot question, I know. I'm in a new job and I've never worked with EpiServer before, let alone Mogul SEO Manager. The export url data feature in the EpiServer dashboard crashes as there's too much data to export, so I'm trying to go to the source but I can't find it.

Solution

  • I was trying to find the full list of redirects. They are stored in tblBigTable in the episerver db. I used this query to get them:

    SELECT 
    pkId
    , DateTime01
    , String04          AS RedirectUrl
    , Indexed_String02  AS RequestUrl
FROM [dbo].[tblBigTable]
WHERE StoreName = 'SeoManagerUrlDatas'
    AND String04 IS NOT NULL
ORDER BY pkid DESC