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>

view raw

gistfile1.txt

hosted with ❤ by GitHub

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

Read more…

Categories: AutoPkg, Jamf Pro, JSSImporter
%d bloggers like this: