/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Trying to create a report of VM's

02/25/2014 1798 views

Im trying to create a areport of the people running VM's in our Org. Users either run VMware or Oracle Virtual Box. I got the report created to report on VMware machines but when I try to add the VirtualBox it doesnt report anything. See attached screenshot

 

 

2 Comments   [ + ] Show comments

Comments

  • Change the AND to Or for your last night in the second picture. Second, you are looking at the model. VirtualBOX is software installed so you should be looking at software titles that contain virtualbox. Same for vmware if you are looking for the player.
  • If you are looking at CS_MODEL, you will get virtual machines with the agent installed. If there are VMs without the agent installed, those won't exist in the MACHINE table.

All Answers

0

SELECT NAME,CS_MODEL

FROM MACHINE M

WHERE CS_MODEL LIKE '%VIRTUAL%'

order by cs_model;

Answered 02/25/2014 by: dugullett
Red Belt

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ