Hardware Asset record not found in All Assets

[kmrniraj]

Per my understanding, all the three asset class (Hardware, License and Consumable) tables are just an extension of the main asset table (alm_asset). So any asset record be it hardware or license or consumable should be also present in main asset table (alm_asset).

When we extracted the data from Service Now, I see more number of   records in alm_hardware table then in alm_assets table. So is it possible that some Hardware Asset records are not part of All Assets?

[prdelong]

No. As a child table of alm_asset, the HW asset table works to the overall count you'd get if you ran a report but does not count as a alm_asset. It's a specific type of asset, namely hardware.

Another example. You have 100 records in your CMDB. 10 are on cmdb_ci. 50 are cmdb_ci_computer. 40 are cmdb_ci_server.

Your total CI count is 100, but your cmdb_ci records are greatly outnumbered by your computer and server records. When you export records for that table or do a table to table count, SN is looking explicitly at the number within a given class. That goes for task, asset, and CMDB.

[kmrniraj]

Thank you for the response. My assumption was that if there are 10 HW Asset records, 5 SW License and 4 Consumables then in alm_asset, we will have all the19 Asset records since HW, SW License and Consumables are the child tables of alm_asset.

If that's not correct assumption then to get all the asset records from all the asset classes, do I need to combine the records from all the asset class tables.

I had one more doubt.   How come some hardware asset records are present in alm_asset table and others are not?