Powershell compliance reports

Hello EE,

I am looking for some powershell scripts available that will report on Access security formatted for the general competencies such as PCI or IT general Control listing . In summary , something to pull all the AD and preferably SQL access and formatted in excel or a table to drop into any required documents .

Thanks.
davesnbAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

btanExec ConsultantCommented:
You probably can get from AD based on event id e.g. To access event logs, Windows PowerShell comes with Get-EventLog cmdlet. For example, define the start date, grab event log of warning and error from that date, select the fields desired, and send it into xls..

$now=get-date
$startdate=$now.adddays(-7)
$el = get-eventlog -ComputerName Serv1 -log System -After $startdate -EntryType Error, Warning
$el|Select EntryType, TimeGenerated, Source, EventID | Export-CSV eventlog.csv -NoTypeInfo

http://eventlogxp.com/blog/exporting-event-logs-with-windows-powershell/

I see it more of object access event so need to check for the ID. In short, depending which audit enabled and application specific log with the specific id, the PS can be use to grab and print to xls.
0
davesnbAuthor Commented:
I am looking for something more for access control , so Active Directory reporting
0
btanExec ConsultantCommented:
There are also access event log for AD access if that is what you are looking at. For e.g.
https://blogs.technet.microsoft.com/heyscriptingguy/2012/03/12/use-powershell-to-explore-active-directory-security/
0
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

davesnbAuthor Commented:
I am using Add-PSSnapin Quest.ActiveRoles.ADManagement module now to pull a lot of this data, I wondered if there is a script already created to provide all group roles , and user roles in a domain
0
btanExec ConsultantCommented:
Maybe something of a recursive read
https://4sysops.com/archives/display-access-rights-on-active-directory-ous-with-powershell/
there is a free scanner per se
Once the GUI is running, you can directly connect to your AD domain; loading the Active Directory PowerShell module is not required. Next, you have to select the AD object for which you want to retrieve the permissions. In AD ACL Scanner’s Advanced section, you can set several options, such as the scan type (DACL or SACL) and the scan depth (OUs, containers, all objects).
https://4sysops.com/archives/ad-acl-scanner-easily-generate-active-directory-permissions-reports/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Gary DewrellSenior Network AdministratorCommented:
0
davesnbAuthor Commented:
ok thanks for the info guys!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Powershell

From novice to tech pro — start learning today.