RohitNayal
10 years agoLevel 5
List of Active clients in NBU
Hi All,
From OPS center how can I extract the report for all the list of server with their OS and HW information and need to get the list of only active clients which are in active policy
Regards
Rohit
Try this.
select
domain_client.name as "Client",
domain_client.isactive as "Active?",
domain_client.ispolicyclient as "Listed in Policy",
domain_client.versionlabel as "Version",
domain_client.hardware as "Hardware",
domain_client.ostype as "OS"
from domain_client