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

Drives with no mappings

Volumes attached to a server that do not have a drive letter or a mount point, will be marked as a drive with no mappings.

To query the Performance Store database for disk drives with no mappings, use:

select c.*
from dbo.capacity c with (nolock)
where c.drive_letter is null and c.mount_point is null
and c.post_time in
(
	select top 1 c1.post_time
	from dbo.capacity c1 with (nolock)
	order by c1.post_time desc
)

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