HelpDesk Report - Release Worker Licenses
Here is a report for HelpDesk Solution 6.5 which will release worker licenses. When you run the report (from your NS), it lists all users consuming a license currently. If you see a user whose license you'd like to release, right-click their record, and click “Remove Workers License:”
A new window should pop up with the worker, and if License is set to zero, you should be all set:
To install, save the attached zip file, and unzip the "HelpDesk Licenses.xml" file. Open your NS console and browse to reports. Right click the Reports folder, and click Import:
Select the xml file and it should import. You should now have a folder under reports called "HelpDesk Licenses." Run the "HelpDesk License Consumption" report and follow the steps above.
Be sure to test the report in your test\dev environment prior to adding to production!
Comments
Thanks Chase! Working great
Thanks Chase! Working great in our Dev and Production systems.
Perfect! Great Job! Funny
Perfect!
Great Job! Funny that Altiris didn't succeed to add this functionality as an out-of-the-box feature.
Thanks
I will try this tomorrow this has been a problem for us.
V6.0 question
Do you think this report will run in v6? I am plagued with the same issue.
Thanks
Maybe...
It might work, but I don't know if they changed the database schema at all from release to release.
You could sign into helpdesk and edit a ticket (so a license is consumed), then load the report into the console and run it. If the report returns your account information, then it should work. The first part of the report is just querying, so that should be safe.
If you have a test environment, it would be best to try it there first.
Error mesage with Helpdesk report
Hello,
I have been following the posts and have tried to get this report to run in console v 6.5. I am pretty much a newbie and not to good with my SQL right now. I have been having the issue of licenses not releasing timely. When I run this report I get the following message:
Sql error in query. Error: System.Data.SqlClient.SqlError: Incorrect syntax near 'worker_id'.System.Data.SqlClient.SqlError: Incorrect syntax near 'worker_id'.Sql CommandText: -- MAX ROWCOUNT SET ROWCOUNT 50000 -- UPDATE HD_worker_view SET worker_active_access = 0 WHERE worker_active_access = '1' AND worker_id = %worker_id% SELECT hd1.[worker_name] AS 'Worker Name', hd1.[worker_id] AS 'Worker ID', hd1.[worker_nt_id] AS 'Login ID', hd1.[worker_department] AS 'Department', hd1.[worker_email] AS 'E-Mail', hd1.[worker_active_access] AS 'License', hd1.[worker_last_access_on] AS 'Last Accessed' FROM hd_worker_view hd1 WHERE hd1.worker_id = %worker_id%
When I right click and select properties of the report it mentions "Will not work if run by itself" Am I missing a step to get this to work properly? I can run a report that shows license consumption just fine, but not this one.
Run "Helpdesk License Consumption" report instead
To remove licenses, you need to run the "Helpdesk License Consumption" report. When it shows users in the system, you right-click on the user, and click "Remove Workers License."
The Consumption report uses the "Remove HelpDesk License" report to actually complete the removal. You're right in that it can't be run by itself.
Worked for me in HD 6, Console 6.5 just now!
Thanks Chase! A lifesaver....
Very nice
Needed this today for a customer and worked great! You are da man!
The program seems to be
The program seems to be working smoothly and perfectly fine on my computer. I’m also curious if this report will run in version 6. Otherwise I guess that I just have to download the HelpDesk Report and try it myself. Thank you for helping out, it’s very much appreciated.
Jeff Foster
Web Design & Social Media - http://www.webbizideas.com
Would you like to reply?
Login or Register to post your comment.