Want to know history of the assigned Computers to the all users in cmdb_ci

[rajeshbxr19]

Hi Community,

We are using the CMDB to manage assets in our organization. I would like to know if there’s a way to view the complete assignment history of a computer — specifically, all the users it has been assigned to over time. Could someone guide me on how to achieve this?

[Mark Manders]

OOB this table is audited, so you should be able to check on the history of the record to see all the assignees of an asset. It's also (OOB) captured in the activity log through field changes. 
If you are looking for a simple list of all computers and their assignees: there isn't one available OOB. 

Even from the user table, you can only query to the currently assigned assets. 

You could create metrics/PA indicators to collect the data but that will only show you the data as of that moment, not from the past.