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 ManageEngine ADSelfService Plus Vulnerability
by  TheGift73   Go to last post Go to first unread
Last post: 11/30/2021 10:25:01 AM(UTC)
Lansweeper OS: Not latest Build of Windows 10 not working
by  Luke Maslany  
Go to last post Go to first unread
Last post: 11/29/2021 2:01:49 PM(UTC)
Lansweeper Cannot find right class
by  FabioB   Go to last post Go to first unread
Last post: 11/29/2021 8:16:33 AM(UTC)
Lansweeper vCenter vSphere Web Client Vulnerabilities
by  Esben.D  
Go to last post Go to first unread
Last post: 11/25/2021 12:24:24 PM(UTC)
Lansweeper Report for Hardware Maintenance
by  PBjelly   Go to last post Go to first unread
Last post: 11/23/2021 2:53:33 PM(UTC)
Lansweeper Need a little help here
by  AMcCarron  
Go to last post Go to first unread
Last post: 11/18/2021 3:07:25 PM(UTC)
Lansweeper Solftware Installed by member of AD Group
by  RPZ   Go to last post Go to first unread
Last post: 11/17/2021 9:57:42 PM(UTC)
Lansweeper Uptime Report duplicate powerstates
by  INNO-IT  
Go to last post Go to first unread
Last post: 11/16/2021 5:10:23 PM(UTC)