System Center Configuration Manager TechCenter >
System Center Configuration Manager Forums
>
Configuration Manager Inventory
>
Virtual Hosts - Hyper V & Virtual Server with version numbers
Virtual Hosts - Hyper V & Virtual Server with version numbers
- I have a query which works for listing all the Virtual Server hosts along with domain, OS and version number - see below.
My question is how to I include Hyper-V servers as there is nothing in the Add/Remove programs for Hyper-V?
Select
sys.Netbios_Name0, sys.User_Domain0,
sys.Operating_System_Name_and0
,
arp
.DisplayName0, arp.Version0
FROM
v_R_System sys
JOIN
v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
JOIN
v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
WHERE
DisplayName0 like 'Microsoft Virtual Server 2005 R2%' and fcm.CollectionID='SMS000DS'
ORDER
BY sys.Netbios_Name0
All Replies
- If it were me, I'd add in this custom mof edit (and disable the useless one, as the blog mentions): http://myitforum.com/cs2/blogs/skissinger/archive/2008/09/27/win32-servercomponent-what-is-it.aspx
Hyper-V will show up as a Name if that feature is installed (it does on my server08 boxes)
Standardize. Simplify. Automate. - You could look at the "Virtual Machine" class within the sms_def.mof too.
http://www.enhansoft.com/- Proposed As Answer bySherry KissingerMVP, ModeratorThursday, October 22, 2009 2:04 PM
