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
