Solved

Query for VMs that have been discovered but not backed up


Userlevel 5
Badge +16

The APP_VM table seems to only include information for VM’s that have been backed up.

Where is non-backed up VM information held?

 

Thanks.

Chris.

icon

Best answer by Gseibak 17 May 2022, 16:33

View original

If you have a question or comment, please create a topic

15 replies

Userlevel 7
Badge +23

Hey @christopherlecky !  Have you checked out the GET vm API call?

I’m not sure if you’ll see discovered but NOT backed up, though it should be easy enough to find out.

https://api.commvault.com/#f51801e5-1d9d-4561-83de-37c487b4987c

Name

Description

status

Status of the VM.

Valid values are:

  • 0, All
  • 1, Protected
  • 2, Not Protected
  • 3, Pending
  • 4, Backed up with error
  • 5, Discovered
Userlevel 4
Badge +10

Hi @christopherlecky  - there is also a VM backup coverage report in the store that may be usefull

 

 https://cloud.commvault.com/webconsole/softwarestore/#!/135/661/23075

Userlevel 5
Badge +16

Hey @christopherlecky !  Have you checked out the GET vm API call?

I’m not sure if you’ll see discovered but NOT backed up, though it should be easy enough to find out.

https://api.commvault.com/#f51801e5-1d9d-4561-83de-37c487b4987c

Name

Description

status

Status of the VM.

Valid values are:

  • 0, All
  • 1, Protected
  • 2, Not Protected
  • 3, Pending
  • 4, Backed up with error
  • 5, Discovered

I have actually, the problem is that its alot more work because the api does not have the ability to filter by name.

I would either have to convert to xml and use an xmlpath query to get the vm or convert the output to a resultset. There is also the issue of pagination, because of the size of the return the response comes in several pages. So it becomes little mini project to parse out what I want 😥

Userlevel 5
Badge +16

Hi @christopherlecky  - there is also a VM backup coverage report in the store that may be usefull

 

 https://cloud.commvault.com/webconsole/softwarestore/#!/135/661/23075

Ill look into this. Maybe I just steal the dataset to find the mystery tables.

Userlevel 5
Badge +16

@Mike Struening , can you unmark this as solved.

I am browsing on a phone and clicked it by mistake.

Userlevel 7
Badge +23

Done!

Userlevel 5
Badge +16

😂

 

Maybe I should just log off for the day.

@Mike Struening , please unmark that for me.

This is the last time today, I promise.

Userlevel 7
Badge +23

HAHAHA!  I saw that and was about to fix it for you 🤣

Userlevel 5
Badge +16

Im going to take my time clicking from now on 😂😭

Userlevel 5
Badge +16

I give up. Just leave it like that.

Userlevel 7
Badge +23

Good candidate for my favorite thread of all time!

If you get a better answer and reply here, I’ll move the answer 🤣

Userlevel 5
Badge +16

Update:

I pulled the dataset and I am deconstructing the query and I know what I need is in here somewhere…. that said I’m going to do some complaining aimed at the devs.

 

 

Would it hurt to add some comments to your queries?

 

That is all.

 

Thanks. Chris. 

 

 

edit: Just to be clear, you guys do great work but comments people! comments!

Userlevel 7
Badge +23

@christopherlecky , I can happily pass along your feedback as an MR.  You want to give me specifics to share with them?

Userlevel 5
Badge +16

No need, im sure some of them are reading this and my guess is that is an issue with every dataset, I just want them to know that customers have to read them. So more comments = less tickets and complaining.

Userlevel 7
Badge +23

All good, then.  Let me know if there’s anything else I can do!