Members, I would like to create a TSQL similar to
SELECT SPID, [Last Command], user, [Login Time], [Last Batch]
FROM [SomeHIstoryTable with crazy joins]
ORDER BY [Login Time]
Anyone have a tools box of DM TSQL queries they could share.
On a particular server I highly recommend to look at Adam Machanics sp_whoisactive (http://whoisactive.com/)
If you want to pull the data out of the DM repository, I guess the data is binary encoded in the SessionList field of the ServerActivity table. But I have no idea how to decode that data.
There is a report available but it can't be used external to DM currently and appears not to be decoding all sessions data. We have an item in our maintenance queue to provide a utility to decode the data and insert it into a standard table for reporting purposes.
I was looking for the report, but couldn't find one in 10.4 displaying the session data. Can you please guide me to the report you're mentioning?