0.75in0.5in7trueFile Name6trueDate Last Accessed5textbox1trueFile Size4trueHitstrue0.25in3RelativeURL=Fields!FileNameSurKey.Value=Parameters!DateRange.Value=Parameters!SiteSurKey.ValueDetailedPageReporttrue=Fields!RelativeURL.Value2DateLastAccessedtrue=Fields!DateLastAccessed.Value1FileSizetrue=Fields!FileSize.ValueCOUNTtrue=Fields!COUNT.ValueFileTypeTrendData2.5in5.5in0.25in2.875in0.75in0.875in1in
3.75in1in40b67b84-dcf8-441c-b918-c358644fb167dbSPSReportingSample7.25inFileNameSurKeySystem.Int64SiteURLSystem.StringRelativeURLSystem.StringCountSystem.Int32DateLastAccessedSystem.StringFileSizedbSPSReportingSampleStoredProcedureusp_Select_SitePageTrend=Parameters!SiteSurKey.Value=Parameters!DateRange.ValuetrueWebSurKeySystem.Int32dbSPSReportingSampleStoredProcedureusp_Select_SiteWebs=Parameters!SiteSurKey.ValuetrueUserSurKeySystem.Int32dbSPSReportingSampleStoredProcedureusp_Select_SiteUsers=Parameters!SiteSurKey.ValueSiteSurKeySystem.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 top 20 pages accessed (based on hit count) for this site collection. You can click on a page to go to the Detailed Page Report.7e40a7f0-e056-414a-a9b0-6025767171861inStringSite CollectionSiteNamesSiteSurKeySiteURLStringDateRange30D60D90D6M12M10Yen-US