cancel
Showing results for 
Search instead for 
Did you mean: 

OPS Center SQL Query

anawar
Level 2

Hi All

 

I am looking for SQL query which provides all offline clients list and deactived policy list.

 

Could any one help with the script.

Thanks-----

2 REPLIES 2

anawar
Level 2

I am looking for SQl scripts which gives all offline client list in netbackup domains.

 

and required SQL scripts for providing deactivated policy list on netbackups domains.

DG-2005
Level 5

 

select name AS "Client Name",
deleted as "deleted",
retired as "retired"

from domain_client WHERE masterServerID=61 AND deleted=1 OR retired=1
order by name

 

 

select name AS "Policy Name",
UTCBigintToUTCTime(effectivedate) AS "Date Effective",
UTCBigintToUTCTime(retirement) AS "Retired on",
UTCBigintToUTCTime(discoveryLifetime) AS "Discovery Lifetime"
from domain_Policy WHERE masterServerID=61 AND active=0
order by name