Sample Exchange

 View Only

vRealize Automation Reporting - vRA8 deployment requests and statuses 

Jul 27, 2023 12:18 AM

Use case: identify hot spots in the environment and manage deployment lifecycle; write deployments and all their action requests with statuses to a csv formatted file. This report is generated from an ABX action. Field names are generated dynamically. Sample report, ABX action and instruction are attached. This is an initial version. Data is written to standout.

Future improvements:
* store data to a file
* remove blank lines in data file
* map additional IDs to names
* convert it to a workflow so it can be scheduled
* increase the number of deployments per report; it is hard coded to 2000
* add date range as filter

version 1: initial release
version 1.1: update description text of this posting and test with vRA cloud

Sample report:
(deployment name and blueprint name are added to final report)

id name inputs status details project actionId createdAt updatedAt totalTasks requestedBy resourceIds deploymentId completedTasks
fbce5ca7-2029-4621-91b7-66542d509802 Add Disk disk2|false|1|false|true SUCCESSFUL test_mak Cloud.vSphere.Machine.Add.Disk 2023-01-03T22:45:22.356780Z 2023-01-03T22:46:26.415682Z 6 administrator aaea9a01-e563-342b-b02e-85a1f065434f,60f0dbed-a3c5-4e28-8ff0-47f1e8582a05 64e1a7bd-f156-4ce4-ab0b-947b4a4692f8 6
b5271bc6-b1fa-4ba4-a42f-07f98280ea54 Add Disk disk1|false|1|false|true SUCCESSFUL test_mak Cloud.vSphere.Machine.Add.Disk 2023-01-03T22:01:43.897203Z 2023-01-03T22:02:40.721520Z 6 administrator 622cbc63-6674-48e0-8649-7fb9350051d7,aaea9a01-e563-342b-b02e-85a1f065434f 64e1a7bd-f156-4ce4-ab0b-947b4a4692f8 6
6bda538b-e137-4d78-80bb-5cc2522b91cd Onboard SUCCESSFUL test_mak 2022-12-23T23:09:57.559316Z 2022-12-23T23:09:57.909851Z 0 administrator aaea9a01-e563-342b-b02e-85a1f065434f 64e1a7bd-f156-4ce4-ab0b-947b4a4692f8 0
a3bbe332-cfbe-4060-ba67-fbf8adad69cf Create FAILED Extensibility triggered task failed. Event ID: de727e26-5f36-344e-b138-1fd07bf9cf12. Failure: Extensibility error received for topic compute.provision.pre, eventId = 'de727e26-5f36-344e-b138-1fd07bf9cf12': [10040] SubscriberID: vro-gateway-DXolUjotHm3I2PCF, RunnableID: 3852f5be-1103-4f08-8746-75458fdd914f and SubscriptionID: sub_1671482754142 failed with the following error: Workflow run [c46c5f1f-6b1a-4361-945f-146bf1b89c66] completed with error [TypeError: Cannot read property "length" from null (Workflow:rest call test (2) / Get hostSelectionIds (item5)#4)] test_mak 2022-12-21T19:37:46.558753Z 2022-12-21T19:38:35.468600Z 5 administrator e9983b6d-8b88-485a-92e1-2090d433bb6d 5ee240ce-c492-46d3-ace1-5e667b585ac6 4
45323e7c-c395-46be-8468-5f23154fe70e Delete FAILED com.vmware.xenon.common.ServiceHost$ServiceNotFoundException: Service not found: http://10.244.0.238:8282/resources/endpoints/d3fd0145-925a-41cd-81e9-7fe78becbac5 test_mak Deployment.Delete 2023-07-25T16:24:06.033567Z 2023-07-25T16:24:26.591862Z 7 administrator b34423b8-d8fa-3607-ab99-a8fbcfb30bd7,aa5a9ada-737c-368c-8e2f-f6801dde199e,f373d923-27dc-39eb-9096-2dc6ec68e7e1,972e7def-4e52-4524-b8e9-d1834733254b e331f4b3-e8dd-4fdb-9a53-e0e9e31b8d55 6
cc9e001c-9d81-46c7-aaac-dde260c1d9ba Add Disk disk_add-after|false|1|false|true FAILED No matching placement test_mak Cloud.vSphere.Machine.Add.Disk 2022-12-21T00:56:05.729994Z 2022-12-21T00:56:26.896562Z 6 administrator b34423b8-d8fa-3607-ab99-a8fbcfb30bd7,60da9278-256a-4741-b77f-0d1d2cf43cf3 e331f4b3-e8dd-4fdb-9a53-e0e9e31b8d55 2
5f548440-efd3-46cd-bfdc-3a625ae8a627 Onboard SUCCESSFUL test_mak 2022-12-21T00:36:54.460797Z 2022-12-21T00:36:54.917290Z 0 administrator b34423b8-d8fa-3607-ab99-a8fbcfb30bd7 e331f4b3-e8dd-4fdb-9a53-e0e9e31b8d55 0
                         

#Hotspot
#VMwareAriaAutomation
#vRealizeAutomationCLoud
#report
#VirtualMachine
#vRA8.4
#VMProvisioning
#status
#Reports
#reporting
#deployment
#AriaAutomation
#Python
#vRealizeAutomation
#Apache2.0
#lifecyle
#Troubleshooting

Statistics
0 Favorited
7 Views
1 Files
0 Shares
1 Downloads
Attachment(s)
zip file
vRA8-deployment-report-master.zip   14 KB   1 version
Uploaded - Apr 09, 2024

Tags and Keywords

Comments

Nov 20, 2023 10:25 AM

Greetings Stephen,
Regarding to generate output in 'csv' file in "Action Runs" in 'log' tab, there is nothing appeared; just output in log section.
Could you please till me from where to get this generated file? Can we specify custom date to export result with in?
Does it stored in specific directory?

Related Entries and Links

No Related Resource entered.