Posted on 01-22-2015 10:50 AM
Hi All, is it possible to query the API for completed status of a policy, Also, is there a way to see/get this information from the JSS mysql database?
Thanks
Solved! Go to Solution.
Posted on 01-22-2015 12:28 PM
Looking at the MySQL tables, it seems that policies only hold information about the policy entry itself, rather than the logs / statuses. There is a table called logs which appears to hold the policy log entries which might hold the info you're looking for but there doesn't appear to be any API options for it.
I have looked at accessing the MySQL DB directly before and much prefer using APIs where possible. The main difficulty, apart from not being officially supported, was correlating data from one table to another. Information for individual items you can see in the JSS web interface can be spread over lots of different MySQL tables with no obvious way to correlate them.
Posted on 01-22-2015 11:07 AM
Not via the API that I'm aware of. You can get a lot of information on the policy's configuration and settings, but not its current complete/not complete status.
Not sure about MySQL, but my uneducated guess would be yes its possible, since the JSS is obviously storing it and displaying it in the JSS console.
Posted on 01-22-2015 12:28 PM
Looking at the MySQL tables, it seems that policies only hold information about the policy entry itself, rather than the logs / statuses. There is a table called logs which appears to hold the policy log entries which might hold the info you're looking for but there doesn't appear to be any API options for it.
I have looked at accessing the MySQL DB directly before and much prefer using APIs where possible. The main difficulty, apart from not being officially supported, was correlating data from one table to another. Information for individual items you can see in the JSS web interface can be spread over lots of different MySQL tables with no obvious way to correlate them.
Posted on 01-23-2015 09:11 AM
Thanks for the info guys!!
Posted on 03-23-2015 01:17 PM
Bump for a feature request in the api...having pass/fail easily pulled from api would be amazing.