[SalesForce] SFMC – Get all existing automation

If you're querying from a child account, you'll need to prefix the view name with ent.

SELECT top 100 
EmailAddress
, SubscriberID 
FROM ent._ListSubscribers 
WHERE ListID = 258

Reference: Query Activity

Welcome!

If you want to extract all automations available in BU, then you can use Status / IN filter to have all the possibilities. Also when you change "AutomationID" in cols with "ProgramID" it's going to pop up.

<script runat="server">

  Platform.Load("Core","1");

  var prox = new Script.Util.WSProxy();

  var cols = ["Name","Status","StartTime","ProgramID"];

  var filter1 = {
      Property:"Status",
      SimpleOperator:"IN",
      Value: [-1,0,1,2,3,4,5,6,7,8]
  };
  var res = prox.retrieve("Automation",cols,filter1);

  if (res.Results.length > 0) {
      
      var statusObj = {
  "-1":"Error",
  "0":"BuildingError",
  "1":"Building",
  "2":"Ready",
  "3":"Running",
  "4":"Paused",
  "5":"Stopped",
  "6":"Scheduled",
  "7":"Awaiting Trigger",
  "8":"InactiveTrigger"
}
      
      
      Write('<table align="center" border="1" cellpadding="5" ><tr><th colspan="3">Automation Dashboard</th></tr>')
      for (var i = 0; i < res.Results.length; i++) {
          var autoName = res.Results[i].Name;
          var autoStatusNum = res.Results[i].Status;
          var autoStatus = statusObj[autoStatusNum];
          var StartTime = res.Results[i].StartTime;
           var ID = res.Results[i].ObjectID;
        
          
          Write('<tr><td>' + autoName + '</td><td>' + autoStatus + '</td></tr>'+'<tr><td>' + StartTime +'<tr><td>' + ID)
      }
      Write('</table>')
  }

</script>