- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-11-2015 11:31 AM
- 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
- Labels:
-
Report Center
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-01-2019 04:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-09-2018 03:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-11-2018 02:42 PM
Cheers.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-21-2016 06:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-18-2016 05:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-07-2016 08:18 PM
vmathur wrote:
I did, but that does not populate the name assigned to the "IP Location" into the report. Also, if i try and filter it by name usind the ='IP Location Name' , the report comes back with a "No Records Found" error.
Please verify whether your IP locations are set up correctly under Configuration\Asset Groups and that you've linked tsysIPLocations in your report exactly as shown in my initial post. The Link Properties should be exactly the same as in my post. Only then will your report results be accurate.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-14-2016 08:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-17-2016 06:41 PM
vmathur wrote:
This is great. What i would also like to know is how to display the "Location Name" that is assigned to the IP Range locations to this report.
Tick the IPLocation field in tsysIPLocations, as shown in the last screenshot of my initial post.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-24-2015 03:30 PM
In ('First location name ','Second location name ')
Keep in mind that this is standard SQL syntax. We highly recommend familiarizing yourself with SQL, as this will make it a lot easier to build or modify reports. This forum topic lists some resources you can use.