>I'm trying to devise a select query that will show me the client backups >for the prev night with the following info:- > >files checked >backed up >N transfer rate >A transfer rate >elapsed time etc. > >Other than going throught the q actlog route, is there a way to get this >info using a select query of some sort?
For general reporting, I would recommend utilizing the Accounting Log as a data source, as it provides concise numbers in compact form. In processing that log in the opsys environment, you could supplement it with data gleaned from a dsmadmc Query Actlog for the past 24 hours. There are also commericial products which can produce such reports for you, as can be found mentioned in the List archives. (I won't plug any here.) Richard Sims, BU
