Re: CVSNT Auditing continued

That did the trick. Next time I am in Sweden - you get free beer! Thank
you. I left off the date commands as suggested, and can see the whole log
- I will play with the date formats till I get it right.

I'm still going ahead and studying some SQL.  This issue is coming up more
frequently in my work and I wish and need to know more.

Have a GREAT day.

> On Wed, 29 Apr 2009 12:53:13 -0400 (EDT), "Mike Kay"
> <[email protected]> wrote:
>>> 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....
>
>>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.
>
> As you might have seen from other posts in this forum the Audit table
> column names have changed over time so if you database is of later
> vintage than mine you should probably use this commadn instead:
>
>  SELECT Command, StartTime, Username, Hostname, VirtRepos
>  FROM SessionLog
>  WHERE
>  (Command='update' OR Command='checkout')
>  AND (StartTime > '2006-01-05')
>  AND (StartTime < '2006-02-01')
>
> Notice also that if you do not use the two last lines the returned
> dataset will not be time limited.
> Another notice:
> It might be a problem with using dates since the format sometimes is
> localized and then you need to use the one appropriate for your
> location.
> I'd start without the two last lines to push that issue ahead a bit.
>
>
>
> --
>
> /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/