Report on IP Address History for Assets?

[Technut27]

Obviously Lansweeper records the current IP of an asset and displays it in a number of ways, that has been very useful in the past for finding the subnet that it is connected to. My question is this. Is it possible to generate a report for that IP range listing out the items that have been found on it over a period of time?

For example I have a subnet of 192.168.210.* and I'd like to know what computers have been connected to it over the past x number of days. I run IP scans of that subnet daily and active scanning is watching it as well so when computers are on that network I do find them.

Thank ahead of time.

[Daniel_B · Accepted solution]

In order to receive a list of connections during the past which may have overwritten in between, you'll need to enable History logging for NETWORK under Configuration\Item Wait Time. From this moment on a history table will be generated.
A report like the following lists assets connected to a specific range of IP addresses during the past 7 days:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblNetworkHist.Lastchanged As [Network change],
  Case tblNetworkHist.Action When 1 Then '+' When 2 Then '-' End As [+/-],
  tblNetworkHist.IPAddress As [IPAddress History],
  tblNetworkHist.IPSubnet
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblNetworkHist On tblAssets.AssetID = tblNetworkHist.AssetID
Where tblNetworkHist.Lastchanged > GetDate() - 7 And
  tblNetworkHist.IPAddress Like '192.168.210.%' And tblAssetCustom.State = 1
Order By [Network change] Desc