The Location column in the CABI/JasperReports "Current Assets (Customizable): All reports" is empty for a range of devices.
DX NetOps Spectrum: Any version
CABI/JasperReports: Any version
The sysLocation (OID: 1.3.6.1.2.1.1.6) on the device side is empty/blank, hence in Spectrum the Location (0x23000d) attribute ID value is empty/blank too. Spectrum populates the Location (0x23000d) attribute ID value (aka Device Location) based on the value it reads from the sysLocation (OID: 1.3.6.1.2.1.1.6) from the device.
The device's administrator has to update the sysLocation (OID: 1.3.6.1.2.1.1.6) on the device side. Once the sysLocation is updated Spectrum will poll that information in the next polling cycle (every 5 minutes - default polling).
SRM (Spectrum Report Manager) will update the Location field in the reporting database every 24 hours.
If the SNMP Community String used in Spectrum to discover/model those devices has the Read/Write permission, then the Location can be updated from Spectrum OneClick Console. Use the Attribute Editor to update in bulk.
What attributes does the Spectrum periodically poll from devices?
https://knowledge.broadcom.com/external/article?articleNumber=47188
Run the $SPECROOT/Install-Tools/SRM-Tools/poll_device.sh script for specific device model_handle to update the Location field in the reporting database on demand.