05-11-2015 05:32 PM
Hi guys,
Does anyone know how to generate a report from SQL which will show how much archived data is accessed?
I am most interested in the older data as we do not have any retention policies in place and this would give me some idea for future planning.
Thanks.
Solved! Go to Solution.
05-11-2015 07:23 PM
If you have reporting and auditing enabled you can use these:
However, I am not sure if there is a report to tell you the age of the items accessed.
05-11-2015 07:23 PM
If you have reporting and auditing enabled you can use these:
However, I am not sure if there is a report to tell you the age of the items accessed.
05-11-2015 08:08 PM
No, we don't have reporting enabled.
When I looked at it there just didnt seem to be enough reports that were very useful.
05-11-2015 10:17 PM
You could look through the IIS logs - and do analysis on those.
05-12-2015 06:01 AM
As Rob says you could get some rough idea but it only shows activiity and not the age of the items being viewed.
Prior to V8 iddatetime was the date of the message so could could from analysis of IIS logs know the age of items but since V8 that isn't the case.
The featuer I wanted but was never developed was something which could analyse the IIS logs and on a per user basis determine a retention policy. Able to say for example, based upon looking at the last 6 months of activity for this user, the oldest item viewed was X and in fact if there was a retention policy of Y then 99% of items still would have been accessible to the user,but Z many items could have been deleted.
One day perhaps, one day.
05-12-2015 09:19 AM
So it seems the reports you need are only available with reporting installed and auditing enabled. If you have had auditing enabled, you can install the reports and be able to get some information on accessed data. If auditing hasn't been enabled you won't be able to get historical info on items accessed but you can configure now and get data from today forward.
As Rob and Mike have said, your only other recourse is to manually parse the IIS logs.