Re: Get complete list of all tapes</h1> <article> <h1>Re: Get complete list of all tapes</h1> <p>bink — Fri, 01 Oct 2010 14:31:54 GMT</p> <p>I think you will need to query the DB to get that information. You can only query the views provided but I would have thought that information would be available. I am unable to check at the moment but I would try querying the following views to see if you can get what you need.</p> <p><strong>vw_DPM_Media</strong></p> <p><strong>vw_DPM_TapeStat</strong></p> <p>Hope that helps.</p> <p>David</p> </article> <article> <h1>Re: Use powershell to get job information</h1> <p>bink — Fri, 01 Oct 2010 14:10:52 GMT</p> <p>I don't think that information is available through PowerShell but you could query from the DPM database. Although querying the DB itself is not supported, you can run queries against the views.</p> <p>If you run <strong>SELECT * FROM [DPMDB].[dbo].[vw_DPM_Jobs] </strong>you will get a list returned with all jobs that have run with their Status and Error Code if relevant as well as Creation Time, Data Transferred and Retry Attempts.</p> <p>Hope it helps.</p> <p>David</p> </article> <article> <h1>Re: Use powershell to get job information</h1> <p>bink — Wed, 29 Sep 2010 09:57:42 GMT</p> <html xmlns=""> <p>Thanks for your reply. What I would like is see all passed jobs, jobtypes (inceremental, Expressfull), completed (yes/no), amount data transfered.<br />You would expect as with Exchange that powershell can get more info than in the GUI, the info is in there but the GUI does not support save as xls or pdf in the job monitoring...</p> </article> <article> <h1>Re: Use powershell to get job information</h1> <p>bink — Wed, 29 Sep 2010 09:29:04 GMT</p> <p>Hello,</p> <p>The closest you can get to this is the "Get-PolicySchedule" cmdlet. This will return all the jobs scheduled for a protection group. You will need to run to separate queries however if you want both long term and short term schedules.</p> <p>Example: Get-PolicySchedule -ProtectionGroup $pg -ShortTerm (or -LongTerm)</p> <p>Hope that helps,</p> <p>David</p> </article> <article> <h1>Get complete list of all tapes</h1> <p>bink — Wed, 29 Sep 2010 08:25:08 GMT</p> <html xmlns=""> <p>Hi, I would like to get a complete list of all tapes using Powershell, but I can only get a list of the tapes currently in the library, but I would also like all offsite tapes with expire dates. Any tips?</p> </article> <article> <h1>Use powershell to get job information</h1> <p>bink — Wed, 29 Sep 2010 08:23:18 GMT</p> <html xmlns=""> <p>Hi, I would like to use powershell to get job information, like the joblist you can get in the GUI. I can not see a way how to do this in DPM2010 Powershell. Am I missing something?</p> </article> </main></body></html>