Login to participate
Endpoint Management & Virtualization BlogsRSS

Helpdesk Solution - Sorting Worker Queries List

Dominique's picture

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

ag97690's picture

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