Custom OID Scan - HP C3000 Blade Enclosure

[duncanc]

Hi there

I get "No Data Found" when I do a OID scan of the blade enclosure. I see in the snmptalk logs the Enclosure is seeing the data it should bex expeceting from Lansweeper. But no data found. Attached are results.

Anyhelp would be great!

Thanks again!

Cheers

[JamesArm]

Did you ever end up figuring out what was wrong? I'm running into the same thing right now.

[duncanIT]

Thank you for contacting Lansweeper Support!

We created a report for you for which you can find the query below. This report will show, as an example, scanned OID data holding an OID label called 'Enclosure Ambient Temp' and a value higher than 18. Depending on what you require seeing, you might need to alter those values.

Instructions for adding this report to your Lansweeper installation can be found here: https://www.lansweeper.com/knowledgebase/how-to-add-a-report-to-your-lansweeper-installation/

If you are interested in building or modifying reports, we do recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial: https://www.w3schools.com/sql/
• Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here: https://www.lansweeper.com/knowledgebase/accessing-the-lansweeper-database-documentation/
• Checking out our report library: https://www.lansweeper.com/report/

If you want to set a report alert on this, you can follow the steps below:

• https://www.lansweeper.com/knowledgebase/sending-email-alerts/

For your question on the reports “Thermal state: Critical/warning”, these report list the Thermal state of the system when last booted. This information is being scanned from the Win32_ComponentCategory WMI class. More info on this class can be found here: http://msdn.microsoft.com/en-us/library/aa394100%28v=vs.85%29.aspx

 

 Select Top 1000000 tblAssets.AssetID,  tsysAssetTypes.AssetTypeIcon10 As Icon,  tblAssets.AssetName,  tblOIDData.Label As [OID Label],  tblOIDData.[Key] As OID,  tblOIDData.Data As [OID Data],  tblAssets.Domain,  tblAssets.IPAddress,  tblAssets.Description,  tblAssetCustom.Manufacturer,  tblAssetCustom.Model,  tblAssetCustom.Location,  tsysIPLocations.IPLocation,  tblAssets.Firstseen,  tblAssets.LastseenFrom tblAssets  Inner Join tblOIDData On tblAssets.AssetID = tblOIDData.AssetID  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype  Left Outer Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID  Left Outer Join tsysOS On tsysOS.OScode = tblAssets.OScode  Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric    And tsysIPLocations.EndIP >= tblAssets.IPNumericWhere tblOIDData.Label= 'Enclosure Ambient Temp'  and cast(tblOIDData.Data as nvarchar) != 'No data found.'AND cast(cast(tblOIDData.Data as nvarchar) as int) > 18 

Reply I got from Lansweeper. This was coming up to 4 years ago.

Cheers

[filip]

If you follow this step by step guide:
https://www.lansweeper.com/knowledgebase/troubleshooting-custom-oid-scanning-issues/
A reference to : Program Files (x86)\Lansweeper\Actions\Devicetester.exe
is made. Do you have results in the execution of the query here ?