[cvsnt] CVSNT Auditing continued
mikekay at channelk.ca
Wed Apr 29 17:53:13 BST 2009
Well I'm back on this little project again after getting sidetracked with
1000 other projects.
I tried the commands as posted - ran execute - and absolutely nothing
happens except for a quick blink of the screen.
For me, there are a bunch of issues here - I am out of my depth being the
number one. I'm not sure if the code incorrect, if my Explorer is
non-functioning - or if I need different commands for SQLite.
I'm going to join an SQLite forum and see if I can get help there.
Can I not just go straight into the tables and look at the data?
Thanks again for all the help and support.
> 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
>>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
>>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
> (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)
> cvsnt mailing list
> cvsnt at cvsnt.org
> Upgrade to CVS Suite for more features and support:
The highest achievement possible is compassion.
More information about the cvsnt