How can I create a list of locations that multiple queues can use?
Hello :) My company has around 25 different queues related to different departments. Currently, In KOBX 13.1, we have a custom field that shows all locations our company owns and we have to update this list in every single queue as we sell or buy new locations. Is there a way to create a single list that all tickets in all queues can reference so the process of updating our locations is not such a time suck? Essentially, we want to add a field for all tickets in all queues that will reference one master list so that we only have to manage the master list. I appreciate any help on this. Thank you!
Answers (3)
You can create the Locations in the asset section and set the field to choose from them.
Please be aware that 13.1 is EOL, which means, no support for the appliance itself can be given anymore.
And since it is no more supported also no backend updates are done to fix found security issues (which come from the underlying OS)
I suggest that you update to (as of today) 14.0 at minimum and use the 4 cumulative hotfixes for it afterwards or got to 14.1 and use the 3 cumulative hotfixes, which all fix security issues from the underlying OS, which were not discovered before the 13.1 went EOL.
Hi Nico! Thank you so much for this. Right now we are working on a process to upgrade but it will be a while before that finishes. I will share the info you provided with all the teams though!
I did find that I can make Asset an option on a ticket but I could not find how to limit it to just show asset locations instead of all assets in the system. Is that something you know how to assist with? Again, thank you so much for your help!
Comments:
-
you can use Query: SQLQUERY in the Value Field, where you query your Locations (depends on how your DB is built what you need to fill in here) - Nico_K 1 week ago
Your location values should be created in the Asset area as "Locations" and that Asset type is 1 and shows in the ASSET table as ASSET.ASSET_TYPE_ID with a value of 1.
So for your dropdown SQL Query try
Query: select distinct(NAME) from ASSET where ASSET.ASSET_TYPE_ID=1