How can I report on the installations of a software model grouped by operating system of host?

[Michael255]

I need to make some reports that list the installations of any given software model grouped by the operating system of the computer they are installed on.

I might be looking at this wrong way, but in the Software Installation table, because the installed_on field is a reference to the cmdb_ci_hardware field, I cannot figure out how to group or filter on operating system. operating system is a field on a child class: cmdb_ci_computer.

The use case is we want to see the breakdown of the install base for a package.

[Alex Panzarella]

I've had some problems dot walking from software installs to OS in the report builder (view / run), but had luck in the CMDB query builder.

Try the CMDB Query Builder (see screenshot below).

[Mike Condon · Accepted solution]

I was able to do this in the reporting view. YOu have to use the extended columns (in red generally)

Select Installed on  [+]

Expand it, then scroll all the way to the bottom of the list and you may see something that says "Show Extended Fields" or "Hide Extended Fields" You need to show Extended Fields and then they will show up in Red:

Then just scroll through the extended fields until you get to Operating System [Computer].  The [Computer] tells you that the value is coming from Computer class

After that you can group by that column in the report.

Thanks!

-Mike

[Mike Condon]

Sorry here's the screenshot showing the field you wanted: