Skip navigation

TSCO - PV_SYS_TAG Public View enhancement

score 0
You have not voted. Below Review Threshold

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.

 

 

Business Reason

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.

Comments

Vote history