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.

[kriangkrai]

Hi @klf1123 

Please review that your report was created on a table that referenced to Asset table which is Hardware Model for this case.

You can see more details on sys_db_object table, e.g. Model is a reference field in Asset table.

[Vijay Venkatara]

Useful way to link tables in a report.