Skip to main content
Question

how to generate software reports

  • July 22, 2020
  • 4 replies
  • 29 views

ImAMacGuy
Forum|alt.badge.img+23

Our asset management dept is asking how to get reports of software installed on machines. I can output an applications list, but it's WAY too detailed, meaning minor versions are all listed separately per device which makes it way too complicated to sort through.

They want something like BigFix provides, though they weren't able to provide an example.

Anybody have any thoughts on how to export a list like that?

4 replies

Forum|alt.badge.img+6
  • New Contributor
  • July 23, 2020

you can use Api to get the list of Softwares installed on your device.


Jobst
Forum|alt.badge.img+1
  • New Contributor
  • July 23, 2020

I‘ve modified the script from @kendalljjohnson
It creates a nice, combined .csv.


Forum|alt.badge.img+31
  • Honored Contributor
  • July 27, 2020

Are you able to execute code locally for this?

mdfind -0 -onlyin /Applications "kMDItemKind == Application" | xargs -0 mdls -name kMDItemDisplayName -name kMDItemVersion -name kMDItemPath

You can also call the mdmclient which also if I recall uses Spotlight meta data

sudo /usr/libexec/mdmclient QueryInstalledApps

Getting it out of jamf API might be a bit crunchy and taxing since it will have to hit every single device record endpoint. However, that is also an option. Running the Spotlight command and shipping the data somewhere is also an option.


kwoodard
Forum|alt.badge.img+12
  • Valued Contributor
  • May 31, 2023

Are you able to execute code locally for this?

mdfind -0 -onlyin /Applications "kMDItemKind == Application" | xargs -0 mdls -name kMDItemDisplayName -name kMDItemVersion -name kMDItemPath

You can also call the mdmclient which also if I recall uses Spotlight meta data

sudo /usr/libexec/mdmclient QueryInstalledApps

Getting it out of jamf API might be a bit crunchy and taxing since it will have to hit every single device record endpoint. However, that is also an option. Running the Spotlight command and shipping the data somewhere is also an option.


I know this is an old post, but I am trying to get output similar to your first script using Jamf. Happen to know a way to do that?