Symantec Management Platform (Notification Server)

 View Only
  • 1.  Collection based on VirtualMachine

    Posted Feb 03, 2009 05:15 AM
    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


  • 2.  RE: Collection based on VirtualMachine

    Broadcom Employee
    Posted Feb 03, 2009 06:03 AM
    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