cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Veritas.com
Support

report for successful restores

manatee
Level 6

‎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.

0 Kudos
1 REPLY 1

M_henriksen
Level 4
Partner

‎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
0 Kudos