Model cleanup - report to identify all hardware computer models that have no associated CIs?

[Craig Rogers]

I am still relatively new to ServiceNow.  We have recently gone live on ServiceNow ITSM incident, change, & request.  During our implementation we created CIs for computers via SCCM discovery but we have not yet created assets and/or  implemented Asset Management.  In preparation for starting down the path of Asset Management implementation, I am wanting to clean up our CIs and Models as much as possible before creating Assets from our CIs and importing our remaining inventory.

Is there an easy way to get a report or list showing me all of the current Hardware Models for Computers that do not have any associated CIs or Catalog Items?  I know I could look through all of the models one at a time but it would be so much easier to get a list of all of the existing computer models that have no CIs or catalog items and delete them all at once.  It also seems like it would be good to have this report or list to look at occasionally to make sure the model table is not getting dirty.

[sachin_namjoshi]

You will have to create database view between alm_hardware and cmdb_hardware_product_model tables to get all hardware models which doesn't have any assosiate CIs.

You will have to join these two tables in database view with correct JOIN condition to get all hardware models with no corresponding CIs.

Regards,

Sachin

[asset_manager]

Hi Sachin, would you be able to specify the correct Where Clause/JOIN condition(s) to get this Database View working properly?

[kriangkrai]

Hi,

You may create a simple report to fulfil this.

Please follow below step for more details.

1. Go to Reports > Create New
2. Under Data:
   • Fill out Report name
   • Source type = Table
   • Table = Hardware Model [cmdb_hardware_product_model
   • 
3.  On the report frame, click on funnel icon to open condition builder
   • 
4.  Expand RELATED LIST CONDITIONS, then select Related Table. In this example, I select Asset->Model to create a report on Hardware Model and their associated asset
   • 
5. Click on Greater than or Equal to 1 to update criteria for quantity of record on related table.
   • 
6. Update Operator and quantity to match your condition. In this example, I select Equal to 0 to see list of Hardware Model without associated asset.
   • 
7. Click Run, you will see the list of Hardware Model without associated asset
   • 
8. Open any model from the list, you can see the model does not have any associated asset by looking on the Assets Related List.
   • 

With above step, you may change table, conditions or related list to fulfil your requirements.

Hope this help.

Regards,

Oat

[klf1123]

When I follow these steps -  Expand RELATED LIST CONDITIONS, then select Related Table. I have not option to select the Asset table.