@rickeypritchett
Forum Replies Created
-
AuthorReplies
-
Would the sqliterc be used by a tcl script?
Can you share the contents of that file?
If on Linux and using “load sqlite3-regex.so” do we still need to enable the load option?
On another note, I was trying to access a smat file, not the error db in this case.
In the documentation, I found the Smat API. Does anyone have an example where the call is in a standalone TCL proc? I keep getting an error that the directory or file does not exist.
And in the example below I used -e ASCII in place of user_defined to open my file. I used this since that is what is in my netconfig. Is this the correct usage?
set smatdbTest [smatdbopen test.smatdb user_defined]
Thanks, guys. I got it working. Jim K. Let us know how the PostgreSQL project goes.
Using SQL. I thought we could use a join in the newer versions.
What I would like to do is look at different pieces of metadata such “DriverCtl” and “OrigSourceConn”. The query would return distinct values. I have done sqlite queries before but not with an encrypted db. I know this is most likely possible but not sure how.
Hey Jim,
Any idea would help, and yes I would welcome any brainstorming.
Yes Jim you have it correct.
Was looking to set an alert to fire and run a script on the db not based on the alert itself but run a report on the db as a whole. The script would look at different pieces of the meta data to obtain the desired information.
We are on version 2022. I Was looking to do a proc from an alert and have it look at the protocol driver control where the information I will need to grep resides. The new DB search can do this from the GUI. I think it would be similar to the original DB commands.
So in the URL format for the Database URL under the “Edit Database Connection”?
jdbc:sqlserver://<server>:<port1433>;DatabaseName=<database>;???????
Changed it back to the last received and took out the time window and it worked.
Yes looking at that time window when the thread does the query.
Straight from files.
.err
[aler:aler:WARN/0:_hcimonitord_:08/09/2023 09:43:38] Some fields in WINDOW key are taken as ‘*’
[aler:aler:WARN/0:_hcimonitord_:08/09/2023 09:43:38] Alert def loaded with warnings:
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–]
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { NAME {last msg received1} }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { VALUE lasts }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { SOURCE fr_emmi_expired }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { WITH -2 }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { COMP {>= 1799} }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { FOR once }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { WINDOW */12:30-13:30/*/* }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { CUSTOMMSG {{ITEM {}} {DELIMITER keyvalue}} }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { ACTION {
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { email {
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { FROM cloverleaf@infor.com }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { TO rick.pritchett@XXXXXXXX.com }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { SUBJ {No messges for the thread %T between 11:30 AM to 12PM} }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { MSG {No messges for the thread %T have been sent between 11:30 AM to 12PM Please check.
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] Site – web services.} }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] } }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] } }.log
er:aler:INFO/0:_hcimonitord_:–/–/—- –:–:–] } }
[aler:aler:INFO/0:_hcimonitord_:08/09/2023 09:43:38] MODE key not found, use ‘actual’ by default.
[aler:aler:WARN/0:_hcimonitord_:08/09/2023 09:43:38] Some fields in WINDOW key are taken as ‘*’
[aler:aler:INFO/0:_hcimonitord_:08/09/2023 09:43:38] New alert ID: #14
[aler:aler:WARN/0:_hcimonitord_:08/09/2023 09:43:38] Alert def loaded with warnings:
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–]
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { NAME {last msg received1} }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { VALUE lasts }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { SOURCE fr_emmi_expired }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { WITH -2 }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { COMP {>= 1799} }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { FOR once }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { WINDOW */12:30-13:30/*/* }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { CUSTOMMSG {{ITEM {}} {DELIMITER keyvalue}} }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { ACTION {
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { email {
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { FROM cloverleaf@infor.com }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { TO rick.pritchett@xxxxxxxxx.com }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { SUBJ {No messges for the thread %T between 11:30 AM to 12PM} }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] { MSG {No messges for the thread %T have been sent between 11:30 AM to 12PM Please check.
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] Site – web services.} }
aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] } }
[aler:aler:WARN/0:_hcimonitord_:–/–/—- –:–:–] } } -
AuthorReplies
