Clovertech

Metadata Report for SmatDB

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › Metadata Report for SmatDB

  • Creator
    Topic
  • February 26, 2018 at 3:27 pm #55632
    Tom Righele
    Participant

      Hello all-

      I’ve been asked to generate a report based off of our SMAT to identify when there are long periods of inactivity. Is there anyway to write a TCL or sh script to spit out metadata of specific smat files?

      Thanks,

      Tom

      8)

    • Creator
      Topic
    Viewing 5 reply threads
    • Author
      Replies
      • February 26, 2018 at 9:25 pm #85968
        Mark Thompson
        Participant

          If you are using smatdb, an sqlite query can gather information for you.

          This script (written for AIX) uses Tcl sqlite library routines to display MessageContent.  The SELECT statement could be altered to whatever metadata fields you want to view.  See https://www.sqlite.org/tclsqlite.html

          Code:


          #!/usr/bin/env hcitcl
          #
          ######################################################################
          # Name:      smatdb2nl
          # Purpose:   Dump smatdb files to nl-delimited messages
          # UPoC type: script
          # Args:      smatdb1 … smatdbN
          #
          # Returns:   Newline delimited messages
          #
          # Notes:
          # It will be difficult to find message boundaries in the output for messages containing NL characters.
          # Script does not work with encrypted smatdb files – see hcismatdb for help.
          #
          # History:
          # Internal documentation notes here …

          proc smatdb2nl {argv} {
          foreach smatfile $argv {
          sqlite smatdb $smatfile
          smatdb eval {SELECT MessageContent FROM smat_msgs} {
          puts [string map [list n r] $MessageContent]
          }
          }
          }
          smatdb2nl $argv

          - Mark Thompson
          HealthPartners

        • February 27, 2018 at 2:05 am #85969
          Tom Righele
          Participant

            Thank you Mark! I’m unfortunately working with encrypted smatdb files. Anyway to get around this easily?

            -Tom

          • February 27, 2018 at 2:07 pm #85970
            Mark Thompson
            Participant

              Adding this line before the SELECT in the code above will apply your encryption key.

              Warning:  Using this on an unencrypted database immediately encrypts the database.  See Charlie Bursell’s hcismatdb for a great example of how to cautiously open encrypted smatdb’s.

              Code:

              smatdb eval “PRAGMA KEY=’yourEncryptionKeyHere'”

              - Mark Thompson
              HealthPartners

            • February 27, 2018 at 4:38 pm #85971
              Keith McLeod
              Participant

                Have not explore the meta data aspect.

              • February 27, 2018 at 9:23 pm #85972
                Tom Righele
                Participant

                  Thank you all for your responses!

                  I’ve been playing around with these and I’m still having some trouble. I apologize, I’m not very familiar with SQLite.  ðŸ˜³

                  I’ve copied a smatdb to a test folder and ran the smatdb2nl against the file, but I am not seeing anything. Should I be seeing some type of output after I run the file?

                  Thanks again and apologize for the questions!

                • February 27, 2018 at 10:06 pm #85973
                  Mark Thompson
                  Participant

                    The smatdb2nl script does not work on encrypted files unless you add that functionality.

                    You can test sqlite from an command line like this.  Count the number of records in the smatdb, where smatdbname is the full file name, encryptionKey is your encryption key.

                    Code:

                    >sqlite smatdbname
                    sqlite> PRAGMA KEY=”encryptionKey”;
                    sqlite> select count(*) from smat_msgs;

                    If you send me a PM, we can arrange a time to look at this offline.

                    - Mark Thompson
                    HealthPartners

                • Author
                  Replies
                Viewing 5 reply threads
                • The forum ‘Cloverleaf’ is closed to new topics and replies.