Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
SELECT srvr.CustomerName, COUNT(DISTINCT usr.UserID) AS UserCount, COUNT(page.PageExtension) AS PageViews, COUNT(page.PageExtension) AS HitCount FROM fact_IIS_user_ip fact JOIN IISLogServer srvr ON fact.ServerID = srvr.ServerID JOIN dim_IIS_user usr ON fact.UserID = usr.UserID AND usr.username != 'Not Specified' JOIN dim_IIS_Page_PageExtension page ON fact.PageID = page.PageID JOIN dbo.dim_IIS_scstatus stat ON fact.SCStatusID = stat.scstatusid AND stat.scstatus IN (200, 304) WHERE fact.dateid IN (SELECT CONVERT(CHAR(8),GETDATE()-1,112)) AND page.PageExtension IN ('aspx', 'html') GROUP BY CustomerName
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.