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.

-

[Rohit Singh]

Hi @MadelineA747953 ,

Does actual user records have location updated? Got to the user table (users and groups-> Users) then through filter check location is not empty. By this will see how many user records are there who have location field updated. Then cross check with your report.

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

Regards,

Rohit

[MadelineA747953]

hello! the user table shows locations for many of our users... I cross referenced users on the report whose location is showing in the user table. 

[Rohit Singh]

Hi @MadelineA747953 

Then can you share the snip of your report configuration. Want to see how your report is showing empty location.