0.75in0.5in7trueUser6trueDate Last Accessed5textbox3trueReferrer URL4trueHitstrue0.25in3true=Fields!UserName.Value2DateLastAccessedtrue=Fields!DateLastAccessed.Value1ReferrerURLtrue=Fields!ReferrerURL.Valuetrue=Fields!COUNT.ValuePageAccessData2.375in7in0.125in1.625in0.875in3.5in1in
7.75in1ine528facd-d9ea-4fab-81ff-c4a500e6b148dbSPSReportingSample7.25inUserNameSystem.StringDateLastAccessedSystem.StringReferrerURLSystem.StringRelativeURLCOUNTFileSizedbSPSReportingSampleStoredProcedureusp_Select_PageAccess=Parameters!FileNameSurKey.Value=Parameters!DateRange.Value=Parameters!SiteSurKey.ValuetrueRelativeURLSystem.StringUserNameSystem.StringCountSystem.Int32dbSPSReportingSampleStoredProcedureusp_Select_PageUsers=Parameters!FileNameSurKey.Value=Parameters!DateRange.ValueRelativeURLSystem.StringCountSystem.Int32ReferrerURLSystem.StringdbSPSReportingSampleStoredProcedureusp_Select_PageReferrer=Parameters!FileNameSurKey.Value=Parameters!DateRange.ValueFileNameSurKeySystem.Int64URLSystem.StringdbSPSReportingSampleselect
dfn.FileNameSurKey,
case when dfn.RelativeURL = 'No FileName'
then 'Unspecified Files'
else dfn.RelativeURL
end as URL
from DimFileName dfn
order by URLtrueSiteSurKeySystem.Int32SiteURLSystem.StringdbSPSReportingSampleselect ds.SiteSurKey, substring(da.VirtualServerName, 1, len(da.VirtualServerName)-1) + ds.SiteURL as SiteURL
from DimSite ds
inner join FactSiteStorage fss on ds.SiteSurKey = fss.SiteSurKey
inner join DimArch da on da.ArchSurKey = fss.ArchSurKey
group by ds.SiteSurKey, da.VirtualServerName, ds.SiteURL
order by SiteURLtrueimage/bmpQk12CwAAAAAAADYAAAAoAAAAFAAAADAAAAABABgAAAAAAEALAAAAAAAAAAAAAAAAAAAAAAAASEhI9/f3////////////////////////////////////////////////////////////////////cHBwPj4+t7e3////////////////////////////////////////////////////////////////5+fnDw8PaWlpXl5e////////////////////////9/f3h4eHn5+f////////////////////////////l5eXSEhIr6+vGhoa////////////////////////39/fAAAAERER////////////////////////////PT09j4+P7+/vAAAA19fX////////////////////39/fAAAADAwM////////////////////////7+/vBgYGz8/P////HR0dj4+P////////////////////39/fAAAADAwM////////////////////////n5+fCwsL////////VFRUMDAw////////////////////39/fAAAADAwM////////////////////////SkpKQUFB////////n5+fBQUF7+/v////////////////39/fAAAADAwM////////////////////9/f3BQUFn5+f////////39/fAAAAr6+v////////////////39/fAAAADAwM////////////////////r6+vAAAA39/f////////////CQkJVFRU////////////////39/fAAAADAwM////////////////////VFRUFBQU////////////////QUFBDg4O////////////////39/fAAAADg4O////////////////9/f3CAgIVFRU////////////////j4+PAAAAz8/P////////////39/fAAAADw8P////
////////////v7+/AAAAn5+f////////////////x8fHAAAAe3t7////////////39/fAAAADw8P////////////////Xl5eAAAA39/f////////////////9/f3BAQEMDAw////////////39/fAAAADw8P////////////////Dg4OFBQU////////////////////////MDAwAAAA7+/v////////39/fAAAADw8P////////////x8fHAAAAaWlp////////////////////////dHR0AAAAmpqa////////39/fAAAADw8P////////////ZWVlAAAAr6+v////////////////////////r6+vAAAATExM////////39/fAAAAERER////////////ERERAAAA7+/v////////////////////////7+/vAAAACAgI////////39/fAAAAERER////////0NDQAAAAISEh////////////////////////////////ISEhBAQEra2t////39/fAAAAERER////////YGBgAQEBaWlp////////////////////////////////Xl5eAQEBZGRk////39/fAAAAERER////////Hx8fBQUFr6+v////////////////////////////////n5+fBgYGGxsb////39/fAAAAERER////w8PDCAgICwsL7+/v////////////////////////////////39/fDAwMCQkJysrK39/fAAAAEhIS////Z2dnAwMDMDAw////////////////////////////////////////Dg4OCQkJd3d339/fAAAAFBQU////Hx8fAgICe3t7////////////////////////////////////19fXLS0tAAAALy8vp6enAAAADw8PsbGxCQkJEBAQh4eH7+/v////////////////////9/f
3QUFBQEBAAQEBBAQEAAAAAwMDBAQEAwMDAwMDBAQEAgICAgICAwMDGBgYODg4Wlpa////////////39/fGBgYv7+/EhISAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWVlZp6enHBwc////////////39/fICAgYGBeQEA+PT07QEA+PT07QEA+PT07QEA+Pj48Pj48QEA+PT07QEA+a2tqHBwc////////////39/fICAgAAAAv7+nPj46sbGbUlJLnZ2LZGRbi4t7d3dqd3dqi4t7ZGRbsbGbRkZEHx8f////////////39/fICAgAAAA5eXJ0tK54ODFxMSt8vLUycmx1NS75eXJzs621NS739/E4ODFsLCoICAg////////////39/fICAgAAAAsrKe///fsrKesrKe///fsrKesrKe///fsrKesrKe///fsrKepqaeICAg////////////39/fICAgAAAA9/fYeXlu7OzPjY1/2dm/n5+OxcWusrKesrKexcWun5+O7OzPcnJuICAg////////////39/fICAgAAAAKysn0tK5lpaHhoZ58vLUiYl8kJCB5eXJjIx+kJCB39/ElpaHcnJuICAg////////////39/fICAgAAAAODgxcHBi///f39/Dt7eg///f///f///f///f///f///f///f6+vfICAg////////////39/fICAgAAAAkJCAAAAAKiolAAAADg4Ma2tijo5/srKegoJ2jo5/n5+OpqaUVlZUICAg////////////39/fICAgAAAA5eXJY2NXAAATNzcxAAAAWFhO1NS75eXJzs621NS739/E4ODFsLCoICAg////////////39/fICAgAAAA5eXJ///f5eXJ3t7DAAAsBwcGz8+2///f5eXJ5eXJ///f5eXJ1NTJICAg////////////39/fICAgAAAAsrKeeXlupqaUa2tilZWDAAAAMTEsdX
VndnZrjo5/n5+OpqaUVlZUICAg////////////39/fICAgAAAA///f0tK5+fna2dm/8vLUYmJWAAAXAAAAAAAAm5uI39/E+fnawsK5ICAg////////////39/fICAgAAAAmZmJ///fmZmJmZmJ///fmZmJmZmJv7+nKysnDg4N9/fYmZmJeHh0ICAg////////////39/fICAgAAAA///feXlu7OzPjY1/2dm/n5+OxcWusrKerKyZAAAXWVlQ7OzPcnJuICAg////////////39/fICAgAAAAzMy00tK5yMiwsLCc8vLUtLSgvr6o5eXJubmkjo5+BwcGtbWfjY2GICAg////////////39/fICAgAAAAzMy0///fzMy0zMy0///fzMy0zMy0///fzMy0zMy0YGBUWlpPvb20ICAg////////////39/fICAgAAAA5eXJeXlu1NS7gYF12dm/kZGCsrKesrKeoqKQsrKelZWFKCgjaWllHh4e////////////39/fICAgQ0NCsrKtn5+brq6pfn577OzlhoaDnp6azMzGkpKOnp6aubm0rq6qamppHBwc////////////39/fDg4Of39/f39/f39/f39/f39/f39/f39/f39/f39/f39/f39/f39/f39/cHBwGRkZ////////////////n5+ff39/f39/f39/f39/f39/f39/MDAwQEBAf39/f39/f39/f39/f39/f39/v7+/////////////////////////////////////////////YGBgY2Nj////////////////////////////////////////////////////////////////////////r6+vtbW1////////////////////////////////////1intruetrueShows users who have access this page, when they last accessed it, any referrer URL and number of hits. Also shown are two charts illustrating user distribution and referrer distribution.f31560fe-1574-4d97-b056-4bb7684da29d1inStringFile NameFileNamesFileNameSurKeyURLStringDateRange30D60D90D6M12M10YStringtrueSite CollectionSiteNamesSiteSurKeySiteURLen-US