SMS 2003 - SQL Question...

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

SMS 2003 - SQL Question...

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> SMS 2003 - SQL Question...

Page: [1]

Message

<< Older Topic Newer Topic >>

SMS 2003 - SQL Question... - 9/25/2008 4:18:01 PM

aparrott

Posts: 36
Score: 3
Joined: 12/1/2005
Status: offline

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?

Post #: 1

RE: SMS 2003 - SQL Question... - 9/25/2008 4:56:07 PM

jnelson993

Posts: 925
Score: 127
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

Use V_GS_Computer_System instead.

Virtual PC
Manufacturer0 = 'Microsoft Corporation'
Model0 = 'Virtual Machine'

VMWare
Manufacturer0 = 'VMWare, Inc.'
Model0 = 'VMWare Virtual Platform'

Parallels (MAC)
Manufacturer0 = 'Parallels Software International Inc.'
Model0 = 'Parallels Virtual Platform'

(there are probably others, like that Sun VM thing that Sherry uses)

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to aparrott)