Click HERE to see how Saviynt Intelligence is transforming the industry. |
08/12/2022 07:46 AM
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.
Solved! Go to Solution.
08/12/2022 08:01 AM
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 |
08/15/2022 08:34 AM
It doesn't look like I could run the above query in data analytics or Analytics report
08/12/2022 02:24 PM
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.
08/15/2022 08:35 AM
Would you be able to confirm if the query provided above in the post still holds good for latest version?
08/15/2022 08:37 AM
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
08/15/2022 08:44 AM
It did not work for me in the data analyzer or analytics report. Let me know how did you execute it
08/15/2022 09:48 AM
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
08/15/2022 12:27 PM
08/15/2022 12:36 PM
@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.
08/15/2022 12:51 PM
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.)
08/15/2022 01:20 PM
@Dave Submitted a request on the idea portal. Hopefully, you guys can vote to priortize
08/15/2022 12:49 PM
@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