→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
lm0513
Engaged Sweeper
We're using the built-in less than 10% disk size report for our servers. The report is emailed out to our IT team daily.

However, we have a few servers we don't want to show up on the report. Is there a way to add exceptions on the report?
1 REPLY 1
NicholeKaligian
Lansweeper Employee
Lansweeper Employee
You could use an extra where clause to exclude certain servers based on their names, IP, domain, etc.

Where tblAssets.AssetName Not Like '%citrix%' And Cast(tblDiskdrives.Size /
1024 / 1024 / 1024 As numeric) <> 0 And Ceiling(tblDiskdrives.Freespace /
(Case tblDiskdrives.Size When 0 Then 1 Else tblDiskdrives.Size
End) * 100) < 10 And tblState.Statename = 'Active' And
tblDomainroles.Domainrolename In ('Stand-alone server', 'Member server',
'Primary domain controller', 'Backup domain controller') And
Case tblDiskdrives.DriveType When 3 Then 'Local Disk' End = 'Local Disk'

Where tsysOS.OSname Not Like 'Win 2003%' And Cast(tblDiskdrives.Size /
1024 / 1024 / 1024 As numeric) <> 0 And Ceiling(tblDiskdrives.Freespace /
(Case tblDiskdrives.Size When 0 Then 1 Else tblDiskdrives.Size
End) * 100) < 10 And tblState.Statename = 'Active' And
tblDomainroles.Domainrolename In ('Stand-alone server', 'Member server',
'Primary domain controller', 'Backup domain controller') And
Case tblDiskdrives.DriveType When 3 Then 'Local Disk' End = 'Local Disk'