Archive
Archive for September, 2018
Phantom groups, MySQL queries and Jamf Pro 10.7
September 19, 2018
2 comments
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:
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[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> |
What had happened? For more details, please see below the jump.
Categories: AutoPkg, Jamf Pro, JSSImporter
Recent Comments