Marc,
Try runnin the query on the OS command line:
Via dsmadmc
dsmadmc -ID=admin -PASSWORD=admin query actlog begindate=today-1
begintime=20:00 enddate=today endtime=now
search=ANE4961I originator=client
And if that works run it as a client schedule when defining that schedule
state command at the action parameter.
But still beter try the odbc driver wich is supplied with the Windows BA
client and do your querys inside Microsoft Acces...
Happy TSM ing....
Koen Willems
----- Original Message -----
From: "Marc Levitan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 2:36 PM
Subject: scripting client's data???
> Hi All-
>
> Every morning I check the activity log with the following query:
>
> query actlog begindate=today-1 begintime=20:00 enddate=today endtime=now
> search=ANE4961I originator=client
>
> This tells me total number of bytes transferred from each client the
> previous night.
>
> QUESTION: How can I create a script to automate this? I would like to
> keep this data in a spread sheet for trending purposes.
> Has anyone successfully done this?
>
> Thanks!
> Marc Levitan
>