[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