Data Protection

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

philipb
3,280 Views

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.

1 ACCEPTED SOLUTION
philipb has accepted the solution

donny_lang
3,254 Views

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

2 REPLIES 2
philipb has accepted the solution

donny_lang
3,255 Views

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

philipb
3,113 Views

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

Public