Zack T
7d96952e68
Adding new query to find devices with multiple attachments
2024-07-04 16:23:04 -07:00
Zack T
065e00f7b1
Improved Policy Overview Query
2024-07-01 13:08:24 -07:00
Zack T
3b72f409f2
Add custom DB Settings
2024-06-21 12:26:04 -07:00
Zack T
c9cc5d77e4
Adding query to get where a script is used
2024-06-19 22:18:53 -07:00
Zack T
b7c91c53fc
Adding new query for Policies with no configuration
2024-06-19 22:18:08 -07:00
Zack T
209d19794c
Removed defunct reference & changed table reference
...
- Removed attribute reference to removed Policy event
+ Changed table reference
2024-06-19 22:17:31 -07:00
Zack T
547d2c9be6
Improved/corrected query
...
+ Improved/corrected Site identification
+ Report additional meta data
2024-06-18 15:39:47 -07:00
Zack T
1f49bd38e0
Minor improvements
...
+ Add error percentage
+ Add Profile ID
+ Add example of how to Filter by Install/RemoveProfile
2024-06-18 15:36:03 -07:00
Zack T
9ffbd7dc4a
Add Database and Table Size Queries
2024-06-18 12:41:02 -07:00
Zack T
74e8156ee8
Get icon image for reference
2024-06-17 17:36:22 -07:00
Zack T
fc484aa25a
Get additional printer info
2024-06-17 17:36:02 -07:00
Zack T
1e8809b452
Improved VPP App queries
2024-06-17 17:34:14 -07:00
Zack T
ab7edfde9d
Misc cleanup, comment improves, etc.
2024-06-17 17:12:52 -07:00
Zack T
1ec54d11a4
Improved "under-stability" of query results
...
+ Correct certain logic to better match Jamf provided best practices
- Removed double negative-type situations
2024-06-17 17:08:30 -07:00
Zack T
8686339132
Fixed Regex string comparison
2024-06-17 16:57:51 -07:00
Zack T
512415bd41
Adding support for the latest OS versions released today
2024-06-11 21:25:07 -07:00
Zack T
25a36455d4
Another model fix
...
The compatibility table I was referencing incorrectly listed iPad3,[4, 5, 6] as only support up to iOS 9; they actually support up to iOS 10.
2024-02-09 10:11:57 -07:00
Zack T
d9ad8e7cd3
Adding filtering into main query
2024-02-08 13:13:53 -07:00
Zack T
9f1caedde9
Additional Bug Fix
2024-02-08 13:13:04 -07:00
Zack T
fcbc76e5e4
Update and future proof DDM support logic
2024-02-07 18:24:40 -07:00
Zack T
535209a5b9
Bug fix and tweak to query
...
+ Wrong table reference (bad copy/paste I'm sure)
+ Also only return devices that are still managed in the results
2024-02-07 18:23:23 -07:00
Zack T
6d3646b94c
Fixed Incorrect Regex Patterns
2024-02-07 18:21:28 -07:00
Zack T
a14fa57307
Query improvements
...
+ No reason for a LIKE comparison here
+ Removed table joins that were not utilized
2024-02-07 18:20:19 -07:00
Zack T
2d125910ca
Spell checks
2024-02-07 18:19:22 -07:00
Zack T
5b8a40c6e0
Miscellaneous new queries
2024-02-06 09:02:55 -07:00
Zack T
43c0f5dacc
New query for Management Health
...
Adding:
+ Mobile Devices that have failed to renew their MDM Profile
+ _And_ the MDM Profile has already expired
2024-02-05 16:50:39 -07:00
Zack T
c9a3ec0dea
Adding attributes to the Management Health query
...
Adding:
+ Device Certificate Expires
+ Failed to Renew MDM Profile
2024-02-05 16:33:23 -07:00
Zack T
163acd17f9
New queries for Management Health
...
Adding:
+ Computers Checking-In after MDM Profile has expired
+ Computers that have failed to renew their MDM Profile
+ _And_ the MDM Profile has already expired
2024-01-11 22:58:38 -07:00
Zack T
cfddac2ee8
Adding attributes to the Management Health query
...
Adding:
+ Device Certificate Expires
+ MDM Certificate Expires
+ Failed to Renew MDM Profile
2024-01-05 15:40:31 -07:00
Zack T
3643cfc2d6
Formatting and syntax standardization
2024-01-05 15:36:34 -07:00
Zack T
cf967108af
Adding: Fix mismatch number of records
2024-01-05 15:31:16 -07:00
Zack T
38c347be31
New queries for finding duplicate icons
2024-01-05 15:26:30 -07:00
Zack T
7d9e854869
Query Improvements
2024-01-05 14:55:55 -07:00
Zack T
c0a8815f6b
Updates for table changes
2024-01-05 13:17:47 -07:00
Zack T
9fe078e6eb
Adding Patch Monitoring for Sonoma
2023-11-03 12:59:17 -07:00
Zack T
0c4e1cfb3e
Minor improvements
...
* Improved description verbiage
* Spell checking
* Syntax Case
2023-11-03 12:58:34 -07:00
Zack T
6cc0c14b1f
Adding support for the latest OS versions released today
2023-06-05 17:00:30 -07:00
Zack T
25065305f9
Added new query to track recurring App Store App Installs
...
This query isn't limited to the past twenty-hours as well and isn't limited to a "completed" date
2023-05-08 17:40:57 -07:00
Zack T
99a6746172
Identify both App and Device Site
2023-05-08 17:34:22 -07:00
Zack T
4abaa90632
Tweak to devices that have enrolled recently, but not managed
...
Look at _*last*_ enrollment not, not initial enrollment date
2023-05-05 18:11:44 -07:00
Zack T
9849480bce
Duplicate device logic tweak
...
When looking for duplicate devices, only care if the records are managed
2023-05-05 18:10:16 -07:00
Zack T
1fdeaaaa42
Bug fixes/corrections in logic
2023-05-05 18:07:49 -07:00
Zack T
3b94b5c2d4
Minor syntax changes
2023-05-05 18:06:47 -07:00
Zack T
f6e55f10cd
New Queries for MDM Commands includes Config Profiles
2023-03-21 00:42:11 -07:00
Zack T
1072d14083
Removing file containing duplicate queries
2023-03-21 00:35:15 -07:00
Zack T
7bf1ea2f16
Added Full Overview Queries for Groups
2023-03-21 00:34:35 -07:00
Zack T
84ad628037
Misc cleanup/improvements/fixes
2023-03-21 00:33:38 -07:00
Zack T
509f160b1e
Added totals for individual models and families
2023-03-20 23:49:00 -07:00
Zack T
6292725a69
Re-organizing files
2023-03-20 23:27:43 -07:00
Zack T
f0c925b463
New queries to help identify objects to clean up
2023-02-14 18:18:06 -07:00
