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.
Please log in to comment

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

Please log in to comment
Answer this question or Comment on this question for clarity