Submit a ticketCall us

AnnouncementsWeb Help Desk Integrations eCourse

Looking to reduce response times? Sign up for our eCourse to learn how integrating Web Help Desk with Dameware Remote Support, Network Configuration Manager, Network Performance Monitor, and Server & Application Monitor can improve communication efficiencies.

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