Service Graph Connector for Meraki – Creating Duplicate Records in Meraki Devices table

[Aman_07]

Hi All,

I am working on configuring the Service Graph Connector for Cisco Meraki in ServiceNow and need some guidance regarding duplicate records being created in the Meraki Devices table after scheduled job execution.

Import Set:

✅ Configuration Setup Completed
1. Created two API Key Credentials (one for each dashboard)
2. Created two HTTP Connections (Global and China endpoints)
3. Configured System Property with Meraki Organization IDs (comma separated)
4. Configured Credential & Connection Alias
5. Activated Scheduled Jobs:
• SG-Meraki Credential Affinity Sync
• SG-Meraki Devices (Data Import Job)

-> Observations During Testing

During first job Run:
MerakiDevices:
• Table: x_caci_sg_meraki_merakidevices
• Count: 3988

After second job run:
MerakiDevices:
• Table: x_caci_sg_meraki_merakidevices
• Count: 7956

Note: Duplicates are only created in MerakiDevices Table, other tables are like cmdb_ci, network, organization, Meraki Custom CI Fields remains same.

Thanks in advance for your help and guidance.

[Vishnu-K]

Hi @Aman_07 ,

There is no need for a scheduled script in this case because it is a staging table. Data stored in a staging table is retained only for 7 days. This means that if data is loaded today, it will be automatically purged after 7 days, so manual cleanup is not required.

Hope this helps you, Please do mark it as helpful . And accept the solution.

Thanks,

Vishnu

[Aman_07]

Hi @Vishnu-K 
Thanks for the clarification.
Just to confirm, is the 7-day purge applicable to Service Graph custom staging tables like x_caci_sg_meraki_merakidevices, or only to standard Import Set tables (sys_import_set / sys_import_set_row)?

[Vishnu-K · Accepted solution]

Hi @Aman_07  ,

This 7 day retention time for the staging table data is for all the tables which extends the sys_import_set_row table that means for the staging tables not only for standard Import Set tables .

If this answers your question, please mark it as helpful and accept the solution for better community visibility.

Thanks,

Vishnu

[Aman_07]

Hi @Vishnu-K ,

Could you please let me know, once the integration is completed, how we can validate the data coming into ServiceNow from the Meraki dashboards?

Is there any specific record count or metrics that we should request from the Meraki SPOC for validation?

Thank you.