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

osquery

is it possible to read the contents of a file with osquery. context is we are currently dumping mdm enrolment date as a int value into a file. i just want to be able to read that value within the file

<@U9WAAKJ4S> If you can write the value to a file that is formatted as a plist you can use vanilla osquery to retrieve the value.

Otherwise, if you are using launcher, you can also read JSON files and could have chef output it that way.

Likewise, if you are using launcher, you have access to the kolide_mdm_info table which will give you data about your enrolled mdms