Group By count is not matching total record counts

[RahulY00040]

Hello friends,

Today i noticed that when I did the group by against the filtered CIs listing using field Discovery Source. What I noticed that discovery source grouping count mentioned in parenthesis is not matching against the total records count when added together. THis is not happening for every field, but noticed for the field Discovery Source.

**I can not share screenshot here.

Anyone has any idea, thanks in advance

Rahul

[Brad Bowman · Accepted solution]

I would look for records with an invalid Discovery Source.  Since this is a field with choices, if the value stored in the field doesn't match the value of a choice record, it could have trouble grouping on that value.

[RahulY00040]

Thanks @Brad Bowman  for your quick response.

Yes there are 2 discovery value choices with this name. Not sure how these 2 got added. Should we just keep/have one ? Its under discovery_source field on computer class table.

Thanks in advance,

Rahul  

[Brad Bowman]

Yes, each choice record Label (and Value) should be unique to prevent confusion such as this.

[RahulY00040]

What I noticed is whenever I create the choices for specific classes, Discovery Source grouping count gets increased reflecting number of CIs from that class. Looks like I need to create explicitly choices for all classes not only in parent. i.e. having choices configured at Netgear level, its not reflecting on IP Switch/Router when grouped.

Thanks,

Rahul