Ever had a person leave the organization or your team and wanting to know where do they have access? What explicit permissions, logins, or database
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect - Engineering
SQLOpsDB Reports: Application
The SQLOpsDB data collection can help build an inventory of applications and their respective owners. For each database introduce the following extended properties on the
SQLOpsDB Reports: Dashboard – Drill Through
As stated in previous reports, all the dashboard elements offer drill through. To investigate the additional details behind the summary data. The summary layout is
SQLOpsDB Reports: Dashboard
SQLOpsDB Dashboard is primary report where all investigation starts for data collection. The database dataset is generated at the end of execution of the SQLOpsDB_DataCollection.ps1
SQLOpsDB PowerShell Module
The PowerShell model is the primary code for collecting and updating the information. The command-lets in this module are broken into three categories. I have
Windows Task Scheduler for SQLOpsDB
The Windows Task Scheduler executes the PowerShell script for data collection for both SQLOpsDB data collection and configuration health. These collections can be completed via
SQL Canada (SQLCAN) 