Managing Vault user-id's

EdLorenz · Post by **EdLorenz** » Thu Mar 09, 2006 6:24 am

I’m looking to manage my Vault user-id’s and check to see who is not using their Vault user-id very much. Is there a way or query I could run to help with this?
Thanks,
Ed

lbauer · Post by **lbauer** » Thu Mar 09, 2006 7:00 am

You could do a history query and filter by user, to see who's actually made changes to the database. The Vault log file will show user logins, which will show who's logging in, even if they aren't making any changes.

EdLorenz · Post by **EdLorenz** » Thu Mar 09, 2006 7:06 am

Thanks but i'm looking for a summary type report that would list each user and the last time they checked-in or out a file. Then I could determine who is not actively using their Vault ID.

Thanks,
Ed

dan · Post by **dan** » Thu Mar 09, 2006 9:32 am

We don't have anything like that out of the box. Writing a script to scan the server log is probably your best bet.

EdLorenz · Post by **EdLorenz** » Thu Mar 09, 2006 9:56 am

Okay, can you point me to some of the tables that might contain the history for a given user. The idea is to query the tables and if a user has not done anything in say, 60 days, then we might want to deactivate their vault id.

dan · Post by **dan** » Thu Mar 09, 2006 10:10 am

We don’t provide documentation for database tables, but we do have a client API you can use to get history information, and you can create a history query that checks the last 60 days.

Download the client API installer at http://www.sourcegear.com/vault/downloads.html, which includes the source to the command line client, which has a HISTORY command you can use to figure out how to get a specific query.

Or alternatively, you could just use the command line client to do the query, and then parse the XML that it returns.