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 firstname.lastname@example.org.
On Wed, 29 Apr 2009 12:53:13 -0400 (EDT), "Mike Kay" <mikekay at channelk.ca> 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 >> 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.... >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. As you might have seen from other posts in this forum the Audit table column names have changed over time so if you database is of later vintage than mine you should probably use this commadn instead: SELECT Command, StartTime, Username, Hostname, VirtRepos FROM SessionLog WHERE (Command='update' OR Command='checkout') AND (StartTime > '2006-01-05') AND (StartTime < '2006-02-01') Notice also that if you do not use the two last lines the returned dataset will not be time limited. Another notice: It might be a problem with using dates since the format sometimes is localized and then you need to use the one appropriate for your location. I'd start without the two last lines to push that issue ahead a bit. -- /Bo (Bo Berglund, developer in Sweden)