Security

Reply
Contributor II
Posts: 47
Registered: ‎08-10-2014

Database query Endpoint Attributes

Can i with an database query in someway also retriev the attributes from an Endpoint? If i a browse around in the tipsdb or use insight i can get the profile information like Mac, ipaddress, hostname and so on. I would like to retreiv the attributes added to and enpoints, is this possible? Has anyone else done this?

MVP
Posts: 4,016
Registered: ‎07-20-2011

Re: Database query Endpoint Attributes

Can please elaborate of what you are trying to accomplish ?
Thank you

Victor Fabian
Lead Mobility Engineer @ Integration Partners
AMFX | ACMX | ACDX | ACCX | CWAP | CWDP | CWNA
Guru Elite
Posts: 7,852
Registered: ‎09-08-2010

Re: Database query Endpoint Attributes

Attributes are defined in the tips_tag_definitions table.

 

The tips_tag_values table maps the endpoint attribute (tag_id) and value (tag_id) to the endpoint (id).

 

sql_tips-tag1.PNG

 

sql_tips-tag2.PNG

 

 

 


Tim Cappalli | Aruba ClearPass TME
@timcappalli | ACMX #367 / ACCX #480 / ACEAP / CWSP
Contributor II
Posts: 47
Registered: ‎08-10-2014

Re: Database query Endpoint Attributes

thx cappali, do you know how the relations are setup, how i can map the endpoints to fetch their attributes? By using a query using the mac of the device?

Guru Elite
Posts: 7,852
Registered: ‎09-08-2010

Re: Database query Endpoint Attributes

Take a look at the SQL queries in the [Endpoints Repository] authentication source. 


Thanks, 
Tim

Tim Cappalli | Aruba ClearPass TME
@timcappalli | ACMX #367 / ACCX #480 / ACEAP / CWSP
Occasional Contributor II
Posts: 26
Registered: ‎06-29-2012

Re: Database query Endpoint Attributes

Hi there, did you get anywhere with this? I am trying to get a posture report that shows the "hostname" instead of MAC Address and believe your way is the way to unless Aruba provide some custom templates. Thanks Ken
Search Airheads
Showing results for 
Search instead for 
Did you mean: