Re: query for computers with DVD drive?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "rodia" <rodiavel@xxxxxxx>
Date: 5 May 2006 01:18:14 -0700

try this...

select * from SMS_R_System inner join SMS_G_System_CDROM on
SMS_G_System_CDROM.ResourceID = SMS_R_System.ResourceID where
SMS_G_System_CDROM.DeviceID like "%DVD%

.

References:
- query for computers with DVD drive?
  - From: trond

Prev by Date: Inventory ActiveX control on PCs using SMS
Next by Date: Re: SMS_DEF.mof modifications and SP2
Previous by thread: query for computers with DVD drive?
Next by thread: Re: SMS_DEF.mof modifications and SP2
Index(es):
- Date
- Thread