Skip to main content
How can we help?
< All Topics
Print

Non-existing databases in extended audit exclude

If a database has been included in the dbo.audit_extended_exclude table, but does not exist anymore, this alert will be thrown.

To query the Performance Store database for databases that do not exist, but are marked to be excluded from the extended audit functionality, use:

select a.server_name, a.database_name object_name, count(*) [count]
from dbo.audit_extended_exclude a
left join dbo.databases d on d.server_name = a.server_name and d.database_name = a.database_name and d.state_desc = 'ONLINE'
inner join dbo.servers s on s.server_name = a.server_name
where d.server_name is null
and a.database_name is not null
and a.database_name not like '%[%]%'
group by a.server_name, a.database_name

The alert will be visible on the Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.

Table of Contents