The Public View name is - PV_SYS_TAG
The fields that I would like to include is –
- ACCOUNTID from ENT_TAG SQL Table
- RELEVANCE from TAG_TYPE SQL Table
This Public View for PV_SYS_TAG is created using the following SQL Code. The two (2) new field are already available within the JOIN statement and, as such, they only need to add those fields into the SQL Query.
We are current using “V_SYS_OBJ_TAG” View to extract the ACCOUNTID field. This information is needed to identify the person that Tagged the system, as we use tags to identify life-cycle of any Capacity Risk of a system. The second field, RELEVANCE, is needed to identify the sequence of when the Tag Rules are applied. We are also using this field to group similar Tag Types together.