March 2018
Beginner to intermediate
638 pages
16h 29m
English
To internally develop a monitoring solution based on the audit log data, a PowerShell script which searches and exports the audit log data to a CSV file can be scheduled. This CSV file is then used as the source of an extract-transform-load (ETL) or extract-load-transform (ELT) process to persist the log data in a source system, such as a SQL Server database. Finally, Power BI Desktop can be used to implement remaining lightweight transformations, create DAX measures, and develop the monitoring reports.
The following list of steps and supporting screenshots describe the monitoring workflow in detail:
The ...
Read now
Unlock full access