I have this query and two questions
FIRST i would like to add the status code for the backup
SECOND is it possible to use a input file for the CLIENTNAME in the next to last line?
The reason for the input file is so users with only reporter access from opscenter can use the query to check on the status of client backups, unless you have a better way.
Thanks
SELECT domain_masterServer.friendlyName as "Master",
domain_job.clientName AS "Client",
lookup_ScheduleType.name AS "Schedule Type",
utcbiginttonomtime(domain_job.startTime) AS "Start Time",
utcbiginttonomtime(domain_job.endTime) AS "End Time",
DATEDIFF(mi, utcbiginttonomtime(domain_job.StartTime), utcbiginttonomtime(domain_job.EndTime)) AS "Duration (Min)",
domain_job.filesBackedUp AS "File Count",
(domain_job.bytesWritten/1024) AS "Size (Kilobytes)"
FROM domain_job , lookup_ScheduleType , domain_masterServer
WHERE lookup_ScheduleType.id = domain_job.scheduleType
and domain_job.masterserverid = domain_masterServer.id
and clientName LIKE '%vcld34gpadhap04%'
ORDER BY "Start Time"
