ClearPass retrieve custom attributes via SQL
03-16-2018 10:23 AM
I am trying to use the external PostGreSQL to retrieve custom endpoints attributes. Similar to the problem described here:
I found the attributes in question in the tips_tag_defintiion view, but I cannot seem to get the SQL statement to work to retrieve the actual values from the tips_endpoints_attr_view view.
I always get the error message that the relation does not exist.
My SQL Query is this:
SELECT tag_value as wksnadport FROM tips_endpoints_attr_view
WHERE tag_name = 'wksnadport' AND mac_address = LOWER('001871490470')
Could you help?