May 17, 2012 at 6:33 am
I have a need to validate that the handful of SQL accounts we allow are being used by non-Windows clients (Windows users/app should all be using AD groups/accounts) as part of a pseudo compliance task.
I've found what I assume are the typical places to look for connection, session, users, & login info so I could probably do something based on hostname or IP address but was wondering if there's any information "intrinsic" to the connection that would provide or imply the client's OS platform, tool used in connection (e.g. mgmt studio), or "library" used to compile the code making the connection (e.g. JDBC).
Ideas, thoughts, newbie jokes?
May 17, 2012 at 6:45 am
Some of that stuff you should be able to get from sys.dm_exec_sessions. HostName, ProgramName, ClientInterfaceName, LoginName, SessionID.
OS will be tricky but if you had a table of servers with their OS against that hostname in the DB then you could do a join, would require a bit of work to get the information you need for that manually unless you had something like Snow or LANDesk
May 29, 2012 at 1:50 pm
Yep, I'm getting familiar with the dmvs you mention - thanks for that callout & the reply!.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply