|
aparrott -> SMS 2003 - SQL Question... (9/25/2008 4:18:01 PM)
|
I am trying to build a SQL 2005 query that will most easily give the following information for all systems in a specific collection. Some systems will be physical and some will be MS virtuals while others are VMWARE virtuals.
SystemName / Domain / Operating System / IsMSVirtual / IsVMWareVirtual.
The first part of this seems easy...
select distinct fcm.name, fcm.domain, opsys.Caption0
FROM _RES_COLL_[CollID] fcm JOIN v_GS_Operating_System opsys ON fcm.MachineID = opsys.ResourceID
Order By Name
What I can't figure out is how to best handle the virtual portion.
I know that using v_GS_Disk, looking at Caption0 is a good way to pick out the virtuals. MS Virtual Server uses a caption containing 'MS Virtual' while VMWARE uses various captions all which have 'VMWARE' in the string.
Any thoughts?
|
|
|
|
