Lansweeper will automatically pick up information about optical drives from any Windows computer or server. Alongside the device the drive is installed on, the drive letter is also displayed. This lets you easily find all devices in your environment which have an optical drive and which ones do not. This gives you a clear overview which can be used to replace old optical drives with newer ones or which computers need their optical drives removed.
CD-ROM Information Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblCDROMDrive.Drive,
tsysOS.Image As icon,
tblCDROMDrive.Caption,
tblCDROMDrive.Lastchanged
From tblAssets
Inner Join tblCDROMDrive On tblAssets.AssetID = tblCDROMDrive.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName
