search cancel

Exporting all the virtual service names and protocols to Excel sheet used in DevTest Portal

book

Article ID: 215731

calendar_today

Updated On:

Products

Service Virtualization

Issue/Introduction

Is there a way to export all the virtual service names, port and protocols( http/s, MQ) to excel sheet used in Devtest portal or any report can do the same.

Environment

Release : 10.6 and up

Component : CA Service Virtualization

Cause

N/A

Resolution

As is the functionality of exporting VS names, ports and protocol information to an Excel is not available.

. Workaround to capture the information using an API and Customize it to read and write to Excel file:
DevTest API GET call http://VSEHostName:1505/api/Dcm/VSEs/VSEname will provide the information about all VS's. You can use the Swagger document to see the available API's at http://RegistryHost:1505/api/swagger/.

As a workaround you can customize the functionality by reading the above API call response and capture the information you are looking and save it to an Excel file.

. Workaround to capture VS information from .services file and customize it to read and write to Excel file:
In VSE server, DevTest_Home/vseDeploy/VSE-2013/.services file is used by VSE to know what services are registered and what state they are in. We don't recommend you modify this file. For example, my .services file has the below information.

UserControlService_Failover.mar=UP:FAILOVER,,,,true,UserControlService_Failover
WSDL_API_VS.mar=UP,1,100,,true,WSDL_API_VS
API_Test_WSDLFile.mar=UP,1,100,,true,API_Test_WSDLFile
API_Test_WSDLURL.mar=UP,1,100,,true,API_Test_WSDLURL

If you name your VS's with the functionality and Protocol may be reading this file and creating Excel might help.

NOTE: VSE_2013 refers to the name of the VSE and the Port used.

Additional Information

REST Invoke API V1:
Documentation: https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/devtest-solutions/10-6/using/using-the-apis/rest-invoke-api.html
Swagger UI: http://localhost:1505/api/swagger/
 
Virtual Service Invoke API V2,
Documentation: https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/devtest-solutions/10-6/using/using-the-apis/virtual-service-invoke-api.html
Swagger UI: http://localhost:1505/lisa-virtualize-invoke/api/v2/swagger-ui
 
Service Virtualization API v3:
https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/devtest-solutions/10-6/using/using-the-apis/service-virtualization-api-v3.html
Swagger UI: http://localhost:1505/lisa-virtualize-invoke/api/v3/swagger-ui
 
NOTE: "localhost" in the swagger UI is Registry hostname. Registry must be up and running before using the swagger ui