Why the Total CI Count in Cmdb_Ci and CMDB workspace is not matching

[Snow909]

Hello Folks,

When Trying to look at the Total CI count in prod , i see a huge difference in CI count.

Total CI on Cmdb workspace and cmdb_ci table. Why is that so and is workspace is pointing to other than cmdb_ci tables.

[Swetha Vivekan1]

The scheduled job responsible for the report is "CMDB Workspace - Populate aggregates Monthly"

https://<instance name>.service-now.com/nav_to.do?uri=sysauto_script.do?sys_id=461ca87f77d52110ee0d0cc2fa5a99bf

OTB is set to run Monthly.  In order to validate the live count, you run the job on adhoc and compare the result.