1 Reply Latest reply on Nov 15, 2012 7:28 AM by ryanrutan

    How to query jiveviewcount via Python script?



      We are running Jive SBS server version 4.5.x and so there is no Jive API for getting page view counts. I was told there is a way to query the jiveviewcount table directly, but there is no documentation on how to perform such a query. (i.e. SQL:- select viewcount from jiveviewcount where objectid=1011 and objecttype=1).


      So my question is how does one execute such a query on the jiveviewcount table via Python? How does one connect to the server and what login credentials are needed? I have admin login creds but since there is no documentation on how to connect to the db, query, and get the results out.


      Any help would be greatly appreciated.