[Keith McLeod]

I will probably keep the emails since we CC all interested parties when creating tickets, but the webservice should speed up ticket processing.

[Keith McLeod]

They generally do have API’s.  I am currently prototyping a JSON feed using oauth2 on Webservices to Halo(BMC).  I have email alerts that I am now going to drop using the existing variables into a VRL which get translated into JSON.  Functionally working just need to get more of the detail as to exactly what will create the ticket as desired.  Should be faster than email since I am currently seeing 48 minute and longer delays in the email.  I would bet that SNOW has the documentation for establishing a connection to receive ticket information and generate a ticket.

[Keith McLeod]

I usualy set up the Remote Shell Command in Client Preferences –> External Commands –> Remote Shell Command and put in the following for example: C:\Program Files\PuTTY\putty.exe @H

[Keith McLeod]

It might be helpful to have a visual of the data and what you are trying to accomplish.

[Keith McLeod]

Not sure the snippet copied. Hate when it obliterates your code…  See Attached

Attachments:

You must be logged in to view attached files.

[Keith McLeod]

You can override the URL or the Path in the userdata.  I do this using tables and a preproc in the Xlate.

I determine my key based on a value in my HL7 data to get which URL I am going to use.  I store it in @URL.

I send the path straight from the field, like PID:3.1

And if I require some Authorization for the Header, again I use the source and a table and store it in @SOME_AUTHORIZATION

I copy In my source:

@URL
1(0).0(0).0(0).PID(0).#3(0).[0]
@SOME_AUTHORIZATION

Use this preproc snippet

keylset userData httpRequestInfo.requestURL

/[lindex $xlateInVals 1]] httpRequestHeaders.SOME-AUTHORIZATION

]
xpmmetaset $xlateId USERDATA $userData

and my destination is @null since I am purely formulating the msg metadata USERDATA to override any settings ws-rawclient.

Works pretty well.  Only have to update my table values for the most part with the URL and Authorization Header info.  You can update PATH only, but once you do the URL, PATH is no longer used.

Hope this helps….

[Keith McLeod]

Have you looked in Tables and used the Database Options?

• This reply was modified 1 year, 2 months ago by Keith McLeod.

[Keith McLeod]

Can you share the link to get the downloads?  I found the release notes I think, just not the actual software.

[Keith McLeod]

I ran into an issue with the dblookup on the 2022.09.02 version.  The recommendation on mine was to upgrade the SQL server DB.  2014 I believe is marginal on what the current JDBC drivers support.  I have one system for pathology that has put off upgrading their version of SQL from 2008 R2. Luckily, they are upgrading that over the next several weeks. The current versions of SQL for other apps seems to work fine…  Something you might want to check…

• This reply was modified 2 years ago by Keith McLeod.

[Keith McLeod]

I believe the error log is a sqlite db exec/databases/elog.elogdb.

[hci@dc1vtclover01 data]$ sqlite3 elog.elogdb
SQLCipher version 3.15.2 2016-11-28 19:13:37
Enter “.help” for instructions
Enter SQL statements terminated with a “;”
sqlite> .schema
CREATE TABLE elog_info (“Version” INTEGER, “ECD” VARCHAR);
CREATE TABLE elog_msgs(
“MessageContent” BLOB,
“DataLen” INTEGER,
“DestConn” VARCHAR,
“OrigDestConn” VARCHAR,
“DataFmt” VARCHAR,
“SepChars” VARCHAR,
“DriverCtl” VARCHAR,
“UserData” VARCHAR,
“MidDomain” INTEGER,
“MidHub” INTEGER,
“MidNum” INTEGER,
“SrcMidDomain” INTEGER,
“SrcMidHub” INTEGER,
“SrcMidNum” INTEGER,
“Type” INTEGER,
“SourceConn” VARCHAR,
“OrigSourceConn” VARCHAR,
“Priority” INTEGER,
“Class” INTEGER,
“Flags” INTEGER,
“EdbState” INTEGER,
“GroupMidDomain” INTEGER,
“GroupMidHub” INTEGER,
“GroupMidNum” INTEGER,
“XltThread” VARCHAR,
“OwnerThread” VARCHAR,
“Retries” INTEGER,
“MidsAreNull” INTEGER,
“SkipXlt” INTEGER,
“GroupID” INTEGER,
“TimeIn” INTEGER,
“TimeXlt” INTEGER,
“TimeOut” INTEGER,
“TimeQCur” INTEGER,
“TimeQTot” INTEGER,
“TimeRec” INTEGER,
“ErrorString” VARCHAR,
“RdbState” INTEGER,
primary key (MidNum,MidHub,MidDomain));
sqlite>

Is this what you are looking for? My guess is that you can access in a similar way to SMATDB files and access the metadata.

[Keith McLeod]

Not sure… I tried a post twice yesterday and it appeared to cut out half of what I posted….Tried editting, but once I submitted lines were still missing or appeared to be missing….

[Keith McLeod]

hcitcl>set xlateInVals 20240402120000
20240402120000

hcitcl>regsub — {(\d{8})(\d{4,6})} [lindex $xlateInVals 0] {\1 \2} dt
1

hcitcl>echo $dt
20240402 120000

hcitcl>set xlateOutVals

-format “%m/%d/%Y %H:%M:%S”]]
{04/02/2024 12:00:00}

• This reply was modified 2 years, 1 month ago by Keith McLeod.

[Keith McLeod]

Try this:

regsub — {(\d{8})(\d{4,6})} [lindex $xlateInVals 0] {\1 \2} dt

set xlateOutVals

-format “%m/%d/%Y %H:%M:%S”]]

Example:

hcitcl>set xlateInVals 20240402120000
20240402120000
hcitcl>regsub — {(\d{8})(\d{4,6})} [lindex $xlateInVals 0] {\1 \2} dt
1
hcitcl>echo $dt
20240402 120000
set xlateOutVals

-format “%m/%d/%Y %H:%M:%S”]]
{04/02/2024 12:00:00}

Hope this helps…

• This reply was modified 2 years, 1 month ago by Keith McLeod.
• This reply was modified 2 years, 1 month ago by Keith McLeod.

[Keith McLeod]

I have a new install on Red Hat Enterprise Linux release 8.5 (Ootpa).  I have worked through several issues regarding LD_LIBRARY_PATH by modifying the environment in .profile.local.end for commands such as scp, sftp, rsync and now mail.  I received the following error prior to the modification: mail: symbol lookup error: mail: undefined symbol: SSLv3_client_method, version OPENSSL_1_1_0.

I added to .profile.local.end and this seemed to resolve from the command line.:

function mail {
if [[ -n “$HCIROOT” && -n “$CL_INSTALL_DIR” ]]; then
clinstalldir=$CL_INSTALL_DIR
hcisite=$HCISITE
hciroot=$HCIROOT
setroot -clear
/usr/bin/mail “$@”
export CL_INSTALL_DIR=$clinstalldir
setroot $hciroot $hcisite
else
/usr/bin/mail “$@”
fi
}

This works for using mail at the command line, however inside many of my notification tcl scripts I have code like:

set sm [open “| mail -s \”${client} – [string toupper $HciSite]: [string toupper $thdName] Not showing a Connection for [expr $downtime / 60] minutes.\” -c ie_mail,${systemName}_mail -r $fromAddress $mailAddress” w]
puts $sm $assign_to
puts $sm $priority
puts $sm $contact
puts $sm ${client_id}
puts $sm $description

close $sm

This brings me back to the symbol lookup error.  Any thoughts on this???

 

[Keith McLeod]

Yes it can be used and does not require ming.le.  I have just completed a configuration, however have a few questions outstanding.

1) Is there an administrator exception like there is in LDAP?

2) Does it “autoCreateCertsEnabled=true” like it does using LDAP?

Still experimenting.  Hope to be able to answer soon or hoping someone before me can share their solution.

[Author]

Replies