Report on Your Current Helpdesk Worker Status

Need to track down who actually uses the helpdesk? Find workers that no longer work for the company that may have slipped through the cracks?

You can use the following report either directly in SQL, or copying it into the NS Report builder "Enter SQL Directly"

--=
--=	Report to display all active workers in the Helpdesk	  
--= SORTED BY Last Time they accessed the system    		  
--= Note: Queues should be ignored as they have the oldest dates,  
--=		 since they never login to the system.		  
--=	Status Legend: 					  
--=		a = Active					  
--=		g = Guest					  
--=		i = Inactive					  
--=   You can change the WHERE Clause or comment it out as needed 
--=

SELECT 
	[id]'Worker #',
	[name] 'Worker Name',
	[status] 'Status',
	[last_access_on] 'Last Access On'
 
FROM 
	[Altiris_Incidents].[dbo].[worker]

WHERE 
	[status] = 'a'

ORDER BY 
	[last_access_on] ASC