BanisterMurray of Spaghetti
9/26/2017 - 7:24 PM

Active Sites - For Real

StickyFish DB. Use this to target only the sites that anyone really cares about.

ActiveSites
content_copyfile_download
SELECT  COUNT(1) AS ct
FROM    Members AS m WITH (NOLOCK) 
              INNER JOIN Sites AS s WITH (NOLOCK) ON m.HomeSiteID = s.SiteID
              INNER JOIN SummaryData.dbo.ARAM_Client_Master CM WITH (NOLOCK) ON s.SiteID = CM.SiteID
WHERE        
       (s.Inactive <> 1) 
  AND  s.SiteCatID <> 43 -- Ignore Shadow Sites