Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a week ago - last edited a week ago
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
a week ago
Great use case!
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a week ago
Hi Mister_Nobody,
Good suggestion!
Thanks for sharing the report!
