
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-12-2017 04:03 PM
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?
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?
Labels:
- Labels:
-
Report Center
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-12-2017 05:56 PM
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'
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'
