Which attributes are indexed in entitlement_Values table

[hirenp]

We are using custom query in the workflow to determine approvers. We rely on customproperty in entitlement_values table for the same. When a workflow is triggered through API it takes a long time so want to understand which attributes are indexed on this table.

[rushikeshvartak · Accepted solution]

Please raise Freshdesk ticket they should be able to help you

SELECT DISTINCT TABLE_NAME, INDEX_NAME FROM INFORMATION_SCHEMA.STATISTICS where TABLE_NAME='entitlement_values' ;

TABLE_NAME INDEX_NAME

entitlement_values	PRIMARY
entitlement_values	ENTITLEMENTID
entitlement_values	FK4C49B494123E1947
entitlement_values	FK4C49B494C4D9E91A
entitlement_values	FK4C49B494BE2C2920
entitlement_values	IDX_ENTVALUE
entitlement_values	ENTITLEMENTID_INDEX
entitlement_values	FK469E7074A3D4D351
entitlement_values	FK469E7074BE8E85C9
entitlement_values	ENTVALUESENTVALUE
entitlement_values	STATUS_IDX

[hirenp]

It doesn't look like I could run the above query in data analytics or Analytics report

[avinashchhetri]

Hello @hirenp,

If you are looking to see which customproperties are indexed in the entitlement_value table,then by default,  I believe none of them would be indexed.

[hirenp]

@avinashchhetri 

Would you be able to confirm if the query provided above in the post still holds good for latest version?

[rushikeshvartak]

Its standard sql query it has nothing to do with Saviynt version

https://tableplus.com/blog/2018/08/mysql-how-to-list-all-indexes-from-table-or-schema.html 

[hirenp]

It did not work for me in the data analyzer or analytics report. Let me know how did you execute it

[rushikeshvartak]

This is blocked on latest version of Saviynt. This was working from analytics/Data Analyzer till v5.5 

Please raise Freshdesk ticket they should be able to help you

[Dave]

@hirenp - This sounds like something you might want to request at https://ideas.saviynt.com/

[hirenp]

@Dave Do you mean to submit this idea to have this information available to customers? I would assume something like this to be documented and available for customers right out of the gate.

[Dave]

Hi @hirenp -- The fact that it was available in 5.5, but isn't anymore tells me they have their reasons for removing it.

But also, that feature was there in the beginning because they knew it was a valuable feature.

While I agree it would have been nice to have it out of the box, the fact is it isn't there. So asking for it on the Ideas portal is a good first step in trying to get it back again. (Or they will say no. It doesn't hurt to ask.) 

[hirenp]

@Dave Submitted a request on the idea portal. Hopefully, you guys can vote to priortize

[rushikeshvartak]

@Dave  Internal Schema table & some tables will not be exposed by data analyzer / Analytics such as password field so i dont think this will be accepted as idea