Report not populating User's location

[MadelineA747953]

Hello- New ServiceNow Platform Owner here!  We recently imported the location user attribute into our platform. When we run a report and add the location field, the user's location is returning as empty. 

[AshishKM · Accepted solution]

Seems like you are trying to get data from Incident table and location column is emptry there, this location field is not auto populate for caller location.

We need to udpate the incident's location field with respective caller's location either manually or using some script when new incident created. 

E.g. you can edit the location value in any of Incident and then check the report, this will display the value.

-

[AshishKM · Accepted solution]

Seems like you are trying to get data from Incident table and location column is emptry there, this location field is not auto populate for caller location.

We need to udpate the incident's location field with respective caller's location either manually or using some script when new incident created. 

E.g. you can edit the location value in any of Incident and then check the report, this will display the value.

-

[Rohit Singh]

Hi @MadelineA747953 ,

The snip shows a list view of incident record. The location Field in Incident table and User record is different. Hence you need to take this under consideration while creating a report data is correct.

If my response helped, then please accept the solution and hit thumbs up.

Regards,

Rohit

[AshishKM]

@MadelineA747953 , second with @Rohit Singh, you need to check source table of report data and data itself. 

[Rohit Singh · Accepted solution]

Hi @MadelineA747953 ,

See the snip location information is different. Since one location is updated for incident and other location is caller Location. The caller location is available in the Incident form since we Dot walk the Caller field and bring the Location attribute of a caller in incident form.

Hope this help to distinguish between the two location fields. Use can use Dot Walk while creating report as well.

If my response helped, please hit the Thumb Icon and accept the solution so that it benefits future readers.

Regards,
Rohit

[Rohit Singh]

Hi @MadelineA747953 ,

Glad that my response was helpful. Request you to please mark my response as solution accepted so that it benefits future readers and also help me to get recognized for my efforts towards the community.

Regards,

Rohit