Asset Management Reporting

[Joyce]

Hi,

I need to create a report  with the following fields from the front end of asset management:

Name

State

Substate

Type

Used By

Owned By

Date Created

Model

Serial Number

from which table can I get state and Substate?, and how can I link them with CMDB computer Asset table?

 

Thanks.

 

Regards,

Joyce

[James Ainsworth]

Hi Joyce,

Using the Entity Viewer can be a great way to find the different tables and show the names and types of fields available on each table.  This can be a great help when it comes to creating reports.  I believe the table that you are looking for is the h_cmdb_asset_substate.

 

Regards,

James

[Joyce]

Thanks @James Ainsworth

Entity Viewer has been very useful.

 

Regards,

Joyce