OTRS Integration - SQL Query

jjquintero245

Good day!

I'm using Orion integrated with OTRS (CentOS Stream 9) as Ticket System and I have these two questions:

1. I'm trying to create a new widget to run Custom SQL query, but I can only find Custom SWQL, Is it possible to create Custom SQL queries?

2. Using SQL query I can see the tickets with lot of information, is there any way to run this custom query only in the OTRS server?

This is the query I'm using in the OTRS Server

SELECT 
    t.id AS ticket_id,
    t.title AS ticket_title,
    t.create_time AS ticket_create_time,
    t.change_time AS ticket_change_time,
    ts.name AS ticket_name,
    ts.create_time AS ticket_creation_time,
    ts.change_time AS ticket_change_time
FROM otrs.ticket AS t
LEFT JOIN otrs.ticket_state AS ts ON t.ticket_state_id = ts.id
WHERE ts.type_id = 1;

Thanks

Seashore

As said, you can only run queries on a widget against the solarwinds databases. So first you want to monitor the values, to get them into the database. I wrote some about that some time ago, read more here:  SQL Query monitoring in Orion SAM – best practice