Security

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?

Can please elaborate of what you are trying to accomplish ?

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).

 

 

 

 

 

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?

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


Thanks, 
Tim

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

Did the tips_tags_value get renamed to something else?  I do not have this table in the tipsdb in ver 6.6.x

The schema changed in 6.6. Check on AFP for some more information.

Im not a partner, i dont believe I have access to afp

Thanks





Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation.

Ah sorry, thought you were. What query are you trying to build?