Report on Your Current Helpdesk Worker Status
Updated: 23 Dec 2008 | 5 comments
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
| License: | AJSL By clicking the download link below, you agree to the terms and conditions in the Altiris Juice Software License |
| Support: | User-contributed tools on the Juice are not supported by Altiris Technical Support. If you have questions about a tool, please communicate directly with the author by visiting their profile page and clicking the 'contact' tab. |
Download Filed Under:
Comments
Last accessed on drill down?
Is it possible to create a drill down to show more history on what times each worker logged in? When I open [Altiris_Incidents].[dbo].[worker]I only see a column for "Last accessed on" Sorry but I've been having trouble with drill downs.
There's no table that I know
There's no table that I know of that would keep historical data on all of the workers' access times.
The [last_access_on] field gives you the date and time of their last login to the helpdesk.
-Kev
Yes this one of the issue we
Yes this one of the issue we have several time it is only the last_access_time which is kept but no history about it.. but between the mo_workitem_history and the wuci_history we have been able to mange most of our issues even in the past...
Dom
automatically inactivate workers
I've written a similar query that includes a 'number of days since last access' parameter (eg, by last access more than x days ago). Is there a way to automatically set the status to inactive for workers that meet this criteria so we don't have to do it manually?
better using this
SELECT
[worker_id]'Worker #',
[worker_name] 'Worker Name',
[worker_status] 'Status',
[worker_last_access_on] 'Last Access On'
FROM
[Altiris_Incidents].[dbo].[worker_only_view]
WHERE
[worker_status] = 'a'
AND [worker_is_virtual] = 0
ORDER BY
[worker_last_access_on] ASC
~Pascal @ Bechtle~ Do you speak French? Et utilisez Altiris: venez nous rejoindre sur le GUASF&l
Would you like to reply?
Login or Register to post your comment.