Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*SQL\s+and\s+ADSM\s+ACT\s+LOG\s+Queries\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*SQL\s+and\s+ADSM\s+ACT\s+LOG\s+Queries\s*$/: 6 ]

Total 6 documents matching your query.

1. SQL and ADSM ACT LOG Queries (score: 1): Author: Michael Dummitt <Michael.Dummitt AT ROSSNUTRITION DOT COM>; Date: Wed, 22 Dec 1999 11:05:54 -0500; Does anyone know how to limit sql queries to just one day of the activity log. Currently, we can produce reports but they contain every record in the activity log. We would like to be able to trim th; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/1999-12/msg00913.html (11,000 bytes)
2. Re: SQL and ADSM ACT LOG Queries (score: 1): Author: "Mark Brown (CC Operations Supervisor)" <CCMB AT MUSICA.MCGILL DOT CA>; Date: Wed, 22 Dec 1999 20:18:26 EST; Check out my web page. I use alot of adsm sql commands to produce output. http://mbrown.cc.mcgill.ca/adsminfo.html Just about all the output on that page has the sql command at the top of each page.; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/1999-12/msg00936.html (11,695 bytes)
3. Re: SQL and ADSM ACT LOG Queries (score: 1): Author: "Joshua S. Bassi" <jbassi AT GLORYWORKS DOT COM>; Date: Wed, 22 Dec 1999 17:35:08 -0800; Mark, That is pretty amazing! I love what you have done to produce good meaningful info for your user community. Great job! Tell me, when are you going to start adding banner ads to generate some rev; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/1999-12/msg00937.html (11,034 bytes)
4. Re: SQL and ADSM ACT LOG Queries (score: 1): Author: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of; Date: Sun, 04 Oct 2015 17:36:17 -0500; Check out my web page. I use alot of adsm sql commands to produce output. http://mbrown.cc.mcgill.ca/adsminfo.html Just about all the output on that page has the sql command at the top of each page.; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/1999-12/msg00938.html (11,781 bytes)
5. Re: SQL and ADSM ACT LOG Queries (score: 1): Author: Bacchi Matt VENDOR <v2bacchi AT BTV.IBM DOT COM>; Date: Thu, 23 Dec 1999 09:42:56 -0500; Michael, It sounds like you want to do something like this: select * from actlog where date_time \> '1999-12-22 00:00:00.000000' and date_time \< '1999-12-23 00:00:00.000000' Unfortunately the select; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/1999-12/msg00974.html (12,369 bytes)
6. Re: SQL and ADSM ACT LOG Queries (score: 1): Author: GERARD Jean Michel <jm.gerard AT COFINOGA DOT FR>; Date: Thu, 23 Dec 1999 16:27:55 +0100; On a UNIX client I am used to call dayly the following script that build a macro previous to call it rm actlog.mac echo set SQLDISPLAYMODE WIDE > /home/user1/actlog.mac echo 'select * from actlog whe; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/1999-12/msg00986.html (13,813 bytes)

Current List: 1 - 6
Page: [1]