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.
Access to the DB will need to be arrange via your system administrators. There is no standard host, username, password that is guaranteed to work. As for the table, it seems like you have the query you want down.
Since I haven't done Python in a while, I found this tutorial that might help: