How to Group Asset Report by OS on alm_asset Table?

shubham007
Tera Expert

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

1 REPLY 1

Mark Manders
Tera Patron

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.