[cvsnt] CVSNT Auditing continued
Arthur Barrett
arthur.barrett at march-hare.com
Tue Apr 28 00:20:13 BST 2009
> 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.
I think that we changed column name that in CVSNT 2.5.04, so that SQL is
probably for 2.5.03.2382?
Regards,
Arthur
More information about the cvsnt
mailing list