System Administration - Active Users

Craig Dubin shared this idea 50 days ago
Idea Logged

Hey there,

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

Comments (1)

photo
1

Hi Craig,

That sounds like a useful addition to me. I'll raise it as an enhancement request with the developer team.

Kind regards,

Chris