cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
lkeyes
Engaged Sweeper III

Dear friends:  

I started a project where I was adding our American Power Conversion UPSs to our LanSweeper Asset Inventory.  I added about 10 of them.... and they would appear under "Asset Type" as UPS...   Had them scanning....and had a couple accessing the SNMP for additional details from the units. 

Now going into LanSweeper...none of these UPS are displayed and the Asset count for UPS is only 1. 

The only variable that I can think of is that we updated our LanSweeper license during the past couple of weeks. 

While I can manually add these back...  I was wondering if there was some way they could have disappeared....  I already have several hours of work into the project that I'd like to save,  and of course if I add them again...I don't want them to disappear again.     

2 ACCEPTED SOLUTIONS
lkeyes
Engaged Sweeper III

(cue sheepish grin here...)   Ok....I think I figured it out.... the units have been declared inactive,  so don't appear in the usual list of Active assets.    

View solution in original post

rom
Champion Sweeper III

One thing I do for UPSs and other things -  I make a modified port switch report and look for the first three MAC pairs of the MAC address (or otherwise look for the MAC address commonalities for the APC UPS devices for example) - where there is not an asset name match (i.e. lansweeper doesn't have an asset for it associated with the port) - and that gets me the APC UPS's that I haven't swept yet.

 

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename As AssetType,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblSNMPInfo.IfIndex As [If],
  tblSNMPInfo.IfDescription As Name,
  tblSNMPIfTypes.IfTypename As Type,
  tblSNMPInfo.IfAdminstatus As Admin,
  tblSNMPInfo.IfMTU As MTU,
  Ceiling(tblSNMPInfo.IfSpeed / 1000 / 1000) As Speed,
  tblSNMPInfo.IfIPAddress As IP,
  tblSNMPInfo.IfMask As Mask,
  tblSNMPInfo.IfMacaddress As MAC,
  tblAssets1.AssetName As Asset,
  tblSNMPInfo.IfOperstatus,
  tblSNMPAssetMac.AssetMacAddress
From tblAssets
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblSNMPInfo On tblAssets.AssetID = tblSNMPInfo.AssetID
  Inner Join tblSNMPIfTypes On tblSNMPIfTypes.IfType = tblSNMPInfo.IfType
  Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
      And tblAssets.IPNumeric <= tsysIPLocations.EndIP
  Left Join tblSNMPAssetMac On tblSNMPAssetMac.AssetID = tblSNMPInfo.AssetID And
      tblSNMPAssetMac.IfIndex = tblSNMPInfo.IfIndex
  Left Join tblAssetMacAddress On tblAssetMacAddress.Mac =
      tblSNMPAssetMac.AssetMacAddress
  Left Join tblAssets tblAssets1 On
      tblAssets1.AssetID = tblAssetMacAddress.AssetID
Where tsysAssetTypes.AssetTypename = 'switch' And tblAssets1.AssetName Is Null
  And tblSNMPAssetMac.AssetMacAddress Is Not Null And
  tblSNMPAssetMac.AssetMacAddress Like '28:29:86%'
Order By tblAssets.IPNumeric,
  [If]

 

View solution in original post

8 REPLIES 8
lkeyes
Engaged Sweeper III

Hi...following up on my Active/Inactive issue....  I now am wondering about another aspect of this.   I have several printers listed in my asset list.  These become inactive if Lansweeper scans for them, and doesn't find them....however, the printers will go to sleep after a period of non-use.  Thus,  they become inactive after every weekend, when they are not used. 

 Is there a way to flag these items so they don't become inactive?      

ErikT
Lansweeper Tech Support
Lansweeper Tech Support

@lkeyes , if the printers are in sleep mode when they are being scanned they will be set to inactive indeed. The only way to prevent this is to make sure that the printers are only scanned when they are active. If possible, add then to a separate scanning target and only scan them during active business hours. 

lkeyes
Engaged Sweeper III

Hi, @ErikT.....  many thanks for your note.   

Hm.... are the printers declared inactive after a single scan if they are asleep?

It would be nice to have the ability to set scan interval and the number of retries.  In our shop we have people in and out, and I don't think we could reliably define "business hours".   

Another thought might be to have an automated batch job that sends a print job to each printer immediatly prior to the scheduled scan.  Even if it "wastes" a single piece of paper...that would be worth it.  Is there a way to do that via an API perhaps?    

lkeyes
Engaged Sweeper III

ROM....that's fantastic!   Thanks so much.  

lkeyes
Engaged Sweeper III

Also....want to do a shoutout for the "DeviceTester".... which is run from the LanSweeper back end. This is very handy for figuring out the configuration of any device that has (or may have) various interfaces, like SSL, HTTP, HTTPS, SNMP, etc.  If SMTP works in the DeviceTester, it will work in a Landsweeper scan.   

Mercedes_O
Community Manager
Community Manager

Thank you for sharing your solution with the rest of the community @lkeyes !

lkeyes
Engaged Sweeper III

(cue sheepish grin here...)   Ok....I think I figured it out.... the units have been declared inactive,  so don't appear in the usual list of Active assets.    

rom
Champion Sweeper III

One thing I do for UPSs and other things -  I make a modified port switch report and look for the first three MAC pairs of the MAC address (or otherwise look for the MAC address commonalities for the APC UPS devices for example) - where there is not an asset name match (i.e. lansweeper doesn't have an asset for it associated with the port) - and that gets me the APC UPS's that I haven't swept yet.

 

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename As AssetType,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblSNMPInfo.IfIndex As [If],
  tblSNMPInfo.IfDescription As Name,
  tblSNMPIfTypes.IfTypename As Type,
  tblSNMPInfo.IfAdminstatus As Admin,
  tblSNMPInfo.IfMTU As MTU,
  Ceiling(tblSNMPInfo.IfSpeed / 1000 / 1000) As Speed,
  tblSNMPInfo.IfIPAddress As IP,
  tblSNMPInfo.IfMask As Mask,
  tblSNMPInfo.IfMacaddress As MAC,
  tblAssets1.AssetName As Asset,
  tblSNMPInfo.IfOperstatus,
  tblSNMPAssetMac.AssetMacAddress
From tblAssets
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblSNMPInfo On tblAssets.AssetID = tblSNMPInfo.AssetID
  Inner Join tblSNMPIfTypes On tblSNMPIfTypes.IfType = tblSNMPInfo.IfType
  Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
      And tblAssets.IPNumeric <= tsysIPLocations.EndIP
  Left Join tblSNMPAssetMac On tblSNMPAssetMac.AssetID = tblSNMPInfo.AssetID And
      tblSNMPAssetMac.IfIndex = tblSNMPInfo.IfIndex
  Left Join tblAssetMacAddress On tblAssetMacAddress.Mac =
      tblSNMPAssetMac.AssetMacAddress
  Left Join tblAssets tblAssets1 On
      tblAssets1.AssetID = tblAssetMacAddress.AssetID
Where tsysAssetTypes.AssetTypename = 'switch' And tblAssets1.AssetName Is Null
  And tblSNMPAssetMac.AssetMacAddress Is Not Null And
  tblSNMPAssetMac.AssetMacAddress Like '28:29:86%'
Order By tblAssets.IPNumeric,
  [If]