2 different nodes have the issue. These are custom nodes having below queries (have replaced ids with ***):
When the admin opens the dashboard by changing the role, the correct count is shown. However, all agents having that specific role face the issue.
Query 1
(active = 1) AND status IN (\'OP\') AND (type = \'I\') AND (log_agent = U\'***\' OR log_agent = U\'***\') AND NOT tenant.name IN (\'***\') AND (group!=U\'***\' AND group!=U\'***\')
Query 2
group=U\'***\' AND status=\'OP\' AND type = \'I\'
These nodes haven't been modified recently and have been created few months ago. The issue is being seen only now. So not sure if it has something to do with the queries.