Community technical support mailing list was retired 2010 and replaced with a professional technical support team. For assistance please contact: Pre-sales Technical support via email to firstname.lastname@example.org.
On Mon, 27 Apr 2009 14:34:13 -0400 (EDT), "Mike Kay" <mikekay at channelk.ca> wrote: >Greetings. This is not strictly speaking a CVSNT problem, but kinda is. >I've installed auditing with no issues and have now found a SQLite >Explorer program that is working fine. It's by Arke Systems. I can open >the database and see the tables, and I can check the integrity of the >database - it's fine. But I am not a database guy, so I don't know how to >create SQL commands to extract the data I would like to look at. And that >data is pretty simple - When and who checked out or updated the repository >during a period of time. That's it. > >So, if you have any hints, links or ideas about how best to get started >with this - it would be most appreciated. > Try this (tested on a CVSNT repo audited by MSSQL Server, but the command should be almost identical: SELECT Command, [Date], Username, Hostname, VirtRepos FROM SessionLog WHERE (Command='update' OR Command='checkout') AND ([Date] > '2006-01-05') AND ([Date] < '2006-02-01') Notice the brackets surrounding Date, needed on MSSQL since Date is a reserved word and here is also defining a column name. Bracketing makes sure it is treated as a column name. Enter your own dates here... Of course there are more stuff possible to do on Commit and Tag commands because they supply more data into the auditing.... -- /Bo (Bo Berglund, developer in Sweden)