[cvsnt] CVSNT Auditing continued
bo.berglund at telia.com
Mon Apr 27 21:53:24 BST 2009
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
(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 Berglund, developer in Sweden)
More information about the cvsnt