ADSM-L

SQL and ADSM ACT LOG Queries

1999-12-22 11:05:54
Subject: SQL and ADSM ACT LOG Queries
From: 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 the data down to just one day, like
yesterday.  We want to automatically produce this report so the date command
should be something like "yesterday".  We don't know and can't figure this out.
<Prev in Thread] Current Thread [Next in Thread>