Skip to main content
commvault.com commvault.com
Solved

VM Power On/Off status Automation

C
Forum|alt.badge.img+12

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 :

  1. Check readiness of the VM.
  2. If the VM is powered off, then power it on.
  3. Execute my aux copy
  4. 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

Best answer by Sean Crifasi

@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

View original
Did this answer your question?
If you have a question or comment, please create a topic

7 replies

A
Vaulter
Forum|alt.badge.img+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
Forum|alt.badge.img+12
Amey Karandikar wrote:

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.

Sean Crifasi
Vaulter
Forum|alt.badge.img+9
  • Sean CrifasiVaulter
  • Vaulter
  • 98 replies
  • Answer
  • April 10, 2022

@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

Mike Struening
C
2 people like this
  • Mike Struening
    Mike Struening
  • C
    Commvault Engineer
C
Forum|alt.badge.img+12
Sean Crifasi wrote:

@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
Forum|alt.badge.img+12
Sean Crifasi wrote:

@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 ?

Mike Struening
Vaulter
Forum|alt.badge.img+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:

 

https://www.linkedin.com/in/michael-struening
C
1 person likes this
  • C
    Commvault Engineer
C
Forum|alt.badge.img+12
Mike Struening wrote:

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.

Mike Struening
1 person likes this
  • Mike Struening
    Mike Struening

Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings