How to get all the "In Progress" requests submitted (vRA - Requests page)

[rpotru]

Hi,

Could someone suggest how to get all the "In Progress" requests from vRA? I tried to look around API explorer but couldn't find any existing workflow/action that does this.

May be we can filter out based upon the Server.FindAllForType() and then filter out by state such as either "In Progress" or "Successful".  Please let me know.

Thanks.

[tperrySov]

Any luck on a filter?  Everything I tried returns 0 records.

[koushik_vmware]

Hello,

You can execute the query from your PostGress DB ( vRA DB) to get all the information.

Please see below link for reference.

http://open902.com/vra7-delete-stuck-in-progress-deployments/

Thanks,

[iiliev]

Here is a sample code showing how to enumerate all requests and print their number and state:

var all = Server.findAllForType("vCACCAFE:CatalogItemRequest");
for each (var request in all) {
  System.log("Request " + request.requestNumber + " is in state " + request.state.value());
}

By comparing state value, you can easily filter those which match a given criteria (eg. are in progress).