Adding IP locations to a report

[Susan_A]

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

[swalker]

Fantastic Report

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

Scott

[chads]

Best bookmark yet. Always need this