RIB call for "AS" is not working

Products

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

Issue/Introduction

since we have upgraded to the lastest version of CAPM (3.7.0.355) our RIB queries are failing on the "AS" part.

Rib Example:
SELECT .EndTime(300) AS ts, .PollItem.DevName AS device, .Item.Name AS cpu, .Utilization.Max AS cpuUtil FROM CA.IM.DA.MF.NormalizedCPUInfo.NRM_CPUSTATS WHERE .EndTime(300) >= 1558702136 AND .EndTime(300) <= 1558703036 AND .Utilization.Max >= 90 GROUPBY .PollItem.DevName, .Item.Name, .EndTime(300) ORDERBY .PollItem.DevName ASC, .Item.Name ASC, .EndTime(300) ASC

Cause

A change made in 3.7 has altred this functionality in SQL.

Environment

Release : 3.7

Component : IM Data Aggregator

Resolution

Broadcom will fix this functionality change in a future build of CAPM.

The temporary work-around is to edit the RIB calls you are making to not use the ‘AS’ function until we can get this fixed in a future build.