VSA V2 job details SQL query

Question

Hi there!I am trying to build a SQL query to get a list of ‘VM Job ID’, ‘VM Name’ and ‘Status’ based on subclient Job ID (VMware VSA V2). Any idea how to accomplish that? Which tables should be used to link subclient Job ID with VM Job IDs?Any help would be appreciated.Thanks!

Stuart Painter · Accepted Answer

Hi @euMikeAs @dudementions, creating a dataset and using reports will allow you present this data in report form, I’ll add another in here with a different approach which provides raw data as SQL query results.We have Commcell Views, which are pre-constructed SQL queries allowing you to pull specific details directly from the Commserve Database without needing to piece together the tables and necessary joins.CommCellVMBackupInfo should give you all the details you’re looking for:https://documentation.commvault.com/commvault/v11/article?p=127286.htmThanks,Stuart

dude · Answer

My understanding is that the way to go here is with the Reports building your own DataSet.

https://documentation.commvault.com/commvault/v11/article?p=44569.htm

Once you start poking around you will see there you can navigate through the tables and views within the CommServe Database and explore what can be extracted from the VM table, Job History etc.

Take a look at Creating Data Cube Data Sets and on how to associated a report Input in a DataSe

So with that you will have to do a little bit of digging to figure out if you can extract that from the parent job which in your case is 143350, of if that info can be extracted from the VM table.

That is where I`d start. There is probably other ways too. Lets see what other peoples experiences are.

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded