01-04-2023 08:02 PM - last edited on 04-02-2024 11:17 AM by Mercedes_O
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.
Solved! Go to Solution.
01-04-2023 08:30 PM
(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.
01-11-2023 08:44 PM
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]
03-06-2023 05:35 PM
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?
06-02-2023 10:42 AM
@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.
06-02-2023 03:58 PM
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?
01-11-2023 08:59 PM
ROM....that's fantastic! Thanks so much.
01-11-2023 03:00 PM
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.
01-05-2023 03:02 PM
Thank you for sharing your solution with the rest of the community @lkeyes !
01-04-2023 08:30 PM
(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.
01-11-2023 08:44 PM
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]
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now