Trying to create a report of VM's
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
-
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. - nshah 10 years ago
-
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. - grayematter 10 years ago
Answers (1)
Please log in to answer
Posted by:
dugullett
10 years ago
SELECT NAME,CS_MODEL
FROM MACHINE M
WHERE CS_MODEL LIKE '%VIRTUAL%'
order by cs_model;
