Craig Porteous
A SQL Blog
  • Home
  • About Me

Archive for database security

Powershell snippet background
Posted by Craig 
· 27th September 2016 
· No Comments

AD Group Auditing with Powershell

Here’s another handy Powershell script Ive created. It borrows components from another(credited at the bottom of the post) and expands on the repadmin functionality in the Active Directory Powershell module. The main aim of this is to keep track of members being added or removed to Active Directory groups. There is functionality to do this within AD but if, like myself, you have no control over AD administration this may help you out.

I wanted to keep track of specific groups used for reporting & SharePoint site access that may also require database access. Being notified of additions to these groups by other teams/managers would allow me to identify & fill in missing database perms before they become a problem. Ill append a few example SQL queries as I go, to show how Im using it.

Here’s a quick flow of what Im doing here:

adauditcp

 

This can be ran regularly on any schedule just through task scheduler. It will always pick up the exact date/time that a user was removed or added to a group so how often you schedule it to run depends on how quickly you want to be notified of a change.

Read More →

No Comments
Categories : Powershell
Tags : Active Directory, AD, auditing, database security, powershell

Recent Posts

  • Top 10 things to document in SSRS 27th February 2018
  • I published a PowerShell Module! 16th January 2018
  • Clustering the Power BI Data Gateway for High Availability (and Low visibility?) 4th January 2018
  • Managing Power BI Dataset Refresh Failures 30th November 2017
  • How to build a SQL Server Virtual Lab with AutomatedLab in Hyper-V 21st November 2017

Categories

  • Announcements (4)
  • ASP.NET (1)
  • C# (1)
  • Certifications (1)
  • MySQL (1)
  • PowerBI (5)
  • Powershell (9)
  • Scripts (2)
  • SharePoint 2010 (2)
  • SQL Server 2012 (5)
  • SQL Server 2014 (7)
  • SQL Server 2016 (9)
  • SQL Server 2017 (3)
  • SSAS (1)
  • SSRS (14)
  • T-SQL Tuesday (1)
  • TSQL (1)
  • Uncategorized (1)

Social

  • View cporteous’s profile on Twitter
  • View craigporteous’s profile on LinkedIn
Craig Porteous · Copyright © 2018 All Rights Reserved
iThemes Builder by iThemes · Powered by WordPress & hosted by SiteGround WordPress Hosting