We recently scanned in printers using SNMP scan into our ServiceDesk Plus CMDB.  The data such as sysLocation is present, but I cannot write a custom report to pull that column/field data.  It appears just the SNMP data cannot be reported using custom report.

1) is there a way around this, such as linking sysLocation to Location or

2) is the data present in a SQL query (and does anyone have)