Skip to content

Instantly share code, notes, and snippets.

@lazywinadmin

lazywinadmin/ExportMVPAllcontrib.ps1

Created March 25, 2019 23:45
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save lazywinadmin/0d6ff188488ff4f409424c5b6943b06f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save lazywinadmin/0d6ff188488ff4f409424c5b6943b06f to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. lazywinadmin created this gist Mar 25, 2019.
    19 changes: 19 additions & 0 deletions ExportMVPAllcontrib.ps1
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,19 @@
    #https://lazywinadmin.com/2018/01/MVPModule-BackupMyEntries.html#backup-per-year
    # Connect to api
    $Key = '<Your Secret key>'
    Set-MVPConfiguration -SubscriptionKey $Key

    # Get All contributions
    $AllContrib = Get-MVPContribution -limit 1000

    # Retrieve important data and select the useful properties that
    # we can use for the next import
    $AllContrib|Select-Object -Property
    startdate,title,description,referenceurl,AnnualQuantitySecond,AnnualQuantity,AnnualReach,
    @{L='Visibility';E={$_.visibility.description}},
    @{L='ContributionType';E={$_.contributiontype.name}},
    @{L='ContributionTechnology';E={$_.contributiontechnology.name}} |

    # Export to CSV
    Export-Csv .\AllMyContributionsBackup_$(Get-Date -Format yyyyMMdd).csv -NoTypeInformation