Looking for guidance/advice

New Contributor

This may be a tall order, but I am part of a team with an ongoing project to audit all the devices in our business unit (around 15K). Currently, this is being handled by downloading reports of each site in JAMF and using Excel formulas and pivot tables. It works fairly well for most of the columns of information we are auditing, but it doesn't work for checking if a device has been locked. What I'd like to do is have a system to check the record in JAMF for a lock code being issued (pending or processed) and then produce a value of yes/no/pending with the date, if it is yes/pending. I'm at a loss currently on where to begin with this, so any helpful tips or ideas would greatly be appreciated.