Security

Reply
Contributor II

ClearPass retrieve custom attributes via SQL

Hi,

I am trying to use the external PostGreSQL to retrieve custom endpoints attributes. Similar to the problem described here:

 

http://community.arubanetworks.com/t5/Security/SQL-Query-of-Airwatch-Endpoint-attributes/td-p/228103

 

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?

 

kind regards,
Jens Pfennig

Search Airheads
cancel
Showing results for 
Search instead for 
Did you mean: