Has anyone ever collected data using SNMPWALK on excel? Have a little bit of trouble trying to find a working VBA example for this. Pretty much all I want it to do is get temperature readings and record them in a spreadsheet over a given interval.
This is what I've been working with. It does get the temperature data I need, but only shows it in a MsgBox.
Thanks.
This is what I've been working with. It does get the temperature data I need, but only shows it in a MsgBox.
Code:
Sub SNMPWALK()
Set S = CreateObject("wscript.shell")
Set S = S.Exec("C:\usr\bin\snmpwalk -mALL -v1 -cpublic 10.68.110.05 .1.3.6.1.4.1.3")
MsgBox S.StdOut.ReadAll
End Sub
Thanks.