→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Susan_A
Lansweeper Alumni
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.

    Add table

  • Right-click on the link between tsysIPLocations and tblAssets, configure the link as shown below.

    configure link


  • Tick the IPLocation field in tsysIPLocations to add the field to your report.

    add location

  • 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
11 REPLIES 11
swalker
Engaged Sweeper
Fantastic Report

Would you be-able to document how you can specify the actual IP Location or Multiple IP Locations.

Scott
chads
Lansweeper Alumni
Best bookmark yet. Always need this