We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Database Query to get organization attributes details

prachi
Regular Contributor II
Regular Contributor II

Hello Everyone,

 

We have a requirment that in an organization we have different attributes entry for each Business Area and for each of the Business Area attribute , we store some related information about this 
under the respective attribute of the organization as shown in the figure.

prachi_0-1697716814967.png

 

But when I am trying to access the information through query on the table "customer_attribute" , 
I am able to see the key attribute names for each attribute but the values are not present in them. Can someone please suggest which table would contain the inner information about an attribute on the organization in Saviynt.

 

For example : select * from customer_attribute where customer_key='XXXX'
This would give me information like this after running query on the attributes column for each main attribute.
[{"attributeName":"Source"},{"attributeName":"BusinessArea"},{"attributeName":"BrandName"},{"attributeName":"BrandID"},{"attributeName":"BusinessAreaID"},{"attributeName":"Classification"}]
but I need to know attribute values of these.

 

Thanks,

2 REPLIES 2

DaanishJawed
Saviynt Employee
Saviynt Employee

Hi @prachi - Please use the below query using analytics/intelligence section.

SELECT CUSTOMER_ATTRIBUTEVALUESKEY,
ATTRIBUTENAME,
ATTRIBUTEVALUE,
ATTRIBUTE_GROUP_NAME,
CUSTOMERKEY,
CUSTOMER_ATTRIBUTEKEY,
UPDATEUSER,
ATTRIBUTE_GROUP_GUID,
VALUE
FROM customer_attributevalues;

 

rushikeshvartak
All-Star
All-Star

Please use below query 

SELECT c.customername,
       ca.attributename,
       ca.attributevalue,
       ca.attribute_group_name,
       attribute_group_guid VALUE
FROM   customer_attributevalues ca,
       customer c
WHERE  c.customerkey = ca.customerkey
       AND customername = 'BaBrandTest' 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.