Jump to content

Asset Management Reporting


Joyce
 Share

Recommended Posts

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

Link to comment
Share on other sites

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.

image.png

 

Regards,

James

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...