/build/static/layout/Breadcrumb_cap_w.png

K1000 - Is there a way to auto-populate Service Desk Ticket with information from Asset Details?

We are tracking our mobile devices in Assets; Name, Device Model, Carrier, SIM, IMEI, etc. A form has been created in Service Desk for these devices as well in a queue of it's own, apart from the IT Service Desk. When a Help Desk Technician creates a new service ticket for a mobile device and the Asset.Name has been selected, we would like the remaining fields to populate from ASSET_DATA_12 to the HD Ticket.

L74BWg.jpegJGGwo7.jpeg

0 Comments   [ + ] Show comments

Answers (1)

Posted by: Jbr32 9 years ago
10th Degree Black Belt
1
You could do this via a custom service desk ticket rule.  

Basically create a ticket rule that runs on save.  

Have the ticket rule select all of the appropriate fields from your asset using a join connection to the service desk on the field HD_Ticket.Name or ASSET ID (depending on how it is linked up).  You would want to grab any field you plan to update within your custom ticket.  

Within the same ticket rule, run an update query on the current ticket that updates the fields within the custom service desk ticket rule with values from your custom asset.  

Should work without issue.  I would recommend you create your queries within MySQL Workbench and make sure you test, test, and re-test.  

Comments:
  • Thank you so much. I will give it a try. - kimimtt 9 years ago
    • Keep in mind that writing directly to the DB can mess up your box if done incorrectly. - Jbr32 9 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ