I need to keep a record of the idle time of user conected to SQL server. what i am trying to do is to acumulate the time a user goes to idle and compare it to the utilization of the connected time and graph that against the time available for that user.

any idea on how to do so?

by the way I am running Visual Accountmate 6. and the problem i have if the licenses utilization

best regards