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.
No installation.Â Just run the code.
Please sign-in with the following login form.