[cvsnt] CVSNT Auditing continued

Bo Berglund bo.berglund at telia.com
Tue Apr 28 16:36:18 BST 2009

Community technical support mailing list was retired 2010 and replaced with a professional technical support team. For assistance please contact: Pre-sales Technical support via email to sales@march-hare.com.

On Tue, 28 Apr 2009 09:20:13 +1000, "Arthur Barrett"
<arthur.barrett at march-hare.com> 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
>> (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

I have on the server where I tested this SQL on.
If I check SchemaVersion it reports 3, whatever that means.

Of course the test server has "always" had Auditing running but not a
lot of traffic (only me when I was testing out stuff) and it might be
that I never updated anything in the Audit tables.

What is your script SQL for updating an MSSQLServer database?
I mean the text of the update script, so I can see what may be
possible to do?


(Bo Berglund, developer in Sweden)

More information about the cvsnt mailing list
Download the latest CVSNT, TortosieCVS, WinCVS etc. for Windows 8 etc.
@CVSNT on Twitter   CVSNT on Facebook