Run the report on the cmdb_ci_computer table, having selected the Assigned to.User ID column to display the results of the report. The inactive users are visible on the run report screen, but they are not displayed in the exported Excel or .csv file.
The user query business rule (BR) is in place and prevents access to the inactive sys_user object and its fields for non-admin users. The business rule is enabled by default, but can be turned off to allow non-admin users access to the inactive user fields.
The business rule does the following:
Disallows access to interactive sessions (UI) and user fields to inactive users and non-admin users.
The business rule does not make sense in scenarios like this when an ITIL user who manages assets and incidents does need to see all the associated data. The BR can be enabled or disabled as required.
The business rule cannot be removed by default. The issue has come up on different occasions and the collective decision has been to advise the customer to disable the business rule if necessary.