Customize Reports
Good afternoon,
Not being an expert on SQL code I have what I believe is a relatively straight forward problem to solve. We currenlty have 10 different service desk queues and I'd like to modify an existing report so that it only runs against the queues I want. For example we have a Network/Phone queue that I'd like to run the Open/Stalled tickets by User on. The way the query is put together right now, it runs against all our queues.
Not being an expert on SQL code I have what I believe is a relatively straight forward problem to solve. We currenlty have 10 different service desk queues and I'd like to modify an existing report so that it only runs against the queues I want. For example we have a Network/Phone queue that I'd like to run the Open/Stalled tickets by User on. The way the query is put together right now, it runs against all our queues.
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
andemats
12 years ago
As I don't know what the name of the tables are, I can only give a general line.
SELECT [Select_List] FROM [Table_List] WHERE [Conditions]
SELECT [Select_List] FROM [Table_List] WHERE [Conditions]
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
