Reporting help.
I'm trying to create a report that among other things show if the PC in inventory has been scrapped. Our Asset Information has what I think is a custom field for "Scrapped?". I'm not sure how to get that field to show in my report. This is what I have so far.
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
chucksteel
7 years ago
You'll need to identify the table and field that contains the information in the database. The asset data ID for computers should be 5 so that data should be in ASSET_DATA_FIELD5, I think. The field ID will also be unique to your environment. I recommend using MySQL Workbench to connect to the database and looking at the ASSET_DATA tables to get the column names that you will then include in your report.
