Compare SEO Toolbar to GKMS

OVERVIEW:

Make sure the record counts match between seo_toolbar and the GKMS databases:

• gkms_{pos}.fm.Test_ILG_URL_Info
• gkms_{pos}.reporting.ILG_URL_Info
• gkms_{pos}.fm.Test_ILG_URL_Info
• seo_toolbar.reporting.ILG_URL_Info

PROCESS:

1. Run

   USE gkms_{pos};
   
   select count(*) from fm.Test_ILG_URL_Info with(nolock)
   union all select count(*) from fm.Test_ILG_URL_Info with(nolock)
   union all select count(*) from reporting.ILG_URL_Info with(nolock);
   
   USE seo_toolbar;
   
   select count(*) from reporting.URL_Info with(nolock) where site_id = (select id from site where pos = '{POS}');