Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Endpoint Management Community Blog

Helpdesk Solution - Sorting Worker Queries List

Created: 14 Jul 2008 • Updated: 14 Jul 2008 • 1 comment
Dominique's picture
+1 1 Vote
Login to vote

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

Comments 1 CommentJump to latest comment

ag97690's picture

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

+1
Login to vote