I'm managing a large group of virtual machines using SysCenter Virtual Machine manager (SCVMM). I want to add data to the SQL Database for SCVMM application so that additional operating systems will be available in the properties of the SCVMM application. I know how to do the statements which add the data to the database table and where to insert the data. I need to know how to find the values of the operating systems e.g. OSId, Name, Description, Edition, Product type, Version, Architecture, OS Flags, & VMWareGuestId. I've googled for a whole day now and can't find anything on the OSId some kind of md5 hash/guid/uuid/sid thing that will tell the SCVMM application what kind of operating system is on the virtual machine. It is in the format - xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx. I'm willing to read anything just could use a little direction on what to search for - I need to find these values for multiple operating systems all windows based.



Software/Hardware used:
Windows Server 2008 R2