cancel
Showing results for 
Search instead for 
Did you mean: 

Opscenter simple queries required

Hi Folks,

I need some sample Opscenter basic queries to pull out report for a client.. Pls help me.

Thanks,

Sathish

3 Replies

Try this, just change

Try this, just change 'your.server.name' with the correct one

clientName AS "Client",
policyName AS "Policy Name",
lookup_ScheduleType.name AS "Schedule Type",
utcbiginttonomtime(startTime) AS "Start Time",
utcbiginttonomtime(endTime) AS "End Time",
DATEDIFF(mi, utcbiginttonomtime(StartTime), utcbiginttonomtime(EndTime)) AS "Duration (Min)",
filesBackedUp AS "File Count",
(bytesWritten/1024/1024/1024) AS "Size (GB)",
statuscode AS "Status Code"
FROM domain_jobArchive
JOIN lookup_ScheduleType
ON lookup_ScheduleType.id = domain_jobArchive.scheduleType
WHERE clientName = 'your.server.name'
DATEDIFF(day,UTCBigIntToNomTime(endTime), GETDATE()) <= 14

order by startTime DESC

Check this link for most

Check this link for most client related query report : https://www-secure.symantec.com/connect/downloads/opscenter-common-custom-reports

If what you are looking for isn't there, give us a clue of what report you are looking for. Thanks

Report on what? Please be

Report on what? Please be specific.