From: Xavier 1 Chavanet Have you try: select * from summary where.... ? In addition, using ODBC, you can have graphic reports on EXCEL or ACCESS. Regard ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Xavier Chavanet, Kodak, EAMER Technical Services IS-SIRM, Kodak Industrie, Bt17, Rue Paul Sabatier, ZI Nord 71102 Chalon sur Saône CEDEX, France Tel: (+33) (0) 3 85 99 70 13, Fax: (+33) (0) 3 85 99 19 13, E-Mail [EMAIL PROTECTED] ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Marc Levitan <[EMAIL PROTECTED]> on 28/06/2001 14:36:46 Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: (bcc: Xavier 1 Chavanet/979460/Chalon/France/Europe/EKC) 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