Sometimes users move their assets to another location.
We have invdividual VLAN for every floor and building so we can track moving between subnets via LS.
Our repost just checks the changes of the Default GW.
Firstly, you must set Scanned Item Interval - Network:
History - Enabled
Refresh - 0 or 1
Then run this report:
Select Distinct Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tblassets.userdomain,
tblassets.userName,
tblNetwork.DefaultIPGateway,
tsysIPLocations.IPLocation,
tblNetworkHist.DefaultIPGateway As DefaultIPGatewayOld,
iploc.IPLocation As IPLocation_Old,
tblNetwork.Lastchanged
From tblassets
Inner Join tblNetwork On tblassets.AssetID = tblNetwork.AssetID
Inner Join tblNetworkHist On tblassets.AssetID = tblNetworkHist.AssetID
Left Join tsysIPLocations On tsysIPLocations.LocationID = tblassets.LocationID
Left Join tsysIPLocations As iploc On
Right('000' + IsNull(ParseName(tblNetworkHist.DefaultIPGateway, 4), ''),
3) + Right('000' + IsNull(ParseName(tblNetworkHist.DefaultIPGateway, 3),
''), 3) + Right('000' + IsNull(ParseName(tblNetworkHist.DefaultIPGateway,
2), ''), 3) + Right('000' +
IsNull(ParseName(tblNetworkHist.DefaultIPGateway, 1), ''), 3) Between
iploc.startip And iploc.endip
Where tblNetwork.DefaultIPGateway <> tblNetworkHist.DefaultIPGateway And
Coalesce(tblNetwork.DefaultIPGateway, '') <> '' And
Coalesce(tblNetworkHist.DefaultIPGateway, '') <> ''
Order By tblNetwork.Lastchanged Desc
