Edit alert on disk space

[pruneaual]

Hello all,

My request is if it's possible doing a alert on disk space. Like on my Server asset

Thank you

[Hemoco]

Yes, this is possible. A sample report can be seen below. Replace the 10 (= 10 percent) marked in bold with a percentage of your choice. The report will return any disks with less than the specified percentage in free space.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tsysOS.OSname,
tblAssets.Description,
tblDiskdrives.Caption,
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) As
free,
Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) As
[total size],
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
Where Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) <> 0 And
Ceiling(tblDiskdrives.Freespace / (Case tblDiskdrives.Size When 0 Then 1
Else tblDiskdrives.Size
End) * 100) < 10 And tblComputersystem.Domainrole > 1 And
tblDiskdrives.DriveType = 3 And tblAssetCustom.State = 1

To use the report above, do the following:
• Open the report builder under Dashboard/Reports/Report Builder (Lansweeper 5.0) or Reports/Create New Report (Lansweeper 5.1).
• Paste the SQL code we provided at the bottom of the page.
• Left-click somewhere in the upper section of the page so the code applies.
• Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.

[pruneaual]

Thank you for your reply.

Its great all work fine, but i have a another request, can we edit a report with a % of disk space

[Hemoco · Accepted solution]

You can have the built-in "Disk: Servers less than 1 GB free HD" report sent to you on a periodic basis by following the instructions on page 145 and beyond of our online documentation: http://www.lansweeper.com/documentation.pdf
Note that we use the page numbers listed at the bottom of each page.

Alternatively, you can build a custom report to list the information you are after and set up an email alert for that instead.