External Hard Disk details

[Srikanth08]

Hi,

Is there any query to find th external hard disk connected on the network..

[Hemoco]

The "Roles" field in tblComputersystem specifies the roles of a system in the information technology environment. The report "Role: SQL Server" returns only the machines that have the "SQLServer" role.
This field has nothing to do with software editions. SQL edition info (Express, Standard...) cannot, in any way, be scanned by Lansweeper.

[Srikanth08]

hi,

what is the purpose of the report Role: SQL server? by using the report we can find find whether it is SQL server or express?

[Hemoco]

If the external hard disks were recently connected, try performing a "Full Rescan" of the machines you want. Then run the report.

[Srikanth08]

but the query is showing wrong report..actual external hard disk connected system is not showing..

[Hemoco]

Please use the following query:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblDiskdrives.Caption, tblDiskdrives.Description,
tblDiskdrives.DriveType, tblDiskdrives.FileSystem, tblDiskdrives.Freespace,
tblDiskdrives.Size, tblDiskdrives.Volumename,
tblDiskdrives.Volumeserialnumber, tblDiskdrives.Lastchanged
From tblComputers Inner Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Where tblDiskdrives.Caption <> 'A:' And tblDiskdrives.DriveType = 2