Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Last Technician Login details

rickstevens

Does anyone know a way of gaining the last login date for a technician in WebHelpDesk?

TIA

Rick

Find more posts tagged with

Accepted answers

All comments

i_like_eggs

Hi,

If your Web Help Desk is run on a SQL box you can run this something i put together their might actually be other ways to do it but i like the SQL

You will need to make sure you are running it against your WHD DB instance you see below it has WHD_Live just change that to your WHD Database and you should be golden.

Select     T.FIRST_NAME AS 'NAME',    T.LAST_NAME AS 'LAST NAME',    SE.SESSION_START_TIME AS 'LOGON',    SE.SESSION_END_TIME AS 'LOGOFF',       convert(varchar(10), datediff(MINUTE,SE.SESSION_START_TIME, SE.SESSION_END_TIME)) + ' Mins'AS 'Session Time' FROM [WHD_Live].[dbo].[SESSION_HIST_ENTRY] SE JOIN  [WHD_Live].[dbo].[TECH] T ON (T.CLIENT_ID = SE.tech_ID)Where (SE.SESSION_START_TIME > GETDATE()-1) --change this value to expand the time frame

Output

You can put the SQL into a report but we dont use SQL WHD any more moved to a Linux backend.

rickstevens

Great stuff - many thanks, that works a treat

kricker

Thank you, this works awesome!