How to query all active approval processes

Question

I'd like to query all Active approval process, know what Object they control, and ultimately pull the type of Approver (related, user, queue etc..) is this possible? doesn't seem like it..

Answer 1

you can do it by means of Process.. sobjects:

• ProcessDefinition (Represents the definition of a single approval process.)
• ProcessInstance (Represents an instance of a single, end-to-end approval process. Use this and the node, step, and workitem process instance objects to create approval history reports.)
• ProcessInstanceHistory (This read-only object shows all steps and pending approval requests associated with an approval process (ProcessInstance).)
• ProcessInstanceStep (Represents one work item in an approval process (ProcessInstance).)
• ProcessInstanceNode (Represents a step in an instance of an approval process. Compare to ProcessNode, which describes the step in a process definition. Use this object to retrieve approval history.)
• ProcessInstanceWorkitem (Represents a user’s pending approval request.)

Answer 2

SELECT Id,Name, DeveloperName, TableEnumOrId,Description, State, Type from ProcessDefinition where TableEnumOrId = and State ='Active'