Notification

Icon
Error

error in SSD or HDD Audit

Posted: Friday, October 22, 2021 9:02:22 AM(UTC)
Borek

Borek

Member Original PosterPosts: 6
0
Like
We found and error in this report https://www.lansweeper.c...report/ssd-or-hdd-audit/
Assumption that C: is always PHYSICALDRIVE0 is wrong. Because there is no relation between tblDiskdrives and tblFloppy we used this workaround:

Code:
Where tblDiskdrives.Caption = 'C:' AND dbo.tblFloppy.floppyID = (SELECT MIN(floppyID) FROM dbo.tblFloppy f WHERE ABS((CONVERT(FLOAT, f.size) / tblDiskdrives.Size) - 1) < 0.05 AND f.AssetID = dbo.tblAssets.AssetID) 


Therefore we find records in tblFloppy with similar sizes and choose the one with the lowest floppyID. That's because C: has not always the lowest ID of all volumes.

It would also by nice if Lansweeper can read attribute MediaType from WMI class MSFT_PhysicalDisk on its own. Here I found a Powershell workaround: https://www.lansweeper.c...-Detector.aspx#post46068

Active Discussions

Lansweeper Marking/Flagging VIP Customers
by  C Johnson   Go to last post Go to first unread
Last post: Yesterday at 11:43:22 PM(UTC)
Lansweeper Office 2016 key scanning
by  WaldoIT  
Go to last post Go to first unread
Last post: Yesterday at 3:40:41 PM(UTC)
Lansweeper Configuring SSL in IIS Express issue
by  saffo   Go to last post Go to first unread
Last post: Yesterday at 9:57:31 AM(UTC)
Lansweeper MDM Jamf School
by  Eugene  
Go to last post Go to first unread
Last post: 12/3/2021 6:21:44 PM(UTC)
Lansweeper HTTPS not secure
by  Luke Maslany   Go to last post Go to first unread
Last post: 12/3/2021 2:23:28 PM(UTC)
Lansweeper Problem with deploy software
by  Max90  
Go to last post Go to first unread
Last post: 12/3/2021 2:04:12 PM(UTC)
Lansweeper scanning target by range
by  Colombini   Go to last post Go to first unread
Last post: 12/3/2021 12:06:19 PM(UTC)
Lansweeper Log WIFI networks
by  BastiOn  
Go to last post Go to first unread
Last post: 12/3/2021 10:29:38 AM(UTC)