12-01-2016 04:23 AM
OpsCenter 7.6.1
i saw that there are report templates for restores one of which i used to create a restore report for the last 30 days. the report it seems is a list of ALL restore activity, successful or not. i was wondering if a restore report for successful status can be generated? i attempted to edit the query but it's in SQL and i have no clue about it.
12-02-2016 01:18 AM
Hi,
You can try this.
Gives you how many successfully completed and failed over the past month.
SELECT count(A.clientname) AS "Successfully restored", ( SELECT count(clientname) AS "failed restored" FROM domain_Job where type = '2' and statusCode != '0') from "domain_job" A where type = '2' and statusCode = '0' and DATEDIFF(month, UtcBigIntToNomTime(endTime), GETDATE()) = 1