Is 240k CI's for Hardware Templates Normal?

[Todd Burnett]

My company has recently begun its journey into the world of CMDB and ITOM. Last week I started a base scan of our Azure subscriptions and on the cmdb_ci_compute_template table, we've discovered 240,000 CI's that appear to just be base machine templates. My first question is how are there that many different machines in Azure? is that normal? my second question is... I went to turn off the discovery pattern to stop pulling these in, but the pattern was already set to inactive. How do I stop these template machines from being pulled into the CMDB? it's a lot of needless items.

[Ram Devanathan1]

hi - it is by original design, in the hardware templates model and discovery approach. this design is now improved to de-dup the same hardware models across regions and accounts. you can look up the steps to configure this here.

Enable the Cloud Hardware Type class extension (servicenow.com)

[Todd Burnett]

Ram, 

I followed the instructions per the article you linked in our dev environment. I then set-up an azure scan in our Dev environment and I still pulled in all the duplicate CIs. Almost 585k worth of items. Any help?

[Ram Devanathan1]

Hi Todd, could some of these be the older records which need to be deleted? Also, note that the records are shared across regions in each account. quick question, how many subscriptions are running the discovery for?

[Todd Burnett]

Running the scan for 1 Subscription, I'm removing all the records in this table now, it's taken a bit to run due to the size of this table. I will update this thread in a few days with my findings.