Where to store OS patching information

[nareshTT]

Hello All,

I have a requirement to store patch information about operating system present on Certain server . In this case i do not find any OOTB attributes available that can hold patching details. Does it means it should be hold in cmdb_ci_patches table or cmdb_ci_spkg? 

Thank you. 

[Bhuvan]

@nareshTT 

Refer below for more details

cmdb_ci_spkg - Software Package information

cmdb_ci_patches - Patches information

Refer below links for more information

https://www.servicenow.com/docs/bundle/yokohama-servicenow-platform/page/product/configuration-manag...

https://www.servicenow.com/community/servicenow-ai-platform-forum/what-is-the-purpose-of-cmdb-ci-pat...

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[kaushal_snow]

Hi @nareshTT ,

To store operating system patching information in ServiceNow CMDB, the most appropriate table is cmdb_ci_patches. This table is specifically designed to store information about server patches, including patch IDs, installation dates, and related details. It allows for tracking and managing patches applied to servers within your infrastructure.

The cmdb_ci_spkg table, on the other hand, is used by Software Asset Management to reconcile software packages and versions. It's updated indirectly via the Synch Software Package Business Rule and is primarily intended for managing software installations and entitlements, not for tracking operating system patches.

Therefore, for managing OS patching information, the cmdb_ci_patches table is the recommended choice....

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.