Although, this works, I prefer to use Nagios to check. However, to do that, I need some way of talking to Qlikview. Good thing they provide the job status via SNMP. However, the documentation only states that they have it. The documentation doesn't tell you much more than that.
So, after mucking around with it for a few days and not getting very far with snmpwalk, I logged a ticket with Tech Support. The original response from Tech Support was that they didn't support snmpwalk.
I called them and they claim to have never heard of SNMP. So, I guided Tech Support to the documentation and Tech Support was surprised.
I gave Tech Support a crash course on SNMP and asked her to go check with someone and get back to me.
About 3 to 4 days later, I got a response. I think this may have come from a second tier support. He said he used a GUI snmp tool and it worked. He pointed me to (http://www.manageengine.com/products/mibbrowser-free-tool/). Ok, fine, it works but now I'm still stuck as I'm having trouble with snmpwalk and snmpget. By the way, he said the MIB file provided was DOA and he sent a working copy (so don't be surprised if you try to load the MIB file you have and it fails)
AND IT WORKS!!
Finally, I figured it out.
First, install the net-snmp tools and then install cygwin (or use the dos prompt if you want; for some reason, the dos prompt doesn't require "-L o" but cygwin does)
net-snmp tools
http://www.net-snmp.org/download.html
cygwin
http://www.cygwin.com
From the cygwin window, type:
snmpwalk -v 1 -c public -L o $hostname:4721 1.3.6.1.4.1.30764.1.2.2.1.1.3
(this returns something but it hangs; not sure why)
snmpget -v 1 -c public -L o $hostname:4721 1.3.6.1.4.1.30764.1.2.2.1.1.3.0
Just continue adding the last digit of the OID to get the next job status. I.e.1.3.6.1.4.1.30764.1.2.2.1.1.3.1
1.3.6.1.4.1.30764.1.2.2.1.1.3.2
1.3.6.1.4.1.30764.1.2.2.1.1.3.3
and so on....
The only caveat is that by default Qlikview decided that SNMP should be off by default so you need to enable it. Example:
enable SNMP for ALL Qlik services in %Program Files%\QlikView\%
Files to edit are
1.QVManagementService.exe.
2.QVDistributionService.exe.
3.QVDirectoryServiceConnector.
This is a great and interesting post that you shared about qlikview.I am sure that the students will really love to read this informative post. QlikView Training in Hyderabad
ReplyDeleteThanks. You may have to double-check that OID. I seem to remember that either I typo the OID or Qlikview changed it.
DeleteTraditional OLAP/cube technologies primarily provide the ability to drill up and down through “dimension” hierarchies, allowing the end-user to see pre-aggregated “measures”.Dimensions and measures must be know a priori.A small team is usually required to complete a BI project.I just want to say I’m very new to blogging and definitely loved your web page.thanks.qlikview training in hyderabad
ReplyDeleteHello Gou and thanks for shared all this useful infos!
ReplyDeleteI try to import mibs from qliktech.mib file found on support folder of installation but i receive error. Do you have any working mibs file?
thanks
Apostolis
Unfortunately, those files are owned by Qliktech and they probably have a fit if I distributed them. You should contact their tech support.
Deletehi Gou,thank u for sharing
ReplyDeleteI have enable the snmp in all .config file, the default port e.g 4731 still cannot open even in telnet,do you perhaps know if miss some steps?