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.

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
  • 532 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