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.
Well I'm back on this little project again after getting sidetracked with 1000 other projects. I tried the commands as posted - ran execute - and absolutely nothing happens except for a quick blink of the screen. For me, there are a bunch of issues here - I am out of my depth being the number one. I'm not sure if the code incorrect, if my Explorer is non-functioning - or if I need different commands for SQLite. I'm going to join an SQLite forum and see if I can get help there. Can I not just go straight into the tables and look at the data? Thanks again for all the help and support. > On Mon, 27 Apr 2009 14:34:13 -0400 (EDT), "Mike Kay" > <mikekay at channelk.ca> wrote: > >>Greetings. This is not strictly speaking a CVSNT problem, but kinda is. >>I've installed auditing with no issues and have now found a SQLite >>Explorer program that is working fine. It's by Arke Systems. I can open >>the database and see the tables, and I can check the integrity of the >>database - it's fine. But I am not a database guy, so I don't know how >> to >>create SQL commands to extract the data I would like to look at. And that >>data is pretty simple - When and who checked out or updated the >> repository >>during a period of time. That's it. >> >>So, if you have any hints, links or ideas about how best to get started >>with this - it would be most appreciated. >> > > 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. Bracketing > makes sure it is treated as a column name. > > Enter your own dates here... > > Of course there are more stuff possible to do on Commit and Tag > commands because they supply more data into the auditing.... > > > -- > > /Bo > (Bo Berglund, developer in Sweden) > _______________________________________________ > cvsnt mailing list > cvsnt at cvsnt.org cvsnt downloads at march-hare.com @CVSNT on Twitter CVSNT on Facebook > http://www.cvsnt.org/cgi-bin/mailman/listinfo/cvsnt https://www.march-hare.com/cvspro/en.asp#downcvs > > Upgrade to CVS Suite for more features and support: > http://march-hare.com/cvsnt/ > The highest achievement possible is compassion.