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 - Get Space Used by Tables and Indexes in SQL Server

 Get Space Used by Tables and Indexes in SQL Server Databases can consume significant amounts of storage, so it’s important to understand ho...