Database Query to get organization attributes details

[prachi]

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.

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,

[DaanishJawed]

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 · Accepted solution]

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'