Disk Space widget?

[FWBB]

Can I combine the asset summary diskspace usage visualization into a widget?

So I could show a list of servers from an asset group and each of the servers diskspace usage below it?

mspaint example:

[LJayP]

Thank you so much this is very helpfull

[Daniel_B]

In order to list only server HDDs, use a filter criterion on tblComputersystem.Domainrole. This will be bigger than one for servers. Please find the modified report below.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.FQDN,
  tblAssets.IPAddress,
  tblAssetGroups.AssetGroup,
  tblDiskdrives.Caption,
  Ceiling(tblDiskdrives.Freespace / 1024 / 1024) As FreeMB,
  Ceiling(tblDiskdrives.Size / 1024 / 1024) As TotalMB,
  Ceiling(tblDiskdrives.Freespace / (Case tblDiskdrives.Size When 0 Then 1
    Else tblDiskdrives.Size End) * 100) As FreePCT,
  tblDiskdrives.Lastchanged As [last changed],
  tsysOS.Image As icon
From tblAssets
  Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
  Inner Join tblOperatingsystem
    On tblAssets.AssetID = tblOperatingsystem.AssetID
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
  Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
    tblAssetGroupLink.AssetGroupID
Where Ceiling(tblDiskdrives.Size / 1024 / 1024) <> 0 And
  tblDiskdrives.DriveType = 3 And tblAssetCustom.State = 1 And
  tblComputersystem.Domainrole > 1
Order By tblAssets.Domain,
  tblAssets.AssetName,
  tblDiskdrives.Caption

[LJayP]

Is there anyway to just make this search for servers not all assets?

[FWBB]

Thank you, I will try this one.

[Hemoco · Accepted solution]

It would be easier to just create a custom report and add it to the Data Report widget. A sample disk report can be seen below.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.FQDN,
tblAssets.IPAddress,
tblAssetGroups.AssetGroup,
tblDiskdrives.Caption,
Ceiling(tblDiskdrives.Freespace / 1024 / 1024) As FreeMB,
Ceiling(tblDiskdrives.Size / 1024 / 1024) As TotalMB,
Ceiling(tblDiskdrives.Freespace / (Case tblDiskdrives.Size When 0 Then 1
Else tblDiskdrives.Size End) * 100) As FreePCT,
tblDiskdrives.Lastchanged As [last changed],
tsysOS.Image As icon
From tblAssets
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where Ceiling(tblDiskdrives.Size / 1024 / 1024) <> 0 And
tblDiskdrives.DriveType = 3 And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName,
tblDiskdrives.Caption