Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Mister_Nobody
Honored Sweeper III

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

 

 

2 REPLIES 2
DonMario73
Champion Sweeper

Great use case!

FrankSc
Lansweeper Tech Support
Lansweeper Tech Support

Hi Mister_Nobody, 

 

Good suggestion! 

Thanks for sharing the report!

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now