/build/static/layout/Breadcrumb_cap_w.png

KACE HELP DESK: How to setup Auto Fill the MACHINE and SUBMITTER information when a submitter creates a ticket

In order for the MACHINE field and SUBMITTER field to automatically contain the machine and submitter information, there first needs to be assets created and associated to the systems listed in Inventory.  This will allow you the option to have a drop down selection to choose from along with a Filter.

If you want to go the extra step and have it auto populate the MACHINE name and/or the SUBMITTER, then a Ticket Rule will need to be created to auto populate this information.  Below is an example Custom Ticket Rule:

SELECT

  HD_TICKET.ID

FROM

  HD_TICKET

WHERE

  HD_TICKET.MACHINE_ID = 0 AND

  HD_TICKET.SUBMITTER_ID <>

UPDATE

  HD_TICKET Inner Join

  USER On HD_TICKET.SUBMITTER_ID = USER.ID Inner Join

  MACHINE On USER.USER_NAME = MACHINE.USER SET HD_TICKET.MACHINE_ID = MACHINE.ID WHERE HD_TICKET.ID IN (<TICKET_IDS>)

NOTE: If you would like any other field to auto populate, a custom ticket rule would need to be created for that field name as well or added to the above.

KACE Technical Support does not actively support the creation of custom ticket rules. Custom ticket rules can be created with the help of free support from ITNINJA bloggers or a request ticket submitted to Dell KACE ProServices for a quote in developing custom ticket rule(s) for your environment. 


Comments

  • I have noticed , if you create a ticket via portal using your a machine from which you daily logon and you have a user creaded on Kbox , then Kbox automatically assigns user name and machine name. however Asset need to be assigned manually.
    Alternatively, if you are using a new machine then make sure that kbox agent is installed and force the inventory once before creating a ticket. - afzal 12 years ago
  • I am getting the following error in the run log for this ticket rule:

    "03:17> Executing Select Query...
    03:17> mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE

    HD_TICKET Inner Join

    USER On HD_TICKET.SUBMITTER_ID = USER.ID Inner' at line 15] in EXECUTE("SELECT

    HD_TICKET.ID

    FROM

    HD_TICKET

    WHERE

    HD_TICKET.MACHINE_ID = 0 AND

    HD_TICKET.SUBMITTER_ID <>

    UPDATE

    HD_TICKET Inner Join

    USER On HD_TICKET.SUBMITTER_ID = USER.ID Inner Join

    MACHINE On USER.USER_NAME = MACHINE.USER SET HD_TICKET.MACHINE_ID = MACHINE.ID WHERE HD_TICKET.ID IN (<TICKET_IDS>)")"

    Any idea how I can fix this? - tbrownetc 11 years ago
    • the process used in this article is what you'll need to do if you are running 5.4. http://itninja.com/blog/view/5-4-ticket-rule-for-auto-assigning-computer-asset . Is this of any help? - brian_klocek 11 years ago
  • Thanks! - b.adams 9 years ago
  • I want the auto fill to take place before the ticket is saved, meaning as soon as they click on the "new ticket" option. Setting the custom ticket rule to run on ticket save wouldn't work so how do I schedule it? - ssexton 8 years ago
  • how would I pull USER.USER_NAME field in helpdesk ticketing page , purpose is to auto populate AD login name of user who is creating the ticket. I would like to populate USER.USER_NAME(AD_LOGIN_NAME) before or after ticket is created - rahimpal 8 years ago
This post is locked

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