SQL search for checked out files

code · Post by **code** » Fri Jul 04, 2008 1:47 am

Hi,

Would it be possible to get an SQL query that we can run over our vault database in order to find out the number of files checked out by a individual user?

I know we can do this via the GUI by searching for checked out files and the web admin will show undo checkouts, however both of these are at the repository level.

As we have a lot of repositories and a lot of movement from users between them, it would be nice to run an audit to make sure everyone is not leaving work checked out. It would be great if we could then schedule this and then we can generate check in reminders each week.

Many thanks,

Tim Peel

code · Post by **code** » Fri Jul 04, 2008 1:48 am

Sorry forgot to mention, we are running 4.0.6 at present but will be upgrading to 4.1 over the next month or so.

Thanks