select distinct entity_to_apply_type from t_av_unauth_changes
select distinct entity_to_apply_type from t_av_unauth_changes
Hey,
what do you mean by values sorry?
also, which version are you on?
its also advised to use public tables, as referenced here: RSA Identity Governance and Lifecycle 7.2 Public Database Schema Reference
or with this SQL to find the table you might want.
select * from user_views
where lower(view_name) like '%%'
order by view_name ascHello
version 7.1
now I get only one value - 'ET'
I guess it is "entitlement"
what are other values ?
בברכה
לילך בר נתן
מנהלת פרויקטים
פרולינק ניהול זהויות בע"מ
054-7750077
בתאריך יום ב׳, 17 בפבר׳ 2020 ב-15:12 מאת Jamie Pryer <no-reply@rsa.com
>:
<https://community.rsa.com/?et=watches.email.thread>
Re: which values can I get for this query -
reply from Jamie Pryer
in RSA Identity Governance & Lifecycle - View the full discussion
<https://community.rsa.com/message/949066?commentID=949066&et=watches.email.thread#comment-949066>
what is the table t_av_unauth_changes for?
again, this is a private table, which shouldn't be used for queries/reports in general.
what is it you are trying to do overall?
no, it is table which we get from aveksa rule 'Unauthorized chane
detection'
בברכה
לילך בר נתן
מנהלת פרויקטים
פרולינק ניהול זהויות בע"מ
054-7750077
בתאריך יום ב׳, 17 בפבר׳ 2020 ב-15:45 מאת Jamie Pryer <no-reply@rsa.com
>:
<https://community.rsa.com/?et=watches.email.thread>
Re: which values can I get for this query -
reply from Jamie Pryer
in RSA Identity Governance & Lifecycle - View the full discussion
<https://community.rsa.com/message/949069?commentID=949069&et=watches.email.thread#comment-949069>
I see.
what are you trying to do with this information?
It is a long story.
I need this information to continue my development.
what values is possible to this field ? it is a simple question .
maybe you can ask a technical support please ?
בברכה
לילך בר נתן
מנהלת פרויקטים
פרולינק ניהול זהויות בע"מ
054-7750077
בתאריך יום ב׳, 17 בפבר׳ 2020 ב-16:21 מאת Jamie Pryer <no-reply@rsa.com
>:
<https://community.rsa.com/?et=watches.email.thread>
Re: which values can I get for this query -
reply from Jamie Pryer
in RSA Identity Governance & Lifecycle - View the full discussion
<https://community.rsa.com/message/949074?commentID=949074&et=watches.email.thread#comment-949074>
I appreciate its a simple question however the point is that this is a table that is not supported overall and shouldn't be used in reports, as this can lead to potential issues in future and so is not recommended.
The reason im asking is so that we can help you to go about doing your task in a recommended fashion, so that it is future proof and continues to work.
We might need to create a new view for example, which you can use and would then have the correct terminology in that table, so you dont need to work this all out.
Hi Lilach,
Technical support will ask you the same thing. I.e. what do you need this info for? Because t_av_unauth_changes is an RSA Identity Governance & Lifecycle internal table and should not be used except by the RSA Identity Governance & Lifecycle application. If you need to query the database for any reason (ad hoc reports, workflows, etc.), please use our public views as Jamie said. There is a public schema guide that specifically documents all of our public views. Or, you can find them in the avdb schema prefaced by PV_
The reason we differentiate between public views and internal tables are several:
Regards,
Diane
Why don't you just roll with the generated CR from the unauthorized changes rule and take it to the workflow to handle the items the way you want it?
I can't force customers to create unreal information to understand how
the table behave when group and app role inset into it.
but it is really simple question - what values in this field for those
cases ?
בברכה
לילך בר נתן
מנהלת פרויקטים
פרולינק ניהול זהויות בע"מ
054-7750077
בתאריך יום ג׳, 18 בפבר׳ 2020 ב-9:56 מאת Frank Schubert <
<https://community.rsa.com/?et=watches.email.thread>
Re: which values can I get for this query -
reply from Frank Schubert
in RSA Identity Governance & Lifecycle - View the full discussion
<https://community.rsa.com/message/949126?commentID=949126&et=watches.email.thread#comment-949126>
Hi Lilach,
you have to ellaborate on the use-case here a bit. Please view it from the business side. You are already five steps ahead and we here in the forum need to guess what you are aiming at.
Until then I stand by my original statement of handling it in the workflow.
Frank
The answer to your initial question is:
WHEN 'user' THEN 'US'
WHEN 'account' THEN 'AC'
WHEN 'ent' THEN 'ET'
WHEN 'app-role' THEN 'AR'
WHEN 'global-role' THEN 'GR'
WHEN 'group' THEN 'UG'
WHEN 'other' THEN 'OT'
ELSE 'NY'
May we know more around the use case?
The answer to your initial question is:
WHEN 'user' THEN 'US'
WHEN 'account' THEN 'AC'
WHEN 'ent' THEN 'ET'
WHEN 'app-role' THEN 'AR'
WHEN 'global-role' THEN 'GR'
WHEN 'group' THEN 'UG'
WHEN 'other' THEN 'OT'
ELSE 'NY'
May we know more around the use case?