Is there a way to query the Expedition database from the cli using mysql tools? I'd like to run custom audit queries against an imported configuration and it seems like Expedition has done all the hard work of parsing the configs into structured data. Not looking for anything fancy - just read-only access to the database to run SQL queries.
I could, but I'd end up sending you a list of 60+ controls we audit for, and some are fairly complex like "show me all the policies that control traffic to the internet with a profile group that doesn't have packet capture enabled in the AV profile". These types of reports are very specific to our controls and would likely be meaningless to the larger community, so I would rather be the guy that learns to fish instead of expecting someone to hand me fish. 🙂 If I could get ODBC access to the database I could write these queries pretty quickly - assuming you have a reasonably normalized data model - so that's what I'm after. And if I need to do it through MySQL tools right on the box that's OK too. The alternative is I write a parser for the config files and get it all in a database myself, but as I mentioned, it sure looks like Expedition already does this so if I can avoid re-inventing the wheel that would be preferable.
Click Accept as Solution to acknowledge that the answer to your question has been provided.
The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!
These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!
The LIVEcommunity thanks you for your participation!