How to get a report on Logical Volumes with file system type

sandeepatnaik

I want a report on volumes list with file system is NTFS

ecmel

This information comes from "Asset Inventory" polling so firstly you need to make sure that "Asset Inventory" polling is enabled on your servers that you would like to generate the report.

Then you can use "Custom Table" or "Custom Query" widget in your report and define "SWQL Query" to pull data from Asset Inventory and monitored Volume objects. You can find an an example query below filtered for NTFS disk types only:

SELECT l.Polling.Node.Caption as [Node Name]
, l.DeviceID as [Disk Name] 
, v.Type as [Type]
, l.FileSystem as [File System]
, l.SerialNumber as [Serial Number]
, ROUND((1.0 * l.SizeB/1024/1024/1024),2) AS [Size (GB)]
, ROUND((1.0 * (l.SizeB - l.SpaceAvailableB)/1024/1024/1024),2) AS [Space Used (GB)]
, ROUND((1.0 * l.SpaceAvailableB/1024/1024/1024),2) AS [Available Space (GB)]
, ROUND((100.0 * l.SpaceAvailableB / l.SizeB),1) AS  [% Available Space]
, l.Polling.Node.DetailsUrl as [_LinkFor_Node Name]
, v.DetailsUrl as [_LinkFor_Disk Name]
FROM Orion.AssetInventory.LogicalDrive l 
LEFT JOIN Orion.Volumes v 
ON l.NodeID = v.NodeID  
AND v.VolumeDescription LIKE ToString(l.DeviceID + '%')
AND v.VolumeSize = SizeB
WHERE l.FileSystem='NTFS'
ORDER BY l.Polling.Node.Caption, l.DeviceID