
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-22-2011 11:51 AM
Hi,
Is there any query to find th external hard disk connected on the network..
Is there any query to find th external hard disk connected on the network..
Regards,
Srikanth08
Labels:
- Labels:
-
Archive
5 REPLIES 5

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-04-2011 01:50 PM
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.
This field has nothing to do with software editions. SQL edition info (Express, Standard...) cannot, in any way, be scanned by Lansweeper.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-01-2011 07:36 AM
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?
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?
Regards,
Srikanth08

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-29-2011 04:42 PM
If the external hard disks were recently connected, try performing a "Full Rescan" of the machines you want. Then run the report.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-29-2011 09:54 AM
but the query is showing wrong report..actual external hard disk connected system is not showing..
Regards,
Srikanth08

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-22-2011 05:59 PM
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
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
