Submit a ticketCall us

WebinarDatabase Roundtable – Expert Database Professionals Feel Your Pain

In this video broadcast, Head Geek™ Tom LaRock is joined by Karen Lopez, Tim Chapman, and David Klee. They’ve known each other for many years, so this discussion was like four friends getting together to talk data and databases. They discussed diagnostic data collection, common performance root causes, reactive tuning versus proactive, and more. Join us for an engaging discussion on these topics! Plus, Tom LaRock will be available to answer your questions live.

Register now.

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