Find all users in an Active Directory group from the command line (no matter what your perms)

For some reason no one has ever trusted me enough to let me help administer the active directory groups. This means I'm always adding database perms to groups somewhat blindly, hoping the group names are intuitive enough that I can deduce who's in them. Enter the magic of the command line! Turns out you can… Continue reading Find all users in an Active Directory group from the command line (no matter what your perms)

SQL Query To Find Expired Accounts In Active Directory: Knowledge Is Power And The Goodbye List

Alrighty. We're all data people here so you know we all agree that knowledge is power. One thing that is absolutely helpful in a large corporate environment is knowing if someone has been let go/laid off/fired. Using linked server to query active directory you can fairly easily (especially if someone else wrote the query) see… Continue reading SQL Query To Find Expired Accounts In Active Directory: Knowledge Is Power And The Goodbye List