Data Backup and Recovery

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

philipb
1,996 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

donny_lang
1,970 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

donny_lang
1,971 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
1,829 Views

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

Public