Action details using Query
Email Action Details :
SELECT AM_ACTIONPROFILE.ID AS ACTION_ID, NAME AS ACTION_NAME, FROMADDRESS, TOADDRESS FROM AM_ACTIONPROFILE LEFT JOIN AM_EMAILACTION ON AM_ACTIONPROFILE.ID = AM_EMAILACTION.ID WHERE AM_ACTIONPROFILE.TYPE = 1
Action Association Details using Action ID :
SELECT MO.RESOURCEID AS "RESOURCE ID", MO.DISPLAYNAME AS "MONITOR DISPLAY NAME", MO.RESOURCENAME AS "RESOURCE NAME", MO.TYPE AS "MONITOR TYPE", AAM.ATTRIBUTE AS "ATTRIBUTE ID", AM.ATTRIBUTE AS "ATTRIBUTE NAME", CASE WHEN SEVERITY=1 THEN 'CRITICAL' WHEN SEVERITY=4 THEN 'WARNIG' ELSE 'CLEAR' END AS SEVERITY, AP.ID AS "ASSOCIATED ACTION ID", AP.NAME AS "ASSOCIATED ACTION NAME" FROM AM_ACTIONPROFILE AS AP JOIN AM_ATTRIBUTEACTIONMAPPER AS AAM ON AP.ID = AAM.ACTIONID JOIN AM_ManagedObject AS MO ON MO.RESOURCEID = AAM.ID JOIN AM_ATTRIBUTES AS AM ON AM.ATTRIBUTEID = AAM.ATTRIBUTE WHERE AP.ID = <actionID>
Note : Replace the <actionID> with the correct Action ID
Action Association Details using Action Name :
SELECT MO.RESOURCEID AS "RESOURCE ID", MO.DISPLAYNAME AS "MONITOR DISPLAY NAME", MO.RESOURCENAME AS "RESOURCE NAME", MO.TYPE AS "MONITOR TYPE", AAM.ATTRIBUTE AS "ATTRIBUTE ID", AM.ATTRIBUTE AS "ATTRIBUTE NAME", CASE WHEN SEVERITY=1 THEN 'CRITICAL' WHEN SEVERITY=4 THEN 'WARNIG' ELSE 'CLEAR' END AS SEVERITY, AP.ID AS "ASSOCIATED ACTION ID", AP.NAME AS "ASSOCIATED ACTION NAME" FROM AM_ACTIONPROFILE AS AP JOIN AM_ATTRIBUTEACTIONMAPPER AS AAM ON AP.ID = AAM.ACTIONID JOIN AM_ManagedObject AS MO ON MO.RESOURCEID = AAM.ID JOIN AM_ATTRIBUTES AS AM ON AM.ATTRIBUTEID = AAM.ATTRIBUTE WHERE AP.NAME = '<actionName>'
Note : Replace the <actionName> with the correct Action Name
New to ADSelfService Plus?
Related Articles
Service Now Event Integration using Webhook / Rest API Action
Steps to perform in Service Now 1) Login to your ServiceNow Instance(dev*****133.service-now.com) 2) Search for the Rest API Explorer and open it 3) In the Rest API Explorer page choose the Namespace and API Name with the proper API version. For ...Execute Program action - Enterprise Admin server behavior & Known limitation
Behavior in Enterprise Admin server In case of Enterprise Admin users, following is the behavior of Execute Program action: All Host in the selected Monitor Group option is not supported Auto Select Host option is partially supported. Since the host ...SDP MSP Ticket Action not working
Problem : While adding SDP MSP via Rest API in Applications Manager we get the following error : "Unable to fetch values from ServiceDesk Plus, The server might not be running or the network traffic may be too high" In Create a new Ticket page, all ...Why don't I see the custom messages & replaceable tags given in an action in the alarm escalation notification ?
Alarm escalation provides the option for escalation if any alarm has not been attended for a given time period to an email address(s) or mobile number(s) or if a specific program was executed. The notification template & work flow logic used in the ...Integrating Telegram with Applications Manager using Webhook
Telegram is a cloud-based instant messaging, video telephony and VoIP service with end-to-end encryption. Users can send messages and exchange photos, videos, stickers, audio and files of any type in Telegram. Using Webhook, you can now integrate ...