Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-28-2025 06:24 AM - edited ‎04-28-2025 06:26 AM
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
Labels:
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-28-2025 05:25 PM
Great use case!
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-28-2025 09:16 AM
Hi Mister_Nobody,
Good suggestion!
Thanks for sharing the report!
