what is the purpose of cmdb_ci_patches

[phantom7]

Hi,

I would like to understand what the point of the table cmdb_ci_patches is and what is it used for?

Thank you,

[sachin_namjoshi · Accepted solution]

cmdb_ci_patches is used to store information about server patches.

Also, look below for different table mapping.

cmdb_ci_business_process: Map incidents and problems to the process they came from

cmdb_ci_circuit: IP Circuit

cmdb_ci_cluster: Cluster of servers or databases

cmdb_ci_cluster_node: Each server in the cluster

cmdb_ci_cluster_node_resource: Each resource currently on the cluster node

cmdb_ci_cluster_resource: Global cluster resources

cmdb_ci_zone ( OK this is a Data Center Zone,   but just what is a Data Center Zone?   And why do we care? 😞 Data centers are divided into zones, which allow you more granular visibility as to where it is; ie, if you have an issue and someone gives you a data center, it is akin to giving you a city in a map.   A zone gives you a zip code, essentially, where a rack would be a street name and a row would be an address.. it is just more specific information for locating something in a data center

cmdb_ci_infra_service   ( it inherits from Application.   But how is it different from a Service? )

cmdb_ci_outage   ( is this really a CI? 😞 Tracking outages of CIs and allowing you to tie them back to SLAs

cmdb_ci_pdu_outlet: Outlets on the power strip so you aren't having to trace cables

cmdb_ci_vm_parallels: Parallel Virtual Machine - Wikipedia, the free encyclopedia

cmdb_ci_patches: Server patches

cmdb_ci_pdu: Power distribution Unit.. Power strip in a rack

cmdb_ci_appl_pending ( is this just an application in a pending state? )

cmdb_ci_snc_component ( is this the servicenow CI's that we use? 😞 These are the ServiceNow components, servers, etc

cmdb_ci_tower_tower_eq: Power equipment

cmdb_ci_beacon_tower_eq: Power equipment

cmdb_ci_tower_eq: Power equipment

cmdb_ci_twr_light_cnt_tower_eq: Power equipment

cmdb_ci_tower_light_tower_eq: Power equipment

cmdb_ci_vm_zones: VLAN?   I don't know

Regards,

Sachin