![]() ![]() TblSNMPAssetMac. Where tsysAssetTypes.AssetTypename = 'switch' And tblAssets1.AssetName Is NullĪnd tblSNMPAssetMac.AssetMacAddress Is Not Null And 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, If your machine does not have Internet access. the Lansweeper installer will automatically try to download and install this for you. ![]() Non-Windows machines have less of an impact on database size. Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon, However, as a general rule, we recommend reserving 1GB of disk space per 1,000 Windows computers. 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. |