Hello ITCM Team
Please there is a request on ITCM, I will like to explore the possibility of helping me spool computer records from ITCM with the ASSIGNED USERS (in this case the username with the highest number of logon).
kindly assist with a query that will be able to spool computers and to assign the user with the highest number of logon as the assigned user.
You can create a report that shows the computer, related users and the Registration count (number if time logged in or logged in when agent scan runs).
But this will show all users and counts so you would then need to manually edit to leave on the one with the highest registration count.