Determining which packages are installed by which policies

[mthakur]

Hello everyone,

Given a list of packages of unknown provenance already uploaded into Casper Suite, is there an easy way to identify which packages are actually in use by at least one active policy, and which packages are not used by any active policy?

I'm smelling an SQL query might be required here, and if that's what it takes, so be it.

But ... if anyone has an easier answer, e.g. accessible via Casper Admin or the JSS, I'd much appreciate it.
Thanks!

[Kelly_Conrad]

Hey there!

Perhaps doing a JSS summary with the computer policies only is what you're looking for? Go to the gear on the top right of your JSS>JSS Information>JSS Summary and select only the Policies under the Computers section. Then when you view it, you'll see something like my screenshot below: Hopefully that's useful!

Edit: Saw we wanted only active policies, my suggestion above will require sorting through both active and inactive policies

[stevewood]

@mthakur For a non-JAMF answer, @andrewseago wrote a script that does just what you want. He posted about it on MacBrained:

JSS Used Files Report