Re: CVSNT Auditing continued

"Arthur Barrett" <[email protected]> Tue, 28 Apr 2009 09:20:13 +1000

Newsgroups	gmane.comp.version-control.cvs.windows-nt.user
Message-ID	<[email protected]>

> 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
_______________________________________________
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/