CMDB Group Metadata

Jeya priya
Tera Contributor

a month ago

CMDB Group meta data (sn_cmdb_ws_group_metadata) How the CI count is calculated based on the group anyone can explain because except PC and device other count shows 0.

0 Helpfuls
  • 190 Views
2 REPLIES 2

dbook
Mega Sage

a month ago

There is a scheduled script execution which runs daily 'CMDB Workspace - Populate aggregates Daily', this invokes the function 'cmdbWorkspaceUtil.populateNoOfMatchingCIsForEncQrys'

The cmdbWorkspaceUtil handles record updates in the sn_cmdb_ws_group_metadata table by:

  • Loops CMDB Workspace groups,

  • For each group, loops its encoded queries and uses GlideAggregate to count matching CIs,

  • Writes per-query counts to sn_cmdb_ws_group_query_metadata,

  • Sums them and writes one per-group row to sn_cmdb_ws_group_metadata,

  • Then cleans up any metadata records whose groups/queries have been deleted.

 

 
 
0 Helpfuls

VijayaMannapura
Tera Guru

a month ago

@Jeya priya  This list is populated basing on the  All-> Configuration -> CMDB Groups. The exact table is 'cmdb_group'. Inside each group you will find 'CMDB GROUP contains Encoded Queries'. Those queries are the ones filtering the CI's.

 

 

0 Helpfuls