in the Zurich Release has the Collect MSSQL Components Info deprecated??

[lsubramaniyan]

in the Zurich Release has the Collect MSSQL Components Info deprecated?? I see that is disabled yet throws error on Discovery.

How to eradicate that to enable a clean discovery?

[abbasshaik4]

Hello @lsubramaniyan,

Please refer to the link's below:
https://downloads.docs.servicenow.com/pdf/enus/servicenow-zurich-release-notes-enus.pdf

https://www.servicenow.com/docs/r/release-notes/zurich-security-notables.html

If it is helpful, please mark it as helpful and accept the correct solution by referring to this solution in the future it will be helpful to them.

Thanks & Regards,

Abbas Shaik

[lsubramaniyan]

Thank you, I am still looking for more drill down particularly.

[Marinus _Ronald]

Hi lsubramaniyan,

This is most likely not related to the pattern being deprecated, but to identification configuration.

In my case, the error was caused by using an independent identification rule on the Windows Server class, that rule did not include the MSSQL tables (mssql_components_info, mssql_sqlservice_info) in its related tables. 

Because of that, the discovery engine (specifically the relation/reference step) rejected those tables with errors like 'not a known CI type", even though the tables and data existed.

Check if your identification rule, used on the Windows server class contains the following 2 related tables, if not add them and that should fix the issue.

Br,

Ronald