Discover Mac Partitions with Less Than 10% Free Space
Audit your network and find all Macs which have less than 10% free space on one or multiple of their partitions. Find Macs that are running low on disk space and might need an expansion of their storage capacity or need a to clear up some space. Macs 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 user applications not functioning or malfunctioning when trying to write data.
Using the audit in combination with alerts, you can get alerts when Macs are running low on disk space. This way you do not have to run the audit on a day to day basis.
Mac Partition Less Than 10% Space Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblMacPartitions.Filesystem,
tblMacPartitions.Available,
tblMacPartitions.Used,
tblMacPartitions.Percentage As [Space used],
tblMacPartitions.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 tblMacPartitions
Inner Join tblAssets On tblMacPartitions.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 tblMacPartitions.Available <> N'0B' And tblAssetCustom.State = 1
And Replace(tblMacPartitions.Percentage, '%', '') > 90
Order By tblAssets.AssetName
