Showing Asset and Configuration assignment history in User's profile

SylwiaK
Tera Contributor

Friday

Hello Colleagues,

 

I need support with showing Asset and Configuration assignment history in User's profile (both CoreUI and SOW). Minimum would be Asset part.

Our Asset record is showing history of Assigned to, Configuration Item assigned to is not active and greyed out in Dictionary Entry (I assume because of  Discovery).

 

Case scenario:

Picture it like this, User A owned Notebook HOST1234 it was assigned to User A.
Two weeks later User A return the device and it gets handed to User B.
3 Months later I need to search the owner of this asset but I have no details anymore but only that User A had it previously.

 

In terms of CORE UI solution:

I added Asset and Configuration Item related list to User view, on the other hand I didn't manage to find proper assigned to history there.

 

In terms of SOW:

I am pretty new to configuring SOW and didn't make much of investigation.

 

Is it possible to configure Global search to show asset/configuration history?

 

I would appreciate your help

0 Helpfuls
  • 272 Views
1 REPLY 1

pr8172510
Tera Guru

Friday

Hi @SylwiaK,

Out of the box, neither Global Search nor the standard User form related lists maintain a searchable history of who previously owned an Asset or CI.

The current Assigned to value is stored on the Asset/CI record, while historical changes are captured in audit/history tables.

 check:

Asset Assignment History

If auditing is enabled for the Assigned to field on the Asset table (alm_asset), you can review historical ownership in:

System History > History Sets

or

sys_audit


filtering on:

Table = alm_asset
Field = assigned_to

This will show previous owners and when the assignment changed.


Configuration Item Assignment History

For CIs, the Assigned to field is often updated by Discovery, Asset-CI synchronization, or other integrations. If the field is audited, the history can also be found in sys_audit.


Core UI

Instead of adding only the Asset related list to the User form, consider:

  • Adding Asset related lists.
  • Creating a database view or report based on sys_audit for Asset assignment changes.
  • Creating a related list/report showing historical Asset ownership.


Service Operations Workspace (SOW)

You can configure a custom related list, data table, or component that displays Asset assignment history from sys_audit or a custom history table.


Global Search

Global Search does not search historical audit records out of the box. If searching by previous owner is a business requirement, the common approach is to:

  • Create a custom history table that stores ownership changes.
  • Populate it via a Business Rule when assigned_to changes.
  • Index that table for search/reporting.


For a long-term solution, I would recommend implementing an Asset Ownership History table populated from Asset assignment changes rather than relying solely on audit records.
This provides better reporting, searchability, and workspace visibility.

0 Helpfuls