We would like to get the following information from the endpoint repository database in Aruba ClearPass in a SQL statement. What is the correct PostgreSQL statement to get the those information:
- Online Status
- Connection Type
- Switch IP
- Switch Port
we already checked the public.tips_endpoints table but were unable to get the information required.
thanks a lot for your help
regards Michael