I know about the Last Request Type which can be used to see what a connection have done, but how to identify if an open connection is still showing any activity or if it is idle.
asked 25 Jan '12, 06:42
The following excerpt from the Foxhound Help for the purge process describes how Foxhound determines what connection-level data can be deleted because it is "uninteresting"; this goes beyond "idle" but it may be of interest to you:
A connection is defined as "uninteresting" when all the following conditions are true for the previous and current samples recorded by the Foxhound Monitor for that connection:
answered 25 Jan '12, 08:49