#sqlopdb reports

Who has access to your SQL Server infrastructure?

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 users you have to clean up? If are like many organizations with 100s, 200s, or eve 300+ instances, this is an impossible task. The SQLOpsDB solution collects all security details for the server and each database. The report “Security – User Lookup”…

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 user database. ApplicationName ApplicationOwner Both are optional, if none are supplied, it will default to “Unknown.” However, if ApplicationOwner is specified then ApplicationName is expected, or again it default to…