Asset Manager 9.6x - Where are workflow action scripts stored?

[Mike H]

Hello,

Where in the database could I find the scripts for workflow actions?

The amAction table has an LSCRIPTID column. I chose a known action and found its lscriptid. I have checked every table I could find with the word "SCRIPT" in the name, and that script id is not found in any of them.

The Physical Data Model document ( https://softwaresupport.hpe.com/km/KM01450460 ) specifies the location of the event scripts (amWkEvtScript) but says nothing about the action scripts.

My need here is to be able to quickly generate reports on scripts meeting certain criteria (e.g., identify all scripts that send email, or possess any other quality in which we might be interested).

Thank you

[Mark Cullen_1 · Accepted solution]

'Actions memo (amActionMemo)' is the table for the following action table links...

'Description (Description)' - lDescId

'Selection query (Query)' - lQueryId

'Action script (Script)' - lScriptId

'Wizard script (WizardScript)' - lWizScriptId

Other action types either have links to other tables or related elements are directly on 'Actions (amAction)' table.

BTW, actions used in workflows can be found in table 'Workflow activities - Actions relation (amRelWfActivAct)' which stores the relationship between 'Actions (amAction)' and 'Workflow activities (amWfActivity)' (yes, a workflow activity can have multiple actions associated).

[Mike H]

Thank you, Mark! That was exactly what I needed to know.