Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

Home > Success Center > IP Address Manager (IPAM) > IPAM - Knowledgebase Articles > How to create a three-day IP History Movement report in Report Writer

How to create a three-day IP History Movement report in Report Writer

Table of contents

Updated January 22, 2018

Overview

This article describes how to create a three-day IP History Movement report in Report Writer.

Environment

  • IPAM with Report Writer

Detail

  1. Open Report Writer.
  2. Click New and select Advanced SQL.
  3. Execute the following query:
SELECT 
IPAM_IPHistoryReport.IPAddress AS IP_Address, 
IPAM_GroupReportView.FriendlyName AS Display_Name,
IPAM_NodeReportView.sysName AS System_Name, 
IPAM_NodeReportView.Description AS Description, 
IPAM_IPHistoryReport."Time" AS Time, 
IPAM_IPHistoryReport.FromValue AS From_Value, 
IPAM_IPHistoryReport.IntoValue AS Into_Value, 
IPAM_NodeReportView.Comments AS Comments
FROM 
(IPAM_GroupReportView INNER JOIN IPAM_NodeReportView ON (IPAM_GroupReportView.GroupId = IPAM_NodeReportView.SubnetId)) INNER JOIN IPAM_IPHistoryReport ON (IPAM_NodeReportView.IPNodeId = IPAM_IPHistoryReport.IPNodeId)
WHERE 
(
(IPAM_IPHistoryReport."Time" BETWEEN GETDATE() - 1 AND GETDATE())
)
order by TIME desc

 

 

 

Last modified

Tags

Classifications

Public