Robert, As you can see there are more that a few way to get the info I will add a couple more for you tool box. You can create a macro or a script to do the same thing. You would have to translate the VM verbage into TSM and use select statement like Neil did. The translation would be as such:
vm bodev -ina = node_name='BODEV' state='INACTIVE_VERSION' The select statement would look like this select node_name as node, filespace_name as drive, hl_name as directory, ll_name as filename, state, deactivate_date, class_name as mgmtclass from backups where node_name='BODEV' and type='FILE' and state='INACTIVE_VERSION' the output would look like this NODE: BODEV DRIVE: \\bodev\c$ DIRECTORY: \USERS\BODEV\DOWNLOADS\DOCUMENTS\ FILENAME: PERSONALHEALTHRECORD_5241501C-A51F-4D05-8E9F-56A2A90B30B7.PDF STATE: INACTIVE_VERSION DEACTIVATE_DATE: MGMTCLASS: DEFAULT NODE: BODEV DRIVE: \\bodev\n$ DIRECTORY: \FILEHISTORY\BOB\FASTER\DATA\C\USERS\BOB\VIDEOS\ FILENAME: BICEPBARBELLS (2016_04_18 03_30_08 UTC).MP4 STATE: INACTIVE_VERSION DEACTIVATE_DATE: MGMTCLASS: DEFAULT You would then be able to save that select command to a script with the define script command within TSM or if you saved it to a file you could run it as a macro or use the file to create the script. You could even use variables in place of hard coding specific names for the Node and state if you wanted to. As I stated, there are numerous ways to get the info you are looking for. This is probably more information than you are looking for but it gives you an idea of what you could do if you wanted to. Best Regards, _________________________________________________________ Ronald C. Delaware Senior Consultant IBM Corporation | System Lab Services 925-476-5315 (Office) 925-457-9221 (cell phone) mailto:ron.delaw...@us.ibm.com From: "Schneider, Jim" <jschnei...@essendant.com> To: ADSM-L@VM.MARIST.EDU Date: 06/27/2017 11:01 AM Subject: Re: [ADSM-L] Inactive active filesystem for vm in script Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> 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.