Finding the Table containing a value

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

Which IIQ version are you inquiring about?

8.4

Please share any images or screenshots, if relevant.

image
image1056×341 21 KB

*

Share all details about your problem, including any error messages you may have received.

Hello,
Thank in advance for taking a moment to look at my question.
I am looking for help to find the table specific data is in so that I can determine the scope of a problem. When I go into debug, navigate to Bundle, go into an entry and then see this entry:

  \ApplicationRef
  Constraints
    Filter operation="CONTAINS_ALL" property="null"

I am looking for what table contains this entry.
I’ve checked spt_bundle, spt_bundle_requirements, spt_bundle_profile_relation etc.
But I haven’t found this data.

I primarily work within the db, my strengths being in sql.
I am sure there is a way to write a rule to find the data, and I may do that.
But I would prefer to find the data in the table.
If there is a resource that I can use to find where OOTB values map that would also be helpful for any future odd issues I run into.

Thank you again.
*

2

Hi @scosmith123 ,

spt_profile, spt_profile_constraints table provide the details about bundle profile and profile constraints.

Try with below query which will return the expected entry

select * from spt_profile_constraints where profile='0ad4056497d4108b8197f82254b5325c'
1 Like
3

@Arun-Kumar

Thank you. It was in the spt_profile_constraints in the elt column.