10-11-2015 03:47 PM
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...
Solved! Go to Solution.
10-12-2015 04:47 AM
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
10-11-2015 11:58 PM
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
10-12-2015 04:28 AM
VMs are showing as follows
RCHAXQHYB02.somedomain.com | - | -1 |
rchfxzps02.somedomain.com | - | 0 |
rchaxzads02.somedomain.com | - | 0 |
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 |
10-12-2015 04:47 AM
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
10-12-2015 05:39 AM
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 |
10-12-2015 05:50 AM
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 :)
10-12-2015 05:59 AM
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)
10-12-2015 06:00 AM
Pleasure. Shout if you get stuck :)
10-12-2015 06:44 AM
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 |