Developing Custom Queries With Open-AudIT

Join Mark Henry as he walks through the development process to create a custom SQL statement to query through Open-AudIT.

No matter how many canned reports you have, there’s always a need for a modification or a custom report. Join us for this 45-minute session while we learn:

- How Open-AudIT differentiates queries, reports, and summaries, and how you can edit each.

- How to piece together the tables and fields in the Open-AudIT database to create any kind of report you want, quickly and easily.

- Methods for troubleshooting your custom query, and ensuring it’s running as quickly and efficiently as possible.

- What resources are available to help you when you get stuck.

Helpful Links:

- [Open-AudIT Wiki Home Page](https://community.opmantek.com/display/OA/Home)

- [Open-AudIT Forums](https://www.open-audit.org/phpBB3/)

- [Open-AudIT Questions Board](https://community.opmantek.com/display/OA/questions/all)

- [How do Reports Queries and Summaries work?](https://community.opmantek.com/x/zwCCAQ)

- [Summaries](https://community.opmantek.com/x/swFuAQ)

- [Queries](https://community.opmantek.com/x/rQVuAQ)

- [Creating, Populating and  Reporting on Custom Fields](https://community.opmantek.com/x/lxCCAQ)

- [MySQL Tutorials](http://www.mysqltutorial.org/)

- [MariaDB Tutorials](https://mariadb.org/learn/)

- [Custom Fields in Open-AudIT](https://opmantek.com/custom-fields-in-open-audit/)

- [All Hail Notepad++](https://notepad-plus-plus.org/)