Helpdesk Solution - Sorting Worker Queries List
Updated: 14 Jul 2008 | 1 comment
Why on earth would you want to sort your worker query list? For easy reading of course! The following tip will help you sort your list for easier management and viewing. Ready... set... sort!
List of queries to be updated to have the list sorted on the worker page:
Select * from Query
Where expression like ‘%worker_query%’
Worker Query:
Select * from worker_query
to be changed to
Select * from worker_query order by name
WorkerQueryViewList:
Select * from worker_query_view
To be change to
Select * from worker_query_view order by worker_query_name
Restart MSSQLServer Service
Restart IIS
Thanks,
Dom
blog entry Filed Under:
Group Ownership:
About Endpoint Management Community Blog
The Endpoint Management Community Blog is the perfect place to share short, timely insights including product tips, news and other information relevant to the Endpoint Management community. Any authenticated Connect member can contribute to this blog. Filter by:
Blog Tags
Configuring Altiris Client Management Suite Altiris Deployment Solution Symantec Management Platform (Notification Server) Wise Packaging Basics Altiris Server Management Suite Best Practice Compatibility Tip/How to Helpdesk Solution Altiris IT Asset Management Installing Workflow Solution Ghost Solution Suite Windows Reporting Performance Upgrade Features ServiceDesk 7.x Database Agents Dell Management Products
Comments
Since this is a great and
Since this is a great and needed feature I have created a query command so that it is easier for others. I am pretty certain that the id for each of these rows are the same across the board but you should double check to make sure yours match mine so that you do not have any problems when you run it. Plus as stated above always backup your database before doing this.
sql query:
BEGIN TRANSACTION
UPDATE [Altiris_Incidents].[dbo].[query]
SET expression = 'Select * from worker_query order by name'
WHERE (id = 67)
COMMIT TRANSACTION
BEGIN TRANSACTION
UPDATE [Altiris_Incidents].[dbo].[query]
SET expression = 'Select * from worker_query_view order by worker_query_name'
WHERE (id = 104)
COMMIT TRANSACTION
Would you like to reply?
Login or Register to post your comment.