Sample output from Jamf Pro MySQL commands referenced here: https://www.jamf.com/jamf-nation/articles/552/on-prem-jamf-pro-customers-upgrading-to-10-7-0

gistfile1.txt

[computername username]# mysql -u root -p
Password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2452003
Server version: 5.7.22-log MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use jamfsoftware
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select computer_group_id,criteria,criteria_display from smart_computer_group_criteria where criteria not in (select computer_group_name from computer_groups) and search_field="Computer Group";
+-------------------+----------+------------------+
| computer_group_id | criteria | criteria_display |
+-------------------+----------+------------------+
|               152 | Testing  | Testing          |
|               179 | Testing  | Testing          |
|               181 | Testing  | Testing          |
|               147 | Testing  | Testing          |
|               149 | Testing  | Testing          |
|               150 | Testing  | Testing          |
|               161 | Testing  | Testing          |
|               162 | Testing  | Testing          |
|               146 | Testing  | Testing          |
|               180 | Testing  | Testing          |
|               148 | Testing  | Testing          |
|               151 | Testing  | Testing          |
|               153 | Testing  | Testing          |
|               224 | Testing  | Testing          |
|               154 | Testing  | Testing          |
|               155 | Testing  | Testing          |
|               156 | Testing  | Testing          |
|               157 | Testing  | Testing          |
|               158 | Testing  | Testing          |
|               159 | Testing  | Testing          |
|               182 | Testing  | Testing          |
|               160 | Testing  | Testing          |
+-------------------+----------+------------------+
22 rows in set (0.01 sec)

mysql> select computer_group_id,criteria,criteria_display from smart_computer_group_criteria where binary criteria not in (select binary computer_group_name from computer_groups) and search_field="Computer Group";
+-------------------+----------+------------------+
| computer_group_id | criteria | criteria_display |
+-------------------+----------+------------------+
|               152 | Testing  | Testing          |
|               179 | Testing  | Testing          |
|               181 | Testing  | Testing          |
|               147 | Testing  | Testing          |
|               149 | Testing  | Testing          |
|               150 | Testing  | Testing          |
|               161 | Testing  | Testing          |
|               162 | Testing  | Testing          |
|               146 | Testing  | Testing          |
|               180 | Testing  | Testing          |
|               148 | Testing  | Testing          |
|               151 | Testing  | Testing          |
|               153 | Testing  | Testing          |
|               224 | Testing  | Testing          |
|               154 | Testing  | Testing          |
|               155 | Testing  | Testing          |
|               156 | Testing  | Testing          |
|               157 | Testing  | Testing          |
|               158 | Testing  | Testing          |
|               159 | Testing  | Testing          |
|               182 | Testing  | Testing          |
|               160 | Testing  | Testing          |
+-------------------+----------+------------------+
22 rows in set (0.02 sec)

mysql>