Within the database I can find out which events have which condition macro's attached just by running a simple query. How do I though identify within the database which Actions on True Macros are associated to an event.
So how do I find the P1 Initial and Notify Group Manager associated to this event via the database.
'bop_sinfo' to the rescue...
The 'action on true' macros are linked through 'lrel_true_action_act_t'. The schema name for that is also revealed by 'bop_sinfo':
So you can join to 'usp_lrel_true_action_act_t' in the database using the event id to find the 'action on true' macro id's, and join again to 'splmac' to get the macro names.
Hope that helps.
Great on target advice. The bop_sinfo command really is a great way to see additional detail.
It is particularly useful because it gives in real time what the SDM system actually has loaded and knows about, which in rare cases can be different to what is written into other locations.
I'd just add some links on bop_sinfo.
What does the bop_sinfo command do? - CA Knowledge
How to get a mapping of all Service Desk objects a - CA Knowledge
Is there a command I can use to get a list of all - CA Knowledge
And of course the CA ITSM documentation:
bop_sinfo--Display System Information - CA Service Management - 17.2 - CA Technologies Documentation
Thank you James, much appreciated....