09-10-2014 07:30 PM
Solved! Go to Solution.
09-11-2014 03:13 PM
Your colleague mentioned the required database table, tblAssetCustom, in his previous emails. A sample report that lists the manufacturer and model of printer assets can be seen below.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tsysAssetTypes.AssetTypename = 'printer' And tblAssetCustom.State = 1
As stated previously however we can only retrieve this information for network printers scanned with SNMP. There is no way for us to know whether or not SNMP is enabled on your printers or what your SNMP credentials are if SNMP is in fact enabled. Many network devices have SNMP enabled by default and use “public” or “private” as their SNMP string, but this is not a hard and fast rule. We recommend running DeviceTester.exe to verify whether you can access SNMP on your printers. Instructions for this were included in our previous reply, which we’ve pasted below your email for reference.
• If you cannot access SNMP with DeviceTester.exe, Lansweeper will not be able to retrieve the printer’s manufacturer or model.
• If you are able to access SNMP with DeviceTester.exe, Lansweeper should be able to retrieve the printer’s manufacturer and model, if you use the same SNMP credential for scanning. Instructions for creating and mapping credentials and rescanning can be found in our previous email. A printer scanned with SNMP will have an OID listed on its Lansweeper webpage.
09-11-2014 03:13 PM
Your colleague mentioned the required database table, tblAssetCustom, in his previous emails. A sample report that lists the manufacturer and model of printer assets can be seen below.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tsysAssetTypes.AssetTypename = 'printer' And tblAssetCustom.State = 1
As stated previously however we can only retrieve this information for network printers scanned with SNMP. There is no way for us to know whether or not SNMP is enabled on your printers or what your SNMP credentials are if SNMP is in fact enabled. Many network devices have SNMP enabled by default and use “public” or “private” as their SNMP string, but this is not a hard and fast rule. We recommend running DeviceTester.exe to verify whether you can access SNMP on your printers. Instructions for this were included in our previous reply, which we’ve pasted below your email for reference.
• If you cannot access SNMP with DeviceTester.exe, Lansweeper will not be able to retrieve the printer’s manufacturer or model.
• If you are able to access SNMP with DeviceTester.exe, Lansweeper should be able to retrieve the printer’s manufacturer and model, if you use the same SNMP credential for scanning. Instructions for creating and mapping credentials and rescanning can be found in our previous email. A printer scanned with SNMP will have an OID listed on its Lansweeper webpage.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now