An alternative can be run from the backup proxy server. dsmc restore vm bodev -pick -inactive
Jim Schneider Essendant -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Schofield, Neil (Storage & Middleware, Backup & Restore) Sent: Tuesday, June 27, 2017 12:33 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Inactive active filesystem for vm in script Classification: Public Robert I'm not sure this is the best answer to your question, but in the absence of any other replies I thought it might at least prompt somebody to come up with something better. I'm assuming here that your hypervisor is vSphere and not Hyper-V? In which case empirical evidence from my systems suggests that for every backup of a snapshot of the VM called bodev, I get one bodev.ovf backup object. I would normally shy away from running Selects against the Backups table, so use the following at your own risk. However to determine how many snapshots you've got stored for the VM called bodev, maybe try something like the following? SELECT COUNT(*) FROM BACKUPS WHERE FILESPACE_NAME='\VMFULL-bodev' AND LL_NAME LIKE '%.ovf' It looks like all versions of bodev.ovf will show as Active versions, but perhaps you can just assume the number of inactive backups is 1 less than the total? Regards Neil Schofield IBM Spectrum Protect SME Backup & Recovery | Storage & Middleware | Central Infrastructure Services | Infrastructure & Service Delivery | Group IT LLOYDS BANKING GROUP ________________________________ Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. Telephone: 0345 603 1637 Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority. Cheltenham & Gloucester plc is authorised and regulated by the Financial Conduct Authority. Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings is a division of Lloyds Bank plc. HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC218813. This e-mail (including any attachments) is private and confidential and may contain privileged material. If you have received this e-mail in error, please notify the sender and delete it (including any attachments) immediately. You must not copy, distribute, disclose or use any of the information in it or any attachments. Telephone calls may be monitored or recorded. ********************************************************************** Information contained in this e-mail message and in any attachments thereto is confidential. If you are not the intended recipient, please destroy this message, delete any copies held on your systems, notify the sender immediately, and refrain from using or disclosing all or any part of its content to any other person.
