rpotru
Enthusiast
Enthusiast

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

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.

0 Kudos
3 Replies
tperrySov
Enthusiast
Enthusiast

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

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,

0 Kudos
iiliev
VMware Employee
VMware Employee

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).

0 Kudos