odata Query output Missing Fields

Products

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

Issue/Introduction

We upgraded Pm to  version 20.2.1.0. Since the upgrade I have a query that pulls data and is missing fields. When the query runs it pulls all the information for the first line. Then it summarizes the next  columns that pertaining to that device. this repeats for every device in the query. 

Example output of a query from the query builder

"DisplayName","device/Name","portmfs/Timestamp","portmfs/im_BitsPerSecondOut","portmfs/im_BitsPerSecondIn"
Gi1/1/2 - GigabitEthernet1/1/2,hostname,1600729200,2.27096396555556E7,1.72050958088889E7
Gi1/1/2 - GigabitEthernet1/1/2,,,1600732800,2.72405283555556E7,1.53491165377778E7
Gi1/1/2 - GigabitEthernet1/1/2,,,1600736400,2.212118588E7,1.44166839888889E7
Gi1/1/2 - GigabitEthernet1/1/2,,,1600740000,2.95509120755556E7,1.432290164E7
Gi1/1/2 - GigabitEthernet1/1/2,,,1600743600,2.15137247244444E7,1.679388552E7
Gi1/1/2 - GigabitEthernet1/1/2,,,1600747200,2.10736172844444E7,1.31675350755556E7

Query builder omitting fields in output 

Environment

Release : 20.2

Component : IM Reporting / Admin / Configuration

Resolution

Fixed in 20.2.4.