Windows Disk Space Report - Only for SAN Attached Drives

[MikeM]

Hello-

Was trying to create a report that would show the following, but only for SAN Attached Disk (Not local disk drives):

ServerName, Domain, Drive Letter, TotalMB, UsedMB, FreeMB, TypeofSANDisk(tblFloppy.Model)

I have a report that I am playing with, so there are a bunch of extra fields in there as I have been trying to figure out the fields:

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblDiskdrives.Caption,
Ceiling(tblDiskdrives.Freespace / 1024 / 1024) As FreeMB,
Ceiling((tblDiskdrives.Size / 1024 / 1024) - (tblDiskdrives.Freespace / 1024 /
1024)) As UsedMB,
Ceiling(tblDiskdrives.Size / 1024 / 1024) As TotalMB,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblDiskdrives.DriveType,
tblDiskdrives.Description,
tblDiskdrives.Freespace,
tblDiskdrives.FileSystem,
tblFloppy.InterfaceType,
tblFloppy.Manufacturer,
tblFloppy.Model
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
Where tblDiskdrives.DriveType = 3 And tblAssetCustom.State = 1 And
tblComputersystem.Domainrole > 1
Order By tblAssets.Domain,
tblAssets.AssetName,
tblDiskdrives.Caption

The problem with this is that if a server has: C: 😧 E: F: drives and C: and 😧 are on the local disk, and the E: and F: Drive are on SAN disk, it will like each drive letter with Each Disk Model. So I will end up with each drive letter listed 4 times with each disk Model. So it doesn't really list each drive letter only once and each drive letter will get listed with a model of Local and SAN, so really no way to identify which are SAN disks from the report.

Any ideas?

Thanks!

-Mike

[Esben_D]

Unfortunately, I do not think there is a good identifier to identify SAN disks vs local disks as you mentioned. I don't know if you can get drive information from the SAN device itself?