SQL Schema Documentation
Posted: Tue Sep 10, 2019 1:55 pm
Hi there,
I contacted support because we are looking to purchase this plugin but needed some information first. We are looking to create automated reports of the browsing history for each client by exporting to a .csv for Client, Location, Computer. I was told this is possible by creating a script.
"The process would be,
Create a script that queries the plugins_sw_surflog_xxx tables in Automate and writes that data out to a file.
That is the simple answer, actually writing the script will require a little bit more tech knowhow. The Automate script will need to craft SQL queries to get the data you want by client and or agent id, loop through each row and add that rows data in CSV format to a text file, afterwards present file(s) to you in some manner. Then assign script to run once a month to each client you want to do this for.
The data is there and available in Automate for you to use as you see fit." - Shannon Anderson
My next question to that response was if there is documentation on the SQL Schema for the plugin and I was told to go to the forums and I could get answers to my questions. Again, we haven't purchased this plugin yet as we want to see if it will suit our purposes and if there would be necessary documentation to back it up so our techs can easily create queries when needed.
Thanks for the help!
-Dominick
I contacted support because we are looking to purchase this plugin but needed some information first. We are looking to create automated reports of the browsing history for each client by exporting to a .csv for Client, Location, Computer. I was told this is possible by creating a script.
"The process would be,
Create a script that queries the plugins_sw_surflog_xxx tables in Automate and writes that data out to a file.
That is the simple answer, actually writing the script will require a little bit more tech knowhow. The Automate script will need to craft SQL queries to get the data you want by client and or agent id, loop through each row and add that rows data in CSV format to a text file, afterwards present file(s) to you in some manner. Then assign script to run once a month to each client you want to do this for.
The data is there and available in Automate for you to use as you see fit." - Shannon Anderson
My next question to that response was if there is documentation on the SQL Schema for the plugin and I was told to go to the forums and I could get answers to my questions. Again, we haven't purchased this plugin yet as we want to see if it will suit our purposes and if there would be necessary documentation to back it up so our techs can easily create queries when needed.
Thanks for the help!
-Dominick