[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
Download the latest CVSNT, TortosieCVS, WinCVS etc. for Windows 8 etc.
@CVSNT on Twitter   CVSNT on Facebook