Data Connect - query endpoints_data and ENDPOINT_IDENTITY_GROUPS

[doz]

Greetings all, 

Is there a way i can use dataconnect and get endpoints that belongs to endpoint identity group ? with ERS api this is pretty easy but with dataconnect i can not find any of the fields that refer to each other. None of the columns are matching 

https://developer.cisco.com/docs/dataconnect/database-views/#endpoints_data

Thank you for hints and recommendations. 

[Gagandeep Singh]

Hi @doz 

How are you connecting to the ISE MNT schema via data connect. 
When I last tested with splunk integration using data connect. I remember seeing the endpoint database fully. It's all SQL based query. I believe you can get IDs of the MAC address and see the associated attributes.

Document for reference on ISE - What we need to know about Data Connect 

https://community.cisco.com/t5/security-knowledge-base/ise-what-we-need-to-know-about-data-connect/tac-p/5318692#M9347

Hope this helps!!!

Regards

Gagandeep Singh