Discover Linux Partitions with Less Than 10% Free Space
Audit your network and find all Linux machines which have less than 10% free space on one of their partitions. Find Linux machines that are running low on disk space and might need an expansion of their storage capacity or need a storage cleanup. Machines with low disk space can cause multiple issues as services and applications require sufficient disk space to continue to operate. A lack of disk space can result in business-critical applications not functioning or malfunctioning when trying to write data to a partition.
Using the audit in combination with alerts, you can get alerts when Linux machines are running low on disk space. This way you do not have to run the audit on a day to day basis.
Linux Partition Less Than 10% Space Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblLinuxHardDisks.Filesystem,
tblLinuxHardDisks.Size,
tblLinuxHardDisks.Used,
tblLinuxHardDisks.Percentage As [Space used],
tblLinuxHardDisks.MountedOn As [Mounted on],
tblAssets.Domain,
tsysAssetTypes.AssetTypename As Type,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblAssets.Firstseen,
tblAssets.Lastseen,
tsysAssetTypes.AssetTypeIcon10 As icon
From tblLinuxHardDisks
Inner Join tblAssets On tblLinuxHardDisks.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Where Replace(tblLinuxHardDisks.Percentage, '%', '') > 90 And
tblAssetCustom.State = 1
Order By tblAssets.AssetName
