While trying to add a CMDB connection the dependency update is failing with the following errors:
"Exception: Conversion failed when converting the varchar value '*' to data type int."
"Exception: Conversion failed when converting the varchar value '*' to data type int."
ITMS 8.x, IT Analytics 8.x
Defect
In order to fix the issue modify the spITAnalytics_CSMP_CreateViews stored procedure, replace it with the attached one.