‎10-21-2016 01:43 PM
Solved! Go to Solution.
‎10-27-2016 05:55 PM
‎11-10-2016 04:43 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblDiskdrives.Volumename,
Ceiling(tblDiskdrives.Size / 1024 / 1024 / 1024) As [Max size in GB],
Ceiling(tblDiskdrives.Freespace / 1024 / 1024 / 1024) As [Free Space in GB],
tblDiskdrives.FileSystem,
tblDiskdrives.Description,
tblDiskdrives.Caption,
tblDiskdrives.Compressed,
Case When (tblFloppy.Model Like '%SSD%' Or
tblFloppy.Model Like '%Solid State%' Or tblFloppy.Model Like '%mSS%' Or
tblFloppy.Model Like '%mSATA%') Then 'Solid State'
When (tblFloppy.Model Like '%ST500LM000-1EJ16%') Then 'Solid State Hybrid'
When (tblFloppy.Model Like '%Virtual%') Then 'Virtual Disk'
When (tblFloppy.Model Like '%DELL PERC%' Or
tblFloppy.Model Like '%HP LOGICAL%') Then 'RAID/SCSI/SAS'
When (tblFloppy.Model Like '%ATA Device%') Then 'Standard ATA'
Else 'Unknown' End As [Harddisk Type],
tblFloppy.Model,
tblFloppy.Name,
tblDiskdrives.DriveType,
tblFloppy.InterfaceType
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
Where tblDiskdrives.Caption = 'C:' And tblFloppy.Name Like '%PHYSICALDRIVE0' And
tblAssetCustom.State = 1 And tblDiskdrives.Freespace > 0 And
tblDiskdrives.Size > 0
Order By tblAssets.AssetName,
tblDiskdrives.Caption
‎07-14-2023 10:59 AM
the where clause it not really working for all system with more then 1 Harddrive.
tblDiskdrives.Caption = 'C:' And tblFloppy.Name Like '%PHYSICALDRIVE0'
I have device where 'C:' is '%PHYSICALDRIVE1'
currently i search for a solution to match tblDiskdrives with tblFloppy correctly but i don't find a field which match really.
‎10-27-2016 05:55 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now