Ever wanted to share your Custom Ticket view with your team or others so everyone can use the same link to see the same information?
If you haven't, you probably will one day if you're using the service desk module within KACE K1000.
Below is a quick guide on how to accomplish this.

Pre-requisites: MySQL Workbench (or similar), R1 password for access to database, Already created ticket views on your account (or someone's account) that you are looking to share with the team/others

Steps:

Using MySQL Workbench (or similar), run the following query:

SELECT * FROM ORG1.HD_TICKET_FILTER

The above query will provide you with all of the custom views currently configured in your KACE appliance along with what USER it belongs to.
Don't know what userid belongs to each user?  Simply run this query (and you can save the output if you'd like):

SELECT ID,USER_NAME FROM USER

Once you know which of the filters you want to share and the UserIDs of the users you want to share it with, go into your Custom Ticket Rules under one of your ticket queues to create a SQL INSERT query.

Go to Choose Action -> New (SQL) and name it whatever you'd like.  Uncheck "Enabled" so it doesn't run automatically.

Under Select SQL, you can put something like:

SELECT * FROM ORG1.HD_TICKET_FILTER

Then you will want to check the box "Run Update Query" and in the Update SQL box, you will enter:

INSERT INTO HD_TICKET_FILTER (USER_ID,NAME,FIND_FIELDS) VALUES ([UserIDOfUser],[Name],[FIND_FIELDS])

As an example:

INSERT INTO HD_TICKET_FILTER (20,'Open Tickets','[{"TYPE":"group","WFIELD":"AND","LEVEL":0,"NODELETE":0,"EXP_SELECT":"EQUALS","INPUT":""},{"TYPE":"rule","WFIELD":"IF(HD_TICKET.HD_USE_PROCESS_STATUS and HD_TICKET.IS_PARENT, HD_SERVICE_STATUS.NAME, HD_STATUS.NAME)","LEVEL":0,"EXP_SELECT":"NO_CONTAIN","FIELD_DATA_TYPE":"string","INPUT":"Closed","LOGIC_OVERLOAD":"AND"}]')

The above example will create a new Custom Ticket View called "Open Tickets" for userid 20.

If you wanted to do more than one entry at a time, simply add a , after the () for the VALUES. e.g.

INSERT INTO HD_TICKET_FILTER (USER_ID,NAME,FIND_FIELDS) VALUES ([UserIDOfUser],[Name],[FIND_FIELDS]), ([UserIDOfUser2],[Name2],[FIND_FIELDS2])

Click on "Run Now" when you are ready to run.  This will insert the values and you can use MySQL Workbench to verify!

If you have any questions, please do not hesitate to ask.  I wrote this up quickly and will mature the documentation above as questions arise.