List of Active clients in NBU

[RohitNayal]

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

[RiaanBadenhorst · Accepted solution]

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