Thread/Message Statistics

[Greg Tataryn]

Before trying to reinvent the wheel I was wondering if anyone has some scripts or other tools that can be used to pull thread/message statistics?

Looking for some way to get hourly, daily, and/or weekly statistics on the number of messages received and or sent on various interfaces.

Our intention would be to output to a CSV file so it can be shared with leadership on a regular basis.

Topic

[Peter Heggie]

Also am interested in this for a similar purpose.

Peter Heggie

[Levy Lazarre]

In the TCL Library section, a script has been posted that may help you in crafting your own. See it there:

<LINK_TEXT text="

https://usspvlclovertch2.infor.com/viewtopic … atistics

“>

https://usspvlclovertch2.infor.com/viewtopic.php?t=1473&highlight=statistics

"><LINK_TEXT text="

https://usspvlclovertch2.infor.com/viewtopic … atistics

“>

https://usspvlclovertch2.infor.com/viewtopic.php?t=1473&highlight=statistics

[James Cobane]

Greg,

Attached is a script that we created to capture thread statistics into an SQLite database; we execute the script via cron at midnight for each site that we have.

[Rob Lindsey]

What we do is to run a script just before midnight for each site to write the data out to a CSV file.  All of the CSV files are then processed into a SQLite DB that we can use to run reports.  Of course we keep the CSV files around for a long time.  I have stats going back to when the engines were created on the systems they are running on.

Of course since this is for a LAB company we have thousands of interfaces and many, many sites.  I found directly inserting into a DB from all of the sites was not working for us due to the number of inserts at the same time.

Rob

[Paul Bishop]

We have a script that runs just after midnight.  It’s kinda clunky and probably needs re-writing (I wrote it when I was first learning the cloverleaf system), but it finds all of the sites and then uses the nfLoad processes to pull in all the thread names.  Then it issues the hcimsiutil -dd command to pull in the data, parses and writes it out, and resets the thread counts (hcimsiutil -xt).

The record layout follows an HL7 format – full format document is attached:

HDR

THREAD

PROTO

COUNTS

{ITS}

I then have various scripts that I can run to create reports off of this data.

Paul Bishop
Carle Foundation Hospital
Urbana, IL

[Greg Tataryn]

A big thanks to James for sharing his script. I was able to make use of at least part of it since it was pulling more data than we need for the time being.

[Author]

Replies