Show a user's CI history

[Kenny_vl]

I can't believe we are the first with this business requirement but I couldn't find any related topics.

The requirement: Provide an easy-to-use approach to show a certain user's CI history.

Basically, itil users should be able to see (either from a related list or from a report) which CI's have been assigned to a specific user in the past. 

The research: The sys_audit table would be the best place to start IMHO but it times out when trying to query the +75M records in this table. sys_history_line does not provide all data due to table rotation. Metrics would be an option but unfortunately metrics data will only be shown from the metric has been created (logically).

This is why I am turning to you, dear community members, to chime in and give me some ideas please? 

Any help would be appreciated !

[Pratiksha]

Their is related list on user table to check the asset assigned to user. Their you can see what all been assigned. Asset -> assigned to

[Kenny_vl]

Yes, the CURRENT assigned CI. As you can read, I want to display the history. 
Meaning : CI's that are no longer assigned to this user but have been in the past.

[Pratiksha]

I think you should check hardware asset lifecycle history. I saw this on a video. Sharing the link 

; https://www.youtube.com/watch?v=bWAkp2womxY

If you do not want to use the app the next resort will be performance analytics.  

[RajeshS45028713]

Hi Kenny_vl,

I also have the same requirement. Could you please suggest a solution if you have already received one? Any inputs from you or anyone else would be greatly appreciated.

Thanks in advance,
Rajesh