Get CD-ROM Data For A Specified Machine

 

This SQL query will allow you to find CD-ROM media information for a specified machine.

 

SQL Query:

 

Select 

Collection.Name,

CdRom.Description00,

CdRom.Drive0,

CdRom.Manufacturer00,

CdRom.MediaType0

From Cd_Rom_Data CdRom

Join _Res_Coll_Sms00001 Collection

On Collection.MachineID = CdRom.MachineID

Where Collection.Name = 'MachineName'

 

Published Sunday, May 27, 2007 8:29 AM by dhite
Filed under:

Comments

No Comments