06-09-2013 06:33 PM
i got a question, how to acquire the latest posture scan information ( Healthy/Unhealthy, date/time) a client has done so that these information can be used as condition of a service? looks like i can SQL query the logdb, but anyone can provide the details?
06-10-2013 09:05 AM
Can you explain what you are trying to do?
By default the posture token is cached until changed by CPPM so long as that check box is checked off in the enforcement policy.
So TIPS > Poture > = > Healthy (or 'not healthy' is what most people use);
06-11-2013 05:46 PM
we have same requirement where Zach Jennings talked about at 18min of his [video]Clearpass Managment Basics (http://community.arubanetworks.com/t5/Community-Knowledge-Base/VIDEO-ClearPass-Management-Basics/ta-p/74536); he did it by doing SQL quiery to logdb but i could not find any information about logdb from this site
06-12-2013 01:08 PM
Yeah, i know what you are talking about;
The qurey he was building was in 5.2; in 6.x we migrated everything into insight and so logdb i dont think exists anymore;
You would need to use either insightdb or tipsdb.
tipdb would work if you want to use an endpoint as your referance.
Insight basically has everything else.
Overall you need to create a custom pgsql authentication source and edit the filters to get the data you want.
If you need the 5.2 query i can get that for you, but when it comes to 6.x it wont work.