To add your assets' IP locations to a report, do the following:
- Hit the pencil shaped edit button next to the report under Reports\View All Reports.
- In the search bar in the left-hand pane. Search for IPlocation.
- Double-click tsysIPLocations to add it to your report.
- Right-click on the link between tsysIPLocations and tblAssets, configure the link as shown below.
- Tick the IPLocation field in tsysIPLocations to add the field to your report.
- Hit Save & Run to save your changes and view the report results. The final link between tblAssets and tsysIPLocations should look like this within your SQL query:
Left Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID
