Security

Reply
Highlighted
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,301
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: 8,637
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 Security TME
@timcappalli | timcappalli.me | ACMX #367 / ACCX #480
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: 8,637
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 Security TME
@timcappalli | timcappalli.me | ACMX #367 / ACCX #480
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
Regular Contributor I
Posts: 166
Registered: ‎04-11-2011

Re: Database query Endpoint Attributes

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

Guru Elite
Posts: 8,637
Registered: ‎09-08-2010

Re: Database query Endpoint Attributes

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

Tim Cappalli | Aruba Security TME
@timcappalli | timcappalli.me | ACMX #367 / ACCX #480
Regular Contributor I
Posts: 166
Registered: ‎04-11-2011

Re: Database query Endpoint Attributes

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.
Guru Elite
Posts: 8,637
Registered: ‎09-08-2010

Re: Database query Endpoint Attributes

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


Tim Cappalli | Aruba Security TME
@timcappalli | timcappalli.me | ACMX #367 / ACCX #480
Search Airheads
Showing results for 
Search instead for 
Did you mean: