Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

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
/*]]>*/