/build/static/layout/Breadcrumb_cap_w.png

User Field Type Custom Field and Reports - How to display the Name of the User

I set up a custom field in KACE that is Field Type User.   I am referencing this field in a Kace report but instead of the name of the user (Which is displayed in the ticket) it is bringing up the KACE ID of the User, which isn't what I'm looking for.  I would like the name of the User to be displayed.  


And if is possible I would like to know how to get the Login and Email of the User to be displayed in the report as well.


0 Comments   [ + ] Show comments

Answers (1)

Posted by: Hobbsy 1 month ago
Red Belt
0

You will need to link the USER field to you HD_TICKET field in the report, if you do the join on HD_TICKET.SUBMITTER_ID and USER.ID you will then be able to pull in USER.NAME and USER.EMAIL to show what you would like.



Comments:
  • Great, can i do that from KACE Admin, or the reporting wizard? - MC9921 1 month ago
    • No but if you would like to share your reports SQL we may be able to sort it out for you. - Hobbsy 1 month ago
 
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