Granting Read-Only Access to the JAMF Software Server MySQL Database
Updated: 04 March 2022
Product: Jamf Pro
This article describes how to grant read-only access to the Jamf Pro MySQL database to perform database queries. If you need to perform direct queries of the Jamf Pro MySQL database (for example, from an organization's inventory, asset tracking, or help desk system), you should create and use a MySQL account with read-only privileges. You can do this in one of two ways:
Using MySQL Workbench, available at: https://dev.mysql.com/downloads/workbench/
From the command line
Note:
If you have specific questions about performing queries on the Jamf Pro MySQL database, contact Jamf Support.