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

    How to query jiveviewcount via Python script?

      Hi,

       

      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.

       

      Regards,

      Greg