Empty fields when exporting report to excel. ServiceNow Rome

BriTaylor
Kilo Sage

‎10-21-2022 07:59 AM

Hi,

 

I have created a report and it shows everything I need in Service Now itself, however when I export the report to an excel document multiple records are missing data in the Assigned To field even though the record is assigned to someone. Data is being pulled from the asmt_metric_results table.

 

Report from SNOW: 

BriTaylor_0-1666363627446.png

 

Exported Excel Report:

BriTaylor_1-1666363663976.png

 

Columns pulled in SNOW:

 

BriTaylor_2-1666363871849.png

 

Report Conditions:

 

BriTaylor_3-1666363904541.png

 

0 Helpfuls
  • 1,041 Views
2 REPLIES 2

AnirudhKumar
Mega Sage
Mega Sage

‎10-22-2022 03:39 AM

Crazy!

The only thing I can think of is that the user record for Adam Niccolini is messed up.

Try creating a dummy incident. Set the Assigned To field as Adam Niccolini.

Then export the incident to excel keeping the Assigned To column in the list.

 

Does the Adam show up in the excel sheet?

0 Helpfuls

BriTaylor
Kilo Sage
In response to AnirudhKumar

‎10-24-2022 03:51 AM

He does show up later in the report and it is not just him that is effected either. I only added a snippet of the report there are about 90-100 rows missing this field with a few different names.

0 Helpfuls