SQL query to determine access to archived items?

[Sarah_Seftel1]

Hi,

assuming I don't want to enable auditing or install reporting services.

Is there a query I can run against vault store DB to determine user access rate to archived items in the past week by hours?

I have a scheduled evening upgrade, and the customer is concerned that we will cause many users to not be able to work correctly. (no vault cache)
I'm trying to think of a simple query that I can run against the vault store DB that will give me in results how many users accessed archived items between 18PM to 00PM, so I can show him "you see? only 9 people out of 25,000 tried to open archived item"...

any ideas?

Is it even possible?

Sarah

[Rob_Wilcox1 · Accepted solution]

No, there isn't a way to do this.

[GertjanA]

You might want to check IIS logfiles, but as Rob states, it is not possible in SQL

[Sarah_Seftel1]

OK, Thanks !

[Rob_Wilcox1]

And whilst you're marking one of the posts here as a solution :)  You might want to take a look at this article I wrote about logparser:

http://thingsilearnedtoday.net/2011/05/09/using-log-parser-with-enterprise-vault/

[Sarah_Seftel1]

Thanks.

[John_Santana]

wow, I thought that therei s solution about this, but yes it will be to hard to perform I guess...

[EV]

After reviewing your link I think that this is the only viable, no cost, way to achieve that goal without enabling auditing with item access granularity enabled.

[Rob_Wilcox1]

Glad to help.

BTW .. Auditing isn't necessarily the answer.  Last time I checked all of the 'http' access to items is recorded as the Vault Admin Account, rather than the 'actual' user which performed the retrieval.

[JesusWept3]

but the idea is to show how many items are being accessed at all right? so regardless of the user, it will validate what is needed

[Rob_Wilcox1]

guess so.. but would need to turn on auditing, let it run etc.. whereas IIS logs are likely to already have this information.