Need to add a department to monitors in Asset Management

Products

• IT Management Suite
• Asset Management Solution
• Asset Management Suite

Issue/Introduction

We have an asset type of "Monitor" and it looks like it is connected to "All Assets" and has a Monitor Department field setup on it.  I need some help understanding where this "Monitor Department" is setup and pulling from so we can get our database to correctly pull reports on it.

Environment

ITMS 8.x

Asset Management 8.x

Cause

Need to created a custom "Resource Type" instead of a custom dataclass. 

Resolution

Created a custom data class for Monitor Department, with one attribute, a SQL query list.

The following query brings back all currently defined Departments:

select Name from vDepartment order by Name

Then added the data class to the Monitor resource type and were able to see the custom data class when editing a Monitor and verified that the list of departments showed when pulling the drop-down.