Hi Community, This is for the workflow guys. I’m trying to implement something to automate a VM power on/off, the VM is VMware based (ESXi) and is an MA.I want my scenario to be something like this, when the VM is powered OFF :Check readiness of the VM. If the VM is powered off, then power it on. Execute my aux copy When job finished successfully, power off the VM.Some needed workflows required some inputs, that I struggle where I can find them, like the ones below :Any help or recommendation on how to implement this would be appreciated. Regards

VM Power On/Off status Automation

A

Userlevel 3

+7

Hi,

The vm power on/off activities are documented here:

https://documentation.commvault.com/11.24/essential/131495_predefined_activities_for_workflows.html

Is the check readiness a workflow or a standalone activity? from the inputs it looks like its expecting a list of commvault client ids. You can fetch these Ids from app_client table.

C

Userlevel 3

+12

Hi,

The vm power on/off activities are documented here:

https://documentation.commvault.com/11.24/essential/131495_predefined_activities_for_workflows.html

Is the check readiness a workflow or a standalone activity? from the inputs it looks like its expecting a list of commvault client ids. You can fetch these Ids from app_client table.

Hi Amey,

Thanks for your reply, how can I fetch these Ids from app_client table ? Actually, I only need to check one client, which is my MA.

Userlevel 5

+9

Sean Crifasi
Vaulter
98 replies
2 years ago
10 April 2022
Answer

@Commvault Engineer

- If you wanted to check this as a one time thing to confirm the id you can use the sql query below without the quotes.
-- “select * from app_client where name like ‘<name here without brackets’”
- The above would list all of the columns in the app_client table for the matching results.
- If you wanted to see only the client id you could do
-- “select id from app_client where name like ‘<name here without brackets’”

Alternatively, you could use restapi to pull the clientID and can likely have this logic added to the workflow in some manner if needed
https://documentation.commvault.com/11.24/essential/147267_rest_api_get_id_for_client.html

C

Userlevel 3

+12

@Commvault Engineer

- If you wanted to check this as a one time thing to confirm the id you can use the sql query below without the quotes.
-- “select * from app_client where name like ‘<name here without brackets’”
- The above would list all of the columns in the app_client table for the matching results.
- If you wanted to see only the client id you could do
-- “select id from app_client where name like ‘<name here without brackets’”

Alternatively, you could use restapi to pull the clientID and can likely have this logic added to the workflow in some manner if needed
https://documentation.commvault.com/11.24/essential/147267_rest_api_get_id_for_client.html

Thanks a lot Sean

C

Userlevel 3

+12

@Commvault Engineer

- If you wanted to check this as a one time thing to confirm the id you can use the sql query below without the quotes.
-- “select * from app_client where name like ‘<name here without brackets’”
- The above would list all of the columns in the app_client table for the matching results.
- If you wanted to see only the client id you could do
-- “select id from app_client where name like ‘<name here without brackets’”

Alternatively, you could use restapi to pull the clientID and can likely have this logic added to the workflow in some manner if needed
https://documentation.commvault.com/11.24/essential/147267_rest_api_get_id_for_client.html

I had another question, if possible, @Sean Crifasi

I want to add a VM as an MA, should the VM be added in a certain way ? In order for it to be controlled by the CommServ (Power ON/OFF, for example).

Should the VM be added as a simple client than install the MA package on it, or it has to be added to the commcell with a different way ?

Userlevel 7

+23

Nothing different needed. As far as the Commserve is concerned, it’s a server with the MA software installed.

Sharing the link below as some CLI service management advise:

C

Userlevel 3

+12

Nothing different needed. As far as the Commserve is concerned, it’s a server with the MA software installed.

Sharing the link below as some CLI service management advise:

Thanks, Mike, for the feedback.

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded