Data Backup and Recovery Discussions

How to export to csv the Get-SMSchedule command you can run on Snapcenter?

philipb

A customer wants to know how to export to CSV the Get-SMSchedule command from SnapCenter

I am looking to export objects such as Scheduled start and end time, databases involved, and retention into columns. Not sure if there is an advanced guide on getting this info populated into columns since currently it is a mess populating that into a spreadsheet.

2 REPLIES 2

Re: How to export to csv the Get-SMSchedule command you can run on Snapcenter?

donny_lang

The most basic way would be something like this:

 

Get-SMSchedule | Select-Object <list of PowerShell properties that you want to include in your exported CSV> | Export-CSV C:\path\to\your\CSV\file

You can run "Get-SMSchedule | Get-Member" to get a list of all available properties (there are usually a large number of properties available that aren't displayed by default).  

 

Some light reading:

 

https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/select-object?view=powershell-6

https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/get-member?view=powershell-6

View solution in original post

Re: How to export to csv the Get-SMSchedule command you can run on Snapcenter?

philipb

I believe this is the answer that the customer has needed.  They will be testing shortly.  THanks!

Earn Rewards for Your Review!
GPI Review Banner
All Community Forums
Public