What useful information can be extracted from ODS Schema?

I. Get user’s full name

You can get the information from ods.ds_attrstore. For example:

SELECT o.entryid,

UPPER(o.attrval) user_name,

(SELECT first.attrval FROM ODS.DS_ATTRSTORE first WHERE first.attrname = 'givenname' AND first.entryid

= o.entryid) first_name,

(SELECT last.attrval FROM ODS.DS_ATTRSTORE last WHERE last.attrname = 'sn' AND last.entryid = o.entryid)

last_name

FROM ODS.DS_ATTRSTORE o

WHERE o.attrname = 'uid'

II. How to Get other Attribute Values?

Attribute values are stored in ods.ct_ATTRIBUTE_NAME table