[cvsnt] CVSNT Auditing continued

[Bo Berglund]

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)