→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
MikeInLa
Champion Sweeper
I would like to receive an email when one of the drives on my exchange server is 90% full. I have setup emailing in lansweeper and tested by emailing a small report. I would like my exchange server to be checked twice a day or more and if a drive size is over the 90% mark during that scan, it will alert me immediately by email. Can someone help me out with the best way to accomplish this? Thanks in advance!
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
A sample report can be seen below. Replace the 90 (= 90 percent) marked in bold with a percentage of your choice. The report will return any disks that are more than 90% full.
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.Size - tblDiskdrives.Freespace) /
(Case tblDiskdrives.Size When 0 Then 1 Else tblDiskdrives.Size
End) * 100) As UsedPCT,
tblDiskdrives.Lastchanged As [last changed],
tsysOS.Image As icon
From tblAssets
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.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.Size - tblDiskdrives.Freespace) /
(Case tblDiskdrives.Size When 0 Then 1 Else tblDiskdrives.Size
End) * 100) > 90 And tblDiskdrives.DriveType = 3 And tblAssetCustom.State = 1

View solution in original post

10 REPLIES 10
MikeInLa
Champion Sweeper
By the way, I am wondering if there is a way for this alert to NOT be as an attachment. But rather in the body of the email.