Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

CI Verification and Merge CIs

tsho
Giga Contributor

‎07-29-2016 09:33 AM

CMDB and Asset have been separate in my company.   CMDB is in ServiceNow.   Asset is in HP Asset Manager.   We will be migrating all assets to ServiceNow.   Not knowing how CIs and assets will coalesce with each other, I enabled Enforce CI Verification.   My current state:

  1. We have 28,000 CIs that require verification
  2. 0 assets
  3. We are planning on importing assets from Asset Manager to ServiceNow in a couple of weeks
  4. Only 22% of the asset serial numbers matches CI serial numbers (I did vlookup in Excel by exporting both CIs and assets).   I can increase the matches by 11% by removing "S" from Asset serial number.   Example:   Asset serial number S12345, CI serial number 12345.
  5. The other 70% that does not have serial numbers are due to missing serial numbers in assets, or missing serial numbers in CIs, or variation of serial number other than just an "S"

Since I have a lot more assets that will not match CIs, I am thinking of trying to reconcile CIs and assets after the import.   So the assets will be imported into empty asset tables.   It seems that, with the 30% of assets that have matching serial numbers, CIs are created instead of matching CIs being updated.   That means we will have 10,000 CIs that need Merge CIs performed.   Going forward, as we reconcile the remaining 70% no-matches, it will increase the number of CIs that need to be merged as well.

Have you encountered similar situation?   Can you advise how we should go about resolving these discrepancies?   Is it possible to perform the Merge CI function programmatically instead of manually?

Secondly, CI model updates asset model.   Is it possible not to sync the Model attribute?

Thanks in advance for any input you may have.

Teresa

0 Helpfuls
  • 3,084 Views
5 REPLIES 5

Daniel Slocum
ServiceNow Employee
ServiceNow Employee
In response to tsho

‎08-02-2016 09:27 AM

You are welcome.   If I've helped you at all, can you indicate that via the Helpful Yes|No option or by clicking Like. If I've answered your question you can mark it as answered.   Both of these actions will let other users of the system know your status on the question so they can either learn from it as well, or they'll know to chime in if they too have experience which may help you.



Again, best of luck.


0 Helpfuls