AnsweredAssumed Answered

IGL 7.0.2 - how do we configure reviews to use application technical owners as reviewers

Question asked by Andy Cheek on Oct 15, 2018
Latest reply on Feb 13, 2020 by Andy Cheek

Like • Show 1 Like1
Comment • 6

Question is fairly self-explanatory. The review functionality allows you to select "asset owners" when defining reviewers in a review definition, but then the only options are role owner, business owner or group owner.

We want to use technical owner. How can we do this?

I'm guessing coverage file but is there any way to avoid hard-coding the application names and userids of the required setup? If technical owner is supported as a standard user attribute on business source - why can't we reference it here?

1 person has this question

Outcomes

6 Replies

Chris Pope Jul 5, 2019 8:02 AM
Mark Correct
Correct Answer
Great question. Seems that this should be an out-of-the-box review type but somehow it isn't. If IGL is supposed to be accurate, how can there not be a review of Owners?
Like • Show 0 Likes0
Actions
Jamie Pryer Feb 13, 2020 5:52 AM
Mark Correct
Correct Answer
Hey,
If you create a new "user attribute" then this will show as a section field in the review options.
You can also create a simple SQL query/report, that you can use to dynamically create you coverage file each time, if you want something more flexible.
Like • Show 0 Likes0
Actions
- Andy Cheek @ Jamie Pryer on Feb 13, 2020 6:53 AM
  Mark Correct
  Correct Answer
  Jamie Pryer Marking your own answers as "correct"? Like it.
  
  New attribute? No. Why should we have to add and manage more custom data when the application should take account of that option in this particular context.
  Will have to go with SQL query into coverage file, I reckon.
  Like • Show 1 Like1
  Actions
  - Jamie Pryer @ Andy Cheek on Feb 13, 2020 6:59 AM
    Mark Correct
    Correct Answer
    Fair point Andy!
    we should raise an idea to have that attribute included, im actually more surprised that its not.
    Clive Morrish has some great examples of coverage file SQL im sure he can share with us here too
    Like • Show 0 Likes0
    Actions
Clive Morrish Feb 13, 2020 8:22 AM
Mark Correct
Correct Answer
Hey Andy,

Although the below isn't exactly inline with your requirements, it's a format I use for generating coverage files instead of manually managing them:

SELECT -- APP ROLE SUPER USER TO BUSINESS OWNER
'user_id='||''''||pUSR.USER_ID||'''|user'||'|'||'1=1'||''||'|'||'app-role|name='||''''||vAUE.NAME||''''||' AND APPLICATION_ID ='||''''||pAPP.ID||'''' AS COVERAGE_REVIEWER
FROM avuser.V_ALL_UNIFIED_ENTITLEMENTS vAUE
JOIN avuser.PV_APPLICATION pAPP
ON vAUE.APPLICATION_ID = pAPP.ID
JOIN avuser.PV_USERS pUSR
ON pAPP.BUSINESS_OWNER = pUSR.ID
WHERE vAUE.ENT_TYPES = 'app-role'
AND LOWER(APPROLE_CAS3) = 'superuser'

This example assigns the Business Owner of the application as the Reviewer of application roles tagged as superuser.

However, I wasn't exactly sure what you meant by 'is there any way to avoid hard-coding the application names and userids of the required setup' in your original question?

Thanks,
Clive
2 people found this helpful
Like • Show 1 Like1
Actions
- Andy Cheek @ Clive Morrish on Feb 13, 2020 9:39 AM
  Mark Correct
  Correct Answer
  Hey Clive Morrish
  
  All I meant was could we do it with a 1 line coverage file, along the lines of application|1=1|entitlements|1=1|app.technical_owner but I couldn't see that that would work. Was curious.
  
  No worries.
  Like • Show 1 Like1
  Actions

IGL 7.0.2 - how do we configure reviews to use application technical owners as reviewers

Outcomes

Related Content

Recommended Content