Report Of CD drive writable

[Srikanth08]

Hi,
Iam in need of a report with systems having CD drive as writable and only Readable..kindly provide me the query for that

[Hemoco]

A report that includes usernames can be seen below. Lansweeper gets the read/write information for drives from WMI. If the information is entered incorrectly here, there is nothing that can be done about this unfortunately.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Username, tblCDROMDrive.Drive,
tblCDROMDrive.Caption, tblCDROMDrive.DeviceID, tblCDROMDrive.Manufacturer,
tblCDROMDrive.Capabilities
From tblComputers Inner Join
tblCDROMDrive On tblComputers.Computername = tblCDROMDrive.Computername
Where tblCDROMDrive.Capabilities Like '%4%'
Order By tblComputers.ComputerUnique

[Srikanth08]

when i checked the CD with writing facility it is showing only less quantity.in our location 400+ laptops are with writing facility..but report showing only 100

[Srikanth08]

It is better if u provide the query including username also

[Hemoco]

Could you try the reports below.


Drives that support writing:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblCDROMDrive.Drive, tblCDROMDrive.Caption,
tblCDROMDrive.DeviceID, tblCDROMDrive.Manufacturer, tblCDROMDrive.Capabilities
From tblComputers Inner Join
tblCDROMDrive On tblComputers.Computername = tblCDROMDrive.Computername
Where tblCDROMDrive.Capabilities Like '%4%'
Order By tblComputers.ComputerUnique

Drives that do not support writing:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblCDROMDrive.Drive, tblCDROMDrive.Caption,
tblCDROMDrive.DeviceID, tblCDROMDrive.Manufacturer, tblCDROMDrive.Capabilities
From tblComputers Inner Join
tblCDROMDrive On tblComputers.Computername = tblCDROMDrive.Computername
Where tblCDROMDrive.Capabilities Not Like '%4%'
Order By tblComputers.ComputerUnique