03-31-2013 11:24 PM
This is a simple example of an SQL statement for generationg a report on current active jobs. Something that you not want during business hours. There seems to be nothing on SQL, it is assumede that people already know it. Feel free to add more examples
TRhis is a continuation of How to create oint in time status report on OpsCenter https://www-secure.symantec.com/connect/forums/how-create-point-time-status-report-opscenter
In full
SELECT clientName AS Client,policyName AS Policy,scheduleName AS Schedule,bytesWritten/1024/1024/1024 AS 'GiB Written',throughput/1024 AS 'MB/s' ,utcbiginttonomtime(startTime) AS 'Start Time',utcbiginttonomtime(endTime) AS 'End Time',mediaServerName AS 'Media Server',id AS 'Job ID' FROM domain_job WHERE state = 1 AND policyName NOT LIKE '%RMAN%' ORDER by id
Dissected