System Administration - Active Users
Just submitting an idea for the administration page. We find ourselves regularly running queries against the ActiveSession table. I created a report and dumped it into a System Admin folder. But it'd be really nice if something like that showed up on the Administration page, since users are managed there too.
Here's the query, and see screenshot of report:
select concat(i.LastName,', ',i.FirstName) as 'UserName', a.CreationTime as StartSession, a.DeletionTime as SessionTimeout, concat( cast(datediff(ss, getdate(), a.DeletionTime)*1.0/3600 as int),'h', cast(round((datediff(ss, getdate(), a.DeletionTime)*1.0%3600)/60,0) as int),'m', datediff(ss, getdate(), a.DeletionTime)%3600%60,'s') as TimeRemaining from yfapp.dbo.activesession a join yfapp.dbo.Person i on i.IpPerson=a.EntityId order by 2