Decoding SMAT database

[Tahir Shaikh]

Hi,

I am using Cloverleaf 6.1.

Is there any API or any script to decode the SMAT databases to get the data out of it.

Thanks,

Tahir

Topic

[Tahir Shaikh]

I have found that there are some web services exposed such as getSiteList.

How can I consume them?

Thanks,

Tahir

[Charlie Bursell]

SMATDB or SMAT?

I wrote scripts for both, hcismatdb and hcismat which have been posted on the forum a few times.  A search should find them

[Tahir Shaikh]

Thanks Charlie,

Appreciate your work. It worked.

Some more questions-

1. In which file will I get the Thread statistics? like, How many messages are processed, how many in progress, how many erred. The same parameters which we see on right click on thread in Network monitor under status window.

2. If there any file as above, is there any script to decode it?

Thanks,

Tahir

[Charlie Bursell]

You don’t most of that info from SMAT.  You can get totals by using simple math

For the other stuff you nee MSI data

[Charlie Bursell]

SMATDB or SMAT?

I wrote scripts for both, hcismatdb and hcismat which have been posted on the forum a few times.  A search should find them

[Tahir Shaikh]

Hi Charlie,

Can we call this .htc file from within a tcl?

Thanks,

Tahir

[Charlie Bursell]

Sure but it is a Tcl file.  Why would you want to do that?

[Tahir Shaikh]

Thanks for quick reply  

I am writing a utility (.tcl) which will run in scheduled mode (I am using UPOC). From that .tcl I want to call hcismatdb command.

Is there anything I should take care of while calling hcismatdb command.

I am familiar with cloverleaf .tcl, but don’t know how to call .htc command.

Thanks,

Tahir

[Tahir Shaikh]

Here is what I am trying,

1. I copied your hcismatdb.htc in bin folder. I tested it using Remote commands window and it works fine.

2. Now I have written one tcl which will get called from UPOC. In this tcl, I have copied hcismatdb command as it is which is running from remote commands window in cloverleaf.

But I am getting error ‘invalid command name “hcismatdb”

Thanks,

Tahir

[Charlie Bursell]

I am assuming this is on Windows?   If so you can only execute ,exe, .com and .bat files directly from Tcl.  For others you need to exec Tcl and pass the path to the script.

You could simply source the file in your script then the commands would be available.  You could also redo the hcismatdb as a Tcl package.

Lots of ways to go

[Tahir Shaikh]

Hi Charlie,

I am at beginner level for all this tcl stuff.

By sourcing the file in .tcl script, I guess you mean to say copy code from .htc file to .tcl file.

I tried that but still getting invalid command error.

Also, it would be very helpful if you can share the hcismatdb in .tcl format or point me to some useful link.

Thanks,

Tahir

[Greg Tataryn]

Charlie,

Does your script work if the SMATDB files are encrypted? If not, is there a way to access encrypted SMATDB files using SQLite?

[Charlie Bursell]

Yeah it works.  If you are accessing them in a different site than where they were created you must supply the password to the script.  See:

                 hcismatdb -help

[Keith McLeod]

FYI.. Charlie.  At the Inforum 2016 conference many folks were very appreciative for that hcismatdb script.  I know I use it frequently especially when performing upgrades or extracting messages.  The time you have saved the rest of us, for that I thank you…

[Greg Tataryn]

Thank you, Charlie. I had not had a chance to dig into the script too deep just yet. At first glance I can already see it will be quite useful. Thank you for sharing with us.

[Charlie Bursell]

Thanks Keith always nice to be appreciated  

If you get a chance take a look at the tclGrep script I posted.

I am already making some minor changes

                      Deal with files without proper read permissions

                      Maybe change output to show results as found rather than

                      wait till end to see all.  Useful when using recursion

[Author]

Replies