Community FAQ
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

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now