RIB Query and use of Group filter

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

When I use the .Group.GroupID filter in a RIB query, it always returns that the GroupID is not a valid group.
I am getting the the GroupID using the Blue Bar approach, so I know it is a valid number.

Sample query: SELECT .PollItem.DeviceID, .PollItem.LocalID, .PollItem.DevName, .Item.Name, .Item.Description, .Utilization.95Pct, .Utilization.Avg, .Utilization.Max, .Utilization.Min, .Utilization.Stddev, .Resolution.Returned FROM CA.IM.DA.MF.NormalizedMemoryInfo.PHYSICAL_MEMSTATS WHERE .Group.GroupID = 2139642 AND .EndTime(60) > 1600105920 AND .EndTime(60) <= 1600109520 GROUPBY .PollItem.DeviceID, .PollItem.LocalID, .PollItem.DevName, .Item.Name, .Item.Description ORDERBY .PollItem.DevName DESC LIMIT 10


Here is the result:

<querySet xmlns="http://schemas.netqos.com/QuerySet">

<tables>

<table name="Health">

<columns>

<column name="SOURCE_URL" type="string" maxLength="-1"/>

<column name="PARENT_URL" type="string" maxLength="-1"/>

<column name="STATUS" type="string" maxLength="-1"/>

<column name="DETAILS" type="string" maxLength="-1"/>

<column name="RESPONSE_TIME_MS" type="string" maxLength="-1"/>

</columns>

<rows>

<r>

<cellproperties/>

<c>http://localhost:8581</c>

<c xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>

<c>FAILED</c>

<c> Error occurred while running a RIB query on Data Aggregator RIB Source. Query ID: RIBQuery_ Possible reason: Failed preparing new query: The specified item is not valid.[Invalid group filter expression ".Group.GroupID = 2139642", item 2,139,642 is not a group.] The specified item is not valid.[Invalid group filter expression ".Group.GroupID = 2139642", item 2,139,642 is not a group.] Query: { SELECT .PollItem.DeviceID, .PollItem.LocalID, .PollItem.DevName, .Item.Name, .Item.Description, .Utilization.95Pct, .Utilization.Avg, .Utilization.Max, .Utilization.Min, .Utilization.Stddev, .Resolution.Returned FROM CA.IM.DA.MF.NormalizedMemoryInfo.PHYSICAL_MEMSTATS WHERE .Group.GroupID = 2139642 AND .EndTime(60) > 1600105920 AND .EndTime(60) <= 1600109520 GROUPBY .PollItem.DeviceID, .PollItem.LocalID, .PollItem.DevName, .Item.Name, .Item.Description ORDERBY .PollItem.DevName DESC LIMIT 10 }</c>

</r>

</rows>

</table>

</tables>

</querySet>

Environment

NetOps Performance Management 3.7

Resolution

Here are a few examples of doing RIB query against the DA as well as CAPC

 

PC RIB ---  http://<capc>:8481/dm/rib/query/SELECT .PollItem.DeviceID, .PollItem.ID, .PollItem.DevName, .Item.Name, .Item.Description, .BitsPerSecondIn15MinAvg.Avg, .Resolution.Returned FROM CA.IM.DA.MF.NormalizedIntfAvg15Min.EMS_INTFAVG15MIN WHERE .Group.GroupID = 23106961 AND .EndTime(60) > 1594742460 AND .EndTime(60) <= 1594746060 GROUPBY .PollItem.DeviceID, .PollItem.ID, .PollItem.DevName, .Item.Name, .Item.Description ORDERBY .PollItem.DevName DESC LIMIT 10

 

DA RIB ---  http://<capc>:8581/rib/query/SELECT .PollItem.DeviceID, .PollItem.ID, .PollItem.DevName, .Item.Name, .Item.Description, .BitsPerSecondIn15MinAvg.Avg, .Resolution.Returned FROM CA.IM.DA.MF.NormalizedIntfAvg15Min.EMS_INTFAVG15MIN WHERE .Group.GroupID = 235030500 AND .EndTime(60) > 1594742460 AND .EndTime(60) <= 1594746060 GROUPBY .PollItem.DeviceID, .PollItem.ID, .PollItem.DevName, .Item.Name, .Item.Description ORDERBY .PollItem.DevName DESC LIMIT 10

 

Group ID would be different between PC and DA.  GroupID for the PC can be captured from the URL when you choose the group in question from CAPC.  For the DA, the GroupID will come from http://DA:8581/rest/groups