In previous post http://rachmadona.net/how-to-get-list-of-protected-vm-in-srm-part-1/ we discussed how to export the list of protected VM on SRM. Now, we are going to have further detail report to get the list of such against protection group detail.
Post you get the VM name detail along with it’s vmid (see previous post), this time you have to run following command to query the protection group detail as well as vmid.
select vmid, parentgroupmoid from pdr_protectedvm;
By executing above command you will get below list. Copy all and paste into excel for us to do VLOOKUP.
To derive the vmid value only you have to use “Text to column” for separating the cell as figured above. So, you will have vmid column with “vm-xxxx” format and parentgroumoid. Do the same thing for the exported result for previous post therefore you can do VLOOKUP.
The next step is to find out the protection group details by executing below command.
select name,mo_id from pdr_protectiongroup;
Do the same thing so you will get vm-protectiongroup-xxxx only along with it’s protection group detail. Once done combine all of them into single excel file and you have finished the task.
So, by the end of this post, you will have list of VM which protected by SRM along with their protection group name.