sys-dm-hadr-name-id-map-transact-sql.md

title	sys.dm_hadr_name_id_map (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sys.dm_hadr_name_id_map sys.dm_hadr_name_id_map_TSQL dm_hadr_name_id_map dm_hadr_name_id_map_TSQL
dev_langs	TSQL
helpviewer_keywords	Availability Groups [SQL Server], monitoring sys.dm_hadr_name_id_map dynamic management view
ms.assetid	e07bb8a9-37de-4a39-a257-950d7c3ae8fb
caps.latest.revision	8
author	MikeRayMSFT
ms.author	mikeray
manager	jhubbard

sys.dm_hadr_name_id_map (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx_md]

Shows the mapping of Always On availability groups that the current instance of [!INCLUDEssNoVersion] has joined to three unique IDs: an availability group ID, a WSFC resource ID, and a WSFC Group ID. The purpose of this mapping is to handle the scenario in which the WSFC resource/group is renamed.

Column name	Data type	Description
ag_name	nvarchar(256)	Name of the availability group. This is a user-specified name that must be unique within the Windows Server Failover Cluster (WSFC) cluster.
ag_id	uniqueidentifier	Unique identifier (GUID) of the availability group.
ag_resource_id	nvarchar(256)	Unique ID of the availability group as a resource in the WSFC cluster.
ag_group_id	nvarchar(256)	Unique WSFC Group ID of the availability group.

Permissions

Requires VIEW SERVER STATE permission on the server.

See Also

Always On Availability Groups Dynamic Management Views and Functions (Transact-SQL)
Always On Availability Groups Catalog Views (Transact-SQL)
Monitor Availability Groups (Transact-SQL)
Always On Availability Groups (SQL Server)