Harriet_Kim_1764

[Release Manager formerly ARA] How to Query for a List of Admin Users

Discussion created by Harriet_Kim_1764 on Aug 3, 2016
How to query for a list of admin users in Release Manager (née ARA):

It uses the Usr and Member tables in the ARA database. 

SELECT Member.Id, Member.TechnicalName, Member.DisplayName, Member.EmailAddress, Usr.IsAdmin 
FROM Member 
INNER JOIN Usr 
ON Member.Id=Usr.ID 
WHERE Usr.IsAdmin=1

Outcomes