I have a SP 2007 site where site usage is enabled and I can check the usage for last thirty days. I wanted the usage details for last 6 months for which I went to SharePoint Designer but my SPD is crashing again and again for this site. I updated it to SP3 with no luck. Can anyone please tell me how to get these reports from DB. I know there are views which can get me such data. I tried with
ANLHitsByResourceByDay ANLHitsByResourceByUserByDay ANLSiteResourceHits
But I need to joining it for correct data. I want the hit of index.html file located in one specific document library. Any help would be appreciated.