Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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.