Phantom groups, MySQL queries and Jamf Pro 10.7

On September 13th, Jamf released a new KBase article for Jamf Pro customers who hosted Jamf Pro themselves instead of hosting in Jamf Cloud:

On-Prem Jamf Pro Customers Upgrading to 10.7.0: https://www.jamf.com/jamf-nation/articles/552/on-prem-jamf-pro-customers-upgrading-to-10-7-0

In the KBase article, Jamf provides a couple of MySQL commands to run:

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";

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";

If either query returned data, the KBase directs you to contact Jamf Support. This was my output:

	[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>

view raw
gistfile1.txt
hosted with ❤ by GitHub

What had happened? For more details, please see below the jump.