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