/build/static/layout/Breadcrumb_cap_w.png

Best Practices Question


How to filter users in the KACE reports

07/04/2018 1239 views
I'm wondering if there is a way to filter out a specific user from a report? In specific I need to exclude one user from the reports that I generate. I normally run Service Desk reports on tickets by category and by user. I sadly do not know a thing about SQL. I'll gladly take any assistance or advice on this matter!
0 Comments   [ + ] Show comments

Comments

  • This content is currently hidden from public view.
    Reason: Promoted to an answer For more information, visit our FAQ's.

All Answers

0
Hi, You can take a look at the user ID navigating to "settings --> Users". Once pointing the user (not clicking) you´ll see the user ID in the bottom left like "your_KACE_SMA_IP/adminui/user-php?userid=15". Please note the ID 15 Afterwars I´ll suggest you to duplicate the report that you are going to run and edit the SQL statement of the new report modifying the "WHERE" clause. For example: where ... AND USER.ID != "15" Then run the new report and verify it is working as expected. Regards
Answered 07/05/2018 by: Joxan
White Belt

  • That did not work.
    • Which report are you runnig? Could you post the SQL statement please?
 
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