Forum Discussion

RohitNayal's avatar
RohitNayal
Level 5
10 years ago

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

  • 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