Best Practices Question

How to filter users in the KACE reports

07/04/2018 933 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


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

All Answers

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?