A more unixy alternative to osquery is termsql (https://github.com/tobimensch/termsql https://github.com/tobimensch/termsql): it works with anything on the inpu

A more unixy alternative to osquery is termsql (https://github.com/tobimensch/termsql https://github.com/tobimensch/termsql): it works with anything on the input, so it's a matter of "ls"-ing the correct folder and then using SQL to output what you want.