Forum Discussion

Rusty_uk's avatar
Rusty_uk
10 years ago

Need OpsCenter Report showing Client FQDN

Hi

Hope someone out there can help with this.  I'ts driving me nuts!!

Our VMware policies are set to use the "VM DNS Name" as the Primary VM identifier for internal reasons.  Physical servers are also identified via their DNS name.

I need to create an OpsCenter report that will list the following:

VM DNS Name
Policy Name
Master Server

I can create various policies showing this, but it always uses the shortname (i guess its the client name).  Anyone get an idea how to get the report that i actually want?

Many thanks in advance.

Richard

Backup and Recovery
OpsCenter
Reporting
Windows Server (2003-2008)

1 Reply

Sort By
  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    Level 6
    10 years ago

    "I can create various policies showing this"

    Do you mean you've created reports? If so, how did you create them, SQL query?

    Policy Name, Client ID can be found in domain_PolicyClient and then dnsName and Client ID can be found in nb_VirtualMachines. I would say that those two client ID's should match and that if you do a join of the two tables you can pull out the DNS name to Policy Matching you require.

     

    I don't have opscenter + vm backups to test...