Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Collection based on VirtualMachine

Updated: 22 May 2010 | 1 comment
Dieselboi's picture
0 0 Votes
Login to vote

All,

When I view generic workstation and server collections, Altiris breaks out the list of VirtualMachines for me. What is Altiris keying off of to generate this list. I want a simple collection of just workstations that are virtualmachines.



Thank you.

Brett

Comments

TGiles's picture
03
Feb
2009
0 Votes 0
Login to vote

The system is keying off of the Inv_AeX_VirtualMachine table. When hardware inventory runs it is able to determine which machines are virtualized. Once that information is saved in the database a scheduled task that run nightly will convert the computer resource to a virtual machine resource.



The following SQL should provide the collection you are after.



SELECT _ResourceGuid AS 'Guid' FROM Inv_AeX_VirtualMachine



HTH