![]() ![]() ![]() TblSNMPAssetMac. Lansweeper partners with LOGON to deliver Asset Visibility for Cyber Security in Asia. ![]() Where tsysAssetTypes.AssetTypename = 'switch' And tblAssets1.AssetName Is NullĪnd tblSNMPAssetMac.AssetMacAddress Is Not Null And Download this white paper: Lansweeper for Cyber Asset Attack Surface Management (CAASM), to learn how Lansweeper enables CAASM by providing. TblAssets1.AssetID = tblAssetMacAddress.AssetID Left Join tblAssetMacAddress On tblAssetMacAddress.Mac = TblSNMPAssetMac.IfIndex = tblSNMPInfo.IfIndex Left Join tblSNMPAssetMac On tblSNMPAssetMac.AssetID = tblSNMPInfo.AssetID And Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIPĪnd tblAssets.IPNumeric <= tsysIPLocations.EndIP Inner Join tblSNMPIfTypes On tblSNMPIfTypes.IfType = tblSNMPInfo.IfType Inner Join tblSNMPInfo On tblAssets.AssetID = tblSNMPInfo.AssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype TsysAssetTypes.AssetTypename As AssetType,Ĭeiling(tblSNMPInfo.IfSpeed / 1000 / 1000) As Speed, Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon, 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. 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. ![]()
0 Comments
Leave a Reply. |