Osquery uses basic SQL commands to leverage a relational data-model to describe a device.

osquery

Does someone have an example apple MDM profile with `CodeRequirement` set? (i.e. <https://fleetdm.com/docs/using-fleet/enroll-hosts#obtaining-identifiers>

hmm. <https://github.com/ducksrfr/mac_admin/blob/394a33c8042458d3706073253c4b548a53b5672d/Privacy%20Preferences%20Policy%20Control%20Profiles/PPPC_Jamf.mobileconfig#L53|https://github.com/ducksrfr/mac_admin/blob/394a33c8042458d3706073253c4b548a53b5672[…]references%20Policy%20Control%20Profiles/PPPC_Jamf.mobileconfig> is helpful

Hey <@U06FS72M2EB>, is this something you're still working on? You can get the value for `CodeRequirement` by running `codesign -display -r - &lt;/path/to/app&gt;`

I wasn't sure which part of the output to use. Turns out you have to grab the whole string (which isn't nicely delimited)