I'm taking over for our previous database owner/admin and unfortunately don't know SQL very well. Our instance of Solarwinds uses Windows Groups for user access so that they don't need individual username\password credentials. I need to be able to verify the Windows Group that is being used to allow a specific user access to Solarwinds. I've already tried comparing their groups in AD to their groups listed in Solarwinds Account management and I'm not seeing a match.
I know our previous admin used an SQL query to pull from the database a line of information that showed the user's last login, as well as the Windows Group that was used to authenticate them. Unfortunately, I've lost my notes, and as I said, I don't know SQL very well. I'm hoping someone might help provide the query needed.
