Show SQL authentication login information

The script provide will allow you to query the Active Directory (AD) for information related to users that are connecting to SQL server with Windows Authentication.

Copy and paste this code and execute

Here is a list of information at this displayed.

Bad Password Count
Bad Password Time
Days Until Expiration
Default Database
Default Language
History Length
Is Expired
Is Locked
Is Must Change
Lockout Time
Password Hash
Password Last Set Time
User name

Hope you find it useful.

Thanks,

Rudy

Download script here: https://docs.google.com/file/d/0B07PMQYOhF2DeEdBMlV5ZllnMjA/edit?usp=sharing