Comparison of excel with CMDB table

MMDivya
Tera Contributor

‎04-30-2024 04:51 AM

Hello Team,

 

I have an use case to compare the excel with CMDB_CI table. I have to compare the name/ system name/ serial number from excel with respective fields in CMDB table. I don't want to insert/ update any CI in the table. Here, I need to count how many devices are present in CMDB wrt excel and list of missing devices in CMDB.

0 Helpfuls
  • 395 Views
4 REPLIES 4

Mark Manders
Mega Patron

‎04-30-2024 06:17 AM

Start with remote tables?


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron

‎04-30-2024 06:28 AM

Hi @MMDivya 

 

You can bring excel data in Sn via report, there is option there called External Import which can help you. 

 

AGLearnNGrow_0-1714483678602.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls

MMDivya
Tera Contributor
In response to Dr Atul G- LNG

‎05-02-2024 04:48 AM

Hi @Dr Atul G- LNG 

 

I'm unable to find the source type as "external import" in my personal instance. Can u guide me on how to add this option to the report?

MMDivya_1-1714650476859.png

 

 

0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron
In response to MMDivya

‎05-02-2024 04:52 AM

Hi @MMDivya 

 

Try to upgrade teh report plugin or upgrade PDI to D.C. Release.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls