Client Management Suite

 View Only
Back to discussions
Expand all | Collapse all

Retrieve Hyper-V Hosts and Machines

  • 1.  Retrieve Hyper-V Hosts and Machines

    Posted Feb 02, 2017 02:34 AM

    Hi,

    I am trying to retrieve from Altiris Inventory Hyper-V server machine and hosts. We have deployed Sever Inventory Plugin and I was expecting to have all Host Server and Virtual machines, but I am quite confussed. In our company, Hypoer-V management is done through SCCM, so our INV_VM_XXXXXX tables are empty.

    The best approach I have found is with this query:

    SELECT DISTINCT [NODE NAME] AS HOST, REPLACE([Resource Name],'VIRTUAL MACHINE','') AS GUEST
    FROM Inv_Associate_Node_To_Active_Resource
    WHERE  [Resource Name] LIKE '%VIRTUAL%MACHINE%' AND [Resource Name] NOT LIKE '%CONFIGURATION%'  
    ORDER BY [Node Name]

    But I am not happy as the query results are good but it seems there are a lot of missing machines.

    Any ideas or suggestions?

    Thanks in advance