Running a Report with Asset state and substate and CI status

[dgos7]

I am looking for a simple report for Asset column State and Substate and CI column Status.

Reporting structure in for SL has a table structure for Asset and table structure CI. I am assuming that both CI and the Asset both in a table of higher hierarchical value. This would allow me to run a report that has both column values of Asset and CI. I can not find it, and looking for the SL wiki I am not seeing this besides the mention of Database Views for Service Management plugin. I know they share data, and maybe a key with the serial number and the relation should be easy.

Any help would be great

[Steve McCarty]

There are actually reference fields on the CI and Asset tables that point to each other.   The CI table has a field called asset and the Asset table has a field called CI.   So you can create a report from either table and get information from the other through that reference field.   It is important to note that not all CIs are assets and not all assets are CIs so some records will not have a reference in that field.   That is based on the model category of the CI or asset as it is created.

Below is a quick report I created from the asset table that shows the asset states and substates in the columns and the CI statuses in the rows.   This just shows the count of the assets in each particular state.   You can create any type of report you want that uses information from both tables.

-Steve