I am working with the SQL team to see if there is a way to globally whitelist IP addresses that are causing alerts within sp_Blitz? Would like to have them exclude 5 IP addresses.

  • 3
    When you say "causing alerts within sp_Blitz," can you be more specific about what you mean? The exact alert will determine whether it can be filtered or not - I don't think SQL Server tracks IP addresses in most of the things we filter on. – Brent Ozar Oct 9 '19 at 20:50
  • Hi! Welcome to DBA Stack Exchange. Can you include the details on what "alert" you're referring to? Including the full text of messages is always helpful, and sometimes necessary for others to be able to help. – AMtwo Oct 9 '19 at 22:25

sp_Blitz doesn't have parameters to skip IP addresses since SQL Server doesn't store IP addresses for most of the activities.

However, you can skip specific checks altogether if you want. To do that, create a table like this:

CREATE TABLE dbo.SkipChecks (ServerName NVARCHAR(128), DatabaseName NVARCHAR(128), CheckID INT);

Then, you can add rows in there for the checks you want to skip. In the far right column of sp_Blitz's output, the CheckID is listed. (For a comprehensive list of checks and IDs, see the documentation.)

  • ServerName = ‘MyServer, DatabaseName = NULL, CheckId = NULL – will not check anything on servername MyServer
  • ServerName = NULL, DatabaseName = ‘MyDB’, CheckId = NULL – will not check MyDB on any server
  • ServerName = ‘MyServer’, DatabaseName = ‘MyDB’, CheckId = NULL – will not check MyDB on MyServer
  • ServerName = NULL, DatabaseName = NULL, CheckId = 5 – will skip CheckId 5 on all databases
  • ServerName = NULL, DatabaseName = ‘MyDB’, CheckId = 5 – will skip CheckId 5 on MyDB
  • I don't think they want to skip the checks, was hoping to give them a way to exclude. those IPs from causing the alerts. – user192730 Oct 9 '19 at 21:23
  • @user192730 OK, cool - just let us know which checks in the question. Thanks! – Brent Ozar Oct 10 '19 at 1:46

Not the answer you're looking for? Browse other questions tagged or ask your own question.