Active Directory And The DBA Presentation Materials And Scripts

Download GetActiveDirectoryUsersWithPowershell.zip



This file contains:

  1. ActiveDirectoryArticle.docx a longwinded article that might explain things.
  2. ActiveDirectoryTablesAndViews.sql the CREATE scripts of tables and views.
  3. CredentialHelper.sql an example of how to create a credential + proxy for SQL Agent.
  4. SQLJob_ETL_GetActiveDirectoryData.sql A scripted job to run 4 days a week.
  5. Get-ADUser_All_Properties.txt a boring reference list of a whole lot of known properties.
  6. Get-ADuser_Img1.png a demo image.
  7. Get-ADuser_Img2.png a demo image.
  8. Get-ADuser_Img3.png a demo image.
  9. GetActiveDirectoryUsers.ps1.txt the first powershell script to run, saved as txt to avoid the appearance of shenanigans.
  10. GetActiveDirectoryGroups.ps1.txt the first powershell script to run, saved as txt to avoid the appearance of shenanigans.