cancel
Showing results for 
Search instead for 
Did you mean: 

Report on how much old archived data is accessed

Fiona
Level 4
Certified

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

If you have reporting and auditing enabled you can use these:

 

Archived Items Access report​ http://www.symantec.com/docs/HOWTO108049

 

 

Archived Items Access Trends report http://www.symantec.com/docs/HOWTO108080

However, I am not sure if there is a report to tell you the age of the items accessed.

View solution in original post

5 REPLIES 5

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

If you have reporting and auditing enabled you can use these:

 

Archived Items Access report​ http://www.symantec.com/docs/HOWTO108049

 

 

Archived Items Access Trends report http://www.symantec.com/docs/HOWTO108080

However, I am not sure if there is a report to tell you the age of the items accessed.

Fiona
Level 4
Certified

No, we don't have reporting enabled.

When I looked at it there just didnt seem to be enough reports that were very useful.

Rob_Wilcox1
Level 6
Partner

You could look through the IIS logs - and do analysis on those.

Working for cloudficient.com

Michael_Bilsbor
Level 6
Accredited

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.

 

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

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.