Monday, 9 June 2025

DBA - Get the list of AD users

Get the list  of AD users. 

SELECT 

   name AS [AD Account Name],
    type_desc AS [Account Type],
    create_date AS [Creation Date],     modify_date AS [Last Modified Date]
FROM 
    sys.server_principals
WHERE 
    type_desc IN ('WINDOWS_LOGIN', 'WINDOWS_GROUP')
ORDER BY 
    name;

 

No comments:

Post a Comment

SQLDBA- Deadlock graph query

  Dead lock graph query DECLARE @xelfilepath NVARCHAR(260) SELECT @xelfilepath = dosdlc.path FROM sys.dm_os_server_diagnostics_log_configura...