Seminar – Introduction to Auditing with PowerShell®
November 30 @ 8:30 am - December 1 @ 4:00 pm EST
GWDC Member $250, Non-GWDC Member $400
Auditors and IT professionals work with large amounts of data, requiring the need for a variety of tools to help them obtain, review, analyze, and/or export this data. One of the most versatile (and free) tools for working with data is PowerShell®, which is included with the Windows OS. While designed as a systems administration tool, it also has powerful capabilities that auditors and IT professionals can use.
This two-day hands-on virtual seminar is designed for auditors and IT professionals who want to learn how to use PowerShell® in performing audits or data analysis projects.
On Day 1, students will learn the basics of PowerShell, including commands to import, view, summarize, and export data, such as CSV, XML, Word, Excel, and text. Students will also be provided an overview of how PowerShell can be used to obtain data from Windows Event Logs, Active Directory, Azure Active Directory, and other data sources.
On Day 2, students will learn commands for analyzing and working with data imported into PowerShell as well as an overview of scripting commands and concepts.
Throughout the seminar, students will have the opportunity to use the commands presented through hands-on exercises.
PowerShell commands to import, summarize, view, and export CSV data
Overview of using PowerShell to import data from:
XML and text files
Windows event logs
Word and Excel files
Azure Active Directory
PowerShell resources and recap
Working with data in PowerShell
Hands-on practice in working with data
Hands-on practice in scripting
Mike Howard is an experienced IT auditor with over 28 years of IT auditing experience in the Federal Government. Mike is a technical auditor who has audited numerous technologies, including mainframes, Unix environments, Active Directory, databases, Cisco devices, and Windows computers. Mike embraces innovative technologies to accomplish his audits, most notably using PowerShell to write custom scripts. Over the 10+ years that he has been using PowerShell, he’s written over 300 PowerShell scripts.
Mike is also a member of the ISACA Greater Washington D.C. chapter and has served on the board for 17+ years, most of the time as Internet/Communications Director. Mike is currently the Associate Director for Web Development, where he manages the chapter’s website. Mike has also used PowerShell to accomplish tasks related to his Chapter duties, including creating web pages, calculating CPE credits, and updating membership rosters.
Mike has a B.S. in Accounting from Old Dominion University and a Masters in Business Administration from George Mason University.
Virtual Meeting Information
This event will be presented through Zoom. The instructor will send an email with the zoom link prior to the event.
Prior to the event, participants must install the Zoom app on their respective devices. Participants using the web-based Zoom or calling via the phone may not be entitled to CPE credits.
Participants must respond to all the poll questions via the Zoom polling feature or chat log in order to receive NASBA CPE credits.
The ISACA Greater Washington, D.C. Chapter will not be responsible for the participant’s inability to respond to the polls.
If you have CPE questions after the event has concluded, please contact the chapter using the CPE Contact Form.
Cancellation and Refund Policy
Cancellation and refund for advance registrations is allowed if cancellations are submitted through the registration system. Refunds vary depending on the date of cancellation. See ISACA GWDC Event Policies for details.
If ISACA GWDC cancels the event, all registrants will be notified as soon as possible through email at the email address provided during registration. Full refunds will be provided.
The GWDC welcomes your comments, complaints, suggestions, questions, and other feedback concerning our website information and services. All complaints should be submitted through the Registration Contact Form.
Earn up to 14 Continuing Professional Education (CPE) credit in the area of Information Technology. The ISACA® Greater Washington, D.C. Chapter is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.NASBARegistry.org
CPE Distribution and Evaluation Survey
CPEs will be distributed via e-mail along with the event evaluation survey after the completion of the event. Attendees must be present for the full event to receive full CPE credit.
After completing this course, students will have basic skills to use PowerShell to import, analyze, and output data. Students will also have an awareness of potential data sources that PowerShell can be used with.
Prerequisites: Students should be familiar with using Windows and using CSV files.
Advance Preparation: The instructor will provide materials in advance of the course that should be saved to the student’s computer. Students can follow along with the instructor in executing PowerShell commands during the course.
Program Knowledge Level: Basic
Delivery Method: Group Internet Based
Field of Study: Information Technology – Technical