How to filter users in the KACE reports
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
Answers (1)
Please log in to answer
Posted by:
Joxan
6 years ago
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