/build/static/layout/Breadcrumb_cap_w.png

Kace Report to count software versions

I'm looking to create a report that will show the number of installs for each version of Java. So the columns would be:

Software Title, Version, Count

I tried creating SQL for this report using an advanced search, but it doesn't show the device counts for each version like the advanced search did. Sadly I am not great with SQL so any help is appreciated.

Asked 5 years ago 762 views
0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Posted by: SMal.tmcc 5 years ago
Red Belt
1

Top Answer

use the report wizard

Z

Z

2Q==

2Q==

9k=


9k=


Comments:
  • if you want to see what devices are under what install just check "Devices" on page 2 - SMal.tmcc 5 years ago
  • Thanks - I had it in my head that I would need to use SQL for this! This is very simple - thanks again. - seanboy 5 years ago
Posted by: maxiakra 2 years ago
White Belt
0

The problem with the 'Devices' field is that they are in one field and I find it super hard to either use VLOOKUP on them, since it can't go through those many records in one field, or to split those devices into separate fields.
I think best approach is SQL in this case if you want to have a proper report. 

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ