We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

CMDB Group Metadata

Jeya priya
Tera Contributor

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.

2 REPLIES 2

DeanB9201927820
Mega Sage

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.

 

 
 

Vijaya_Mnpram
Kilo Sage

@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.