1 Reply Latest reply on Oct 13, 2018 1:27 PM by patrick.byrne.0

    Logshark Postgres database

    Elena Semenova

      Hi All!

       

      Does anyone have a data dictionary and/or relationship diagram for a database created by Logshark? There is an obvious relationship between tables created by the same plugins but how about others?

       

       

      Thank you!

       

      Elena

        • 1. Re: Logshark Postgres database
          patrick.byrne.0

          Hello Elena,

           

          I have not been able to find one that has been created and publicly shared. Tableau does not currently have a customer facing data dictionary. See the below section from the Tableau GitHub site for additional options.

          Creating Your Own Custom Workbooks from Logshark Data

          Currently, there isn’t a customer facing data dictionary for Tableau logs since it is very difficult to keep it current and up to date from version to version as the log formats change. In the absence of such a dictionary, your best option would be to break apart some of the existing workbooks generated by Logshark and exploring the fields within it to determine what data is available to answer your questions. Outlined below is one suggestion on how you can achieve this:

          1. Download Fiddler and launch it
          2. In Fiddler, configure it to Decrypt HTTPS traffic i.e. if SSL is enabled on your Tableau installation
          3. Launch Tableau Desktop or for Tableau Server, open your favorite browser, and perform any specific operation(s)
          4. View the traffic in Fiddler to determine the endpoints that were hit when performing that specific operation(s). Use this information, to find the corresponding request in the Apache httpd logs. (For Server File log locations see: https://onlinehelp.tableau.com/current/server/en-us/logs_loc.htm, for working with log files see: https://onlinehelp.tableau.com/current/server/en-us/logs_working_with.htm).
          5. Use the Session ID to trace and search this request across all the logs. Check to see if this answers your question for that individual request and make a note of all the logs that had information about your request.
          6. If so, run Logshark, start with the Apache workbook and filter down to your specific request. Explore the data fields related to your request ID and see if you can build a view to answer the same question with the Logshark data.

           

          Source: Adding and Creating Your Own Custom Workbooks for Logshark

           

          If you create one or find one please share it with the Community Forums! I would love to have it as a resources myself.

           

          Hope this helps!

           

          Cheers,

          Byrne, Patrick

          Community Manager