Can you rename an Alert Queue?

[Daniel Blanco]

Is it possible to rename and existing Alert Queue? 

Maybe thru a SQL DB query but would that mess up a whole slew of other tables if we did this? Just wondering b/c we named an Alert Queue with items that are now removed so instead of re-creating a new queue could I rename it thru some method? 

TIA...

------------------------------
Daniel Blanco
Enterprise Tools Team Architect
[e-mail]
------------------------------

[Michael Boehm]

Hi Dan,

I tested the following procedure on my system:
The names of the Alert Queues are stored in the SQL table AlertQueues - all other references are via the QueueID.
You can use the following SQL query to update the name:
UPDATE AlertQueues
   SET QueueName = '<new name>'
   WHERE QueueID = <n>

Example
UPDATE AlertQueues
   SET AlertName = 'Alerts from SNMP'
   WHERE QueueID = 10

Because this is a hard update directly in the DB, no process is informed about it, and thus a restart of the complete system (SOI Manager and UI server) is required to pick up the change.

Hope this helps.  Let me know if you need more information.
Stay healthy

Michael

------------------------------
Customer Success Architect
CA Deutschland GmbH (a Broadcom company)
------------------------------

[Daniel Blanco]

Thanks Michael. I'll do this then on next opportunity. 
Hope all is good with you and stay safe out there.
Take care.

------------------------------
Daniel Blanco
Enterprise Tools Team Architect
[e-mail]
------------------------------

[Daniel Blanco]

Hi Michael,
Just a correction to your example above:

Example
UPDATE AlertQueues
   SET AlertName = 'Alerts from SNMP'
   WHERE QueueID = 10

Should be:

Example
UPDATE AlertQueues
   SET QueueName = 'Alerts from SNMP'
   WHERE QueueID = 10

------------------------------
Daniel Blanco
Enterprise Tools Team Architect
[e-mail]
------------------------------