How to Group Asset Report by OS on alm_asset Table?

[shubhamkhai]

Hi all,

I’m building a report on the alm_asset table to list assets where:

• model_category is Windows Server, Linux Server, or Server

• install_status is IN (9, 1, 10, 3)

• ci (Configuration Item) is not empty

• Grouping is needed by model_category and Operating System

---

🚧 Challenge:

There’s no OS field on alm_asset, and I can’t dot-walk through the ci reference to access the OS (since it's only available on certain CI classes like cmdb_ci_server).

---

✅ My Workaround:

I switched the report base table to cmdb_ci_server:

• Applied filters via asset.model_category, asset.install_status, and ensured asset is not empty

• Grouped by both asset.model_category and os

This gives the correct result and matches the record count from the alm_asset report.

---

❓ Question:

Has anyone solved this without switching the base table from alm_asset?

• Any tips for exposing CI fields (like OS) directly in asset reports?

• Would using calculated fields, database views, or extending the asset table make sense here?

Appreciate any insights or alternate approaches!

Thanks,
Shubham

[Mark Manders]

No. You can only do a group by on fields that are available on the table you are reporting on. That includes dotwalking, but you can't group by a field that can't be reached from the table. Reporting on ALM_ASSET will never enable you to group by OS.

You can create a db view and report on that, when you include all the fields you need on the db view.