Client Management Suite

 View Only
  • 1.  SQL Queries from the Resource Summary page

    Posted Jan 18, 2017 11:35 AM

    so i have used this in the past for 6.x and was curious if one ever came out for 7.x?

    https://support.symantec.com/en_US/article.HOWTO1150.html

    i am in the need to figure out VMs... and i see under hardware 

    i get

    Computer manufacturer: VMware, Inc.
    Model:

    VMware Virtual Platform

     

    I am trying to make a filter based off of this but do not know what table it resides in.

     



  • 2.  RE: SQL Queries from the Resource Summary page
    Best Answer

    Broadcom Employee
    Posted Jan 19, 2017 04:30 AM

    If you want a custom filter to have there only virtual machines, then you can manually create a custom Filter in "Raw SQL" query mode using this SQL Query

    • This Query shows only managed Virtual machines (without physical computers)
    SELECT [Guid], IsManaged
        FROM  vComputerResource
        WHERE IsManaged = 1 AND ResourceTypeGuid = '2C3CB3BB-FEE9-48DF-804F-90856198B600'
    • This Query shows only managed physical machines (without virtual machines)
     SELECT    [Guid], IsManaged
        FROM  vComputerResource
        WHERE IsManaged = 1 AND ResourceTypeGuid = '493435F7-3B17-4C4C-B07F-C23E7AB7781F'

     



  • 3.  RE: SQL Queries from the Resource Summary page

    Posted Jan 19, 2017 10:01 AM

    wow thx..

    code.jpg