Layout:
Showing 1-5 of 5
-
Service Accounts Report
This procedure works with Minion Enterprise. This procedure reports on service accounts for active servers. Note that we can only report on those servers that are marked IsActive in dbo.Servers. Read More
- 9uploads
- 0questions
- 0answers
-
Login Comparison
Many databases rely on login account credentials (Username, Password & SID) being identical between servers (ie. Availability Groups and databases involved in Dev-Test-Prod migrations). Â This alert will check that all logins associated with Availability Group databases are identical between the AG servers. Additional logins can be added to allow for monitoring non-AG logins that need to be identical between servers (ie. logins associated with Dev/Test/QA servers). Read More
- 6uploads
- 0questions
- 0answers
-
SQL Acct Password Rotation
This code shows you how often a SQL acct password has been rotated on each server it's on. This is an exciting query because now you can see across your entire environment whether a SQL acct is having its password changed and you can easily setup different thresholds for each server and acct if you like. Of course you have to have the data to support this. It requires that ME be collecting data for at least one password change cycle. After that, you'll have the history of how often it's been changed. You can even use this to setup an alert to tell you when it's not happening, or when 2 boxes are out of sync, or even send an email to your helpdesk system to open up a case. Read More
- 8uploads
- 0questions
- 0answers
-
AD Acct Password Rotation
See how often an AD acct's password has been changed. This is useful when you have an audit situation and you need to rotate your password every few weeks. You could use this to audit which accts haven't had their passwords rotated on schedule, or even to remind you that it's time. Read More
- 8uploads
- 0questions
- 0answers
-
Get all users with sa
This is adhoc code that you can run to get a list of all sa users in your entire shop. It expands the AD groups and sub-groups to give you a final list of users who have sa and it then adds in the SQL and Windows users. Finally, it has 2 queries: 1. Shows a count of sa users per box in your shop. 2. Show you a list of everyone who has sa on each server and whether they're getting it via SQL, Windows, or AD Group. Depending on how big your environment is it may take this code a few minutes to run. And you can do anything else you want with this data. You're free to turn it into an alert or a report if you like, though you may want to stage the data for a report. Also, remember that the AD data by default is only collected once/week so if you've got a fast-changing environment, you may want to run the AD collection and the login collection right before running this so you have the latest data. Most of the time that shouldn't be necessary though. Read More
- 8uploads
- 0questions
- 0answers
Please sign-in with the following login form.