Re: CVSNT Auditing continued

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"
> <[email protected]> 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)
> _______________________________________________
> cvsnt mailing list
> [email protected]
> http://www.cvsnt.org/cgi-bin/mailman/listinfo/cvsnt
>
> Upgrade to CVS Suite for more features and support:
> http://march-hare.com/cvsnt/
>


The highest achievement possible is compassion.

_______________________________________________
cvsnt mailing list
[email protected]
http://www.cvsnt.org/cgi-bin/mailman/listinfo/cvsnt

Upgrade to CVS Suite for more features and support: http://march-hare.com/cvsnt/