CD/DVD-ROM Drive Audit

Find All the CD/DVD-ROM Drives Your Network

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

Audit and Take Action in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting