KACE Product Support : Can assets in a ticket field be pulled from a PC name or user in another field?

/build/static/layout/Breadcrumb_cap_w.png

Can assets in a ticket field be pulled from a PC name or user in another field?

I would like to select a PC and have the location and other information pre populate in the ticket, im not sure how to accomplish this

4 Comments [ + ] Show comments

You need to create a custom rule that would query the asset table to update the ticket. Do you have experience with MySQL? - chucksteel 10 years ago
Limited expereience, im using this code, but i dont get the results im looking for when i change the submitter

query: select NAME from ASSET A JOIN HD_TICKET T on (A.OWNER_ID = T.SUBMITTER_ID) where A.OWNER_ID=T.SUBMITTER_ID - agrossman 10 years ago
The data will not populate from a ticket rule until the ticket is saved, presuming the ticket rule is configured for "on ticket save".

If you are trying to define a custom field as a query, that will not work as the query will not have access to the required parameters at run time. - grayematter 10 years ago
- I didnt create a rule, this is in the ticket layout in the customization of the queue. I use this in certain fields to only show or buildings:
  query: SELECT ASSET.NAME AS ASSET_NAME FROM ASSET_DATA_1 LEFT JOIN ASSET ON ASSET_DATA_1.ID = ASSET.ASSET_DATA_ID AND ASSET.ASSET_TYPE_ID=1 WHERE (ASSET.NAME like 'Building%') ORDER BY ASSET_NAME - agrossman 10 years ago
  - Those queries will work as the result set is not dependent on other data in the ticket. However, to have the data dependent on or populated by other elements, you will need a ticket rule. There are plenty of questions on this type of manipulation. Do a search here on "ticket rule populate field" and you should get a good smattering of samples. - grayematter 10 years ago
awesome thanks!!! - agrossman 10 years ago

Answers (0)

Be the first to answer this question

Answer this question

Posted by:

View more:

KACE Product Support Questions

question

Related Questions

Link

Related Links

Post

Related Posts

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