cancel
Showing results for 
Search instead for 
Did you mean: 

OpsCenter 7.7 - VMWare Report By ClientOS

PDragon
Level 4

Greetings,

 

I have a business need to generate reports for each of my admin teams by Client OS, RHEL, AIX, HP-UX, Windows, etc...etc...

The report would include the following columns.

--------------------------------------------------------------

Client Name
 
Client OS

Policy Name

Job Start Time 

Job End Time

Job Throughput (KB/Sec)

Job Status (Complete and Partial only)

My challange/Problem has been 90% of my servers reside in VMWare v5.5 that is being backed up using NBU 7.7 via vmware query (VADP) intellegent policy. Any time I create a report that includes the "ClientOS" column, they always appear blank. But when I run the test query in NBU the "VMWare Client OS" comes back with an OS type.

 

So my question is 2 parts:

1: Do clients backed up via VADP not report the Client OS of the VM Guest to OpsCenter?

2: If the answer is Yes to the first question how can I build a report by OS for VMs being backed up via VADP?

Feedback welcome...

1 ACCEPTED SOLUTION

Accepted Solutions

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Thanks,

 

Lets try this one

 

select

nb_VirtualMachines.dnsname as "dnsname",

nb_VirtualMachines.hostname as "hostname",

nb_VirtualMachines.name as "VM Name",

nb_VirtualMachines.operatingSystem as "OS"

from

nb_VirtualMachines

View solution in original post

8 REPLIES 8

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Hi,

 

Can you post the output of the following to see what is actually collected in OpsCenter

 

select

domain_client.name as "Client Name",

domain_client.osDescription as "Description",

domain_client.osType as "OS Type"

from domain_client

PDragon
Level 4

 VMs are showing as follows

RCHAXQHYB02.somedomain.com  -1 
rchfxzps02.somedomain.com
rchaxzads02.somedomain.com

Above are 3 examples from the output. The original output is over 6 thousand rows. But the majority looks like the above. 

Non-VMs are showing as follows

rchaxzes01bak.somedomain.com  Linux 2.6.32-573.3.1.el6.x86_64   47 
rchaxzes02bak.somedomain.com  Linux 2.6.32-573.3.1.el6.x86_64   47 
rchaxzes03bak.somedomain.com  Linux 2.6.32-573.3.1.el6.x86_64   47 

 

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Thanks,

 

Lets try this one

 

select

nb_VirtualMachines.dnsname as "dnsname",

nb_VirtualMachines.hostname as "hostname",

nb_VirtualMachines.name as "VM Name",

nb_VirtualMachines.operatingSystem as "OS"

from

nb_VirtualMachines

PDragon
Level 4

Well thats more like what I am looking for. See below for the output.

dnsname

hostname

VM Name

OS

dnsname

hostname

VM Name

OS

golpz5001 golpz5001bak.somedomain.com golpz5001 windows7Server64Guest
rchpq5001 rchpq5001bak.somedomain.com rchpq5001 windows7Server64Guest
golaxp05 golaxp05.somedomain.com golaxp05 rhel6_64Guest
golap5001 golap5001bak.somedomain.com golap5001 windows7Server64Guest
golaz5000 golaz5000bak.somedomain.com golaz5000 windows7Server64Guest
zeepz5001 zeepz5001bak.somedomainn.com zeepz5001 windows7Server64Guest
golaxz04 golaxz04.somedomain.com golaxz04 rhel6_64Guest

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Hi,

 

Cool. You can join the two tables and pull out your info.

 

select

domain_client.name as "Client Name",

domain_client.osDescription as "Description",

domain_client.osType as "Physical OS,

nb_VirtualMachines.operatingSystem as "Virtual OS"

from domain_client, nb_VirtualMachines

where

nb_VirtualMachines.clientid=domain_client.id

 

Or something to that effect. I'm sure you can manipulate it furter :)

PDragon
Level 4

Riaan.Badenhorst, thanks for the feedback, the table space is a big help as now I have data points to manipulate. To your point of creating a join, yes I should be good from this point. The solution to my problem was just finding the data.

 

Now I can attempt to use the tables


nb_VirtualMachines.name as "VM Name",
nb_VirtualMachines.operatingSystem as "OS"

 

with client name (I believe) to create the report I need with

Client Name ("VM Name" nb_VirtualMachines.name)
 
Client OS ("OS" nb_VirtualMachines.operatingSystem

Policy Name

Job Start Time

Job End Time

Job Throughput (KB/Sec)

Job Status (Complete and Partial only)

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Pleasure. Shout if you get stuck :)

PDragon
Level 4

Well I might just be stuck, here is what I got. But I seem to be stuck trying to snatch the data I want in my query?

NOTE: I used TOP 100 for quick results only.

 

select

TOP 100 START AT 1 domain_Policy.name as "Policy",

domain_client.name as "VM Guest",

adjust_timestamp(domain_JobArchive.startTime,-14400000 ) as "Job Start Time",

adjust_timestamp(domain_JobArchive.endTime,-14400000 ) as "Job End Time",

nb_VirtualMachines.operatingSystem as "Virtual OS",

domain_JobArchive.throughput as "Throughput (KB/Sec)",

(case when domain_JobArchive.state =3 and domain_JobArchive.statusCode in (0,1) then 0 else 2 end) as "Job Status (Complete/Partial)"

from domain_client, nb_VirtualMachines, domain_JobArchive , domain_Policy , domain_MasterServer , domain_Client

where

nb_VirtualMachines.name=domain_client.name

Results

Policy

VM Guest

Job Start Time

Job End Time

Virtual OS

Throughput (KB/Sec)

Job Status (Complete/Partial)

Policy

VM Guest

Job Start Time

Job End Time

Virtual OS

Throughput (KB/Sec)

Job Status (Complete/Partial)

- mmcdp5013 Sep 24, 2015 6:07:31 PM Sep 24, 2015 6:07:32 PM windows7Server64Guest 0 0
- mmcdp5013 Sep 25, 2015 3:36:38 AM Sep 25, 2015 3:36:38 AM windows7Server64Guest 0 0
- mmcdp5013 Sep 25, 2015 10:41:24 AM Sep 25, 2015 10:41:25 AM windows7Server64Guest 0 0
- mmcdp5013 Sep 25, 2015 12:42:33 PM Sep 25, 2015 12:42:34 PM windows7Server64Guest 0 0
- mmcdp5013 Sep 25, 2015 6:15:09 PM Sep 25, 2015 6:15:09 PM windows7Server64Guest 0 0
- mmcdp5013 Sep 26, 2015 3:36:44 AM Sep 26, 2015 3:36:45 AM windows7Server64Guest 0 0
- mmcdp5013 Sep 26, 2015 3:36:44 PM Sep 26, 2015 3:36:44 PM windows7Server64Guest 0 0
- mmcdp5013 Sep 26, 2015 6:20:16 PM Sep 26, 2015 6:20:16 PM windows7Server64Guest 0 0
- mmcdp5013 Sep 27, 2015 3:37:41 AM Sep 27, 2015 3:37:42 AM windows7Server64Guest 0 0
- mmcdp5013 Sep 27, 2015 3:37:41 PM Sep 27, 2015 3:37:41 PM windows7Server64Guest 0 0
- mmcdp5013 Sep 27, 2015 6:20:17 PM Sep 27, 2015 6:20:17 PM windows7Server64Guest 0 0
- mmcdp5013 Sep 28, 2015 3:37:48 AM Sep 28, 2015 3:37:49 AM windows7Server64Guest 0 0
- mmcdp5013 Sep 28, 2015 3:37:48 PM Sep 28, 2015 3:37:48 PM windows7Server64Guest 0 0
- mmcdp5013 Sep 28, 2015 6:20:42 PM Sep 28, 2015 6:20:43 PM windows7Server64Guest 0 0
- mmcdp5013 Sep 29, 2015 3:36:43 AM Sep 29, 2015 3:36:43 AM windows7Server64Guest 0 0
- mmcdp5013 - - windows7Server64Guest - 2
- mmcdp5013 - - windows7Server64Guest - 2
- mmcdp5013 - - windows7Server64Guest - 2
- mmcdp5013 - - windows7Server64Guest - 2
- mmcdp5013 - - windows7Server64Guest - 2
- mmcdp5013 - - windows7Server64Guest - 2