Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

Uncategorized

What’s in that patch? Jan 2021

NOTE – PDF format updated to include both SharePoint 2013, 2016, and 2019 notes. Ever wondered what fixes are inside of a given CU?   Please see attached PDF with full detail. I wanted a new format for easy reading.   Show management and make the business case for why downtime should be taken to apply CUs.  Also posted at https://sharepointupdates.com/ If you found this helpful, please leave a comment.   

shades_smile_thumb_thumb_thumb_thumb[2]

Download

What’s in that patch – Jan 2021.PDF

VIDEO – Microsoft Teams Tenant Wide CSV Report

Wanted to share brief demo running PowerShell MS Teams report to CSV. Output will inventory the MS Teams available on a given tenant with column details below. Great reporting tool to meet training, compliance, and security goals. Cheers.

  • MS Team Name
  • GUID
  • Creation Date (new)
  • Owners
  • Access Type
  • User Count
  • SharePoint Site
  • Guests

Video

Screenshots

Source Code

References

VIDEO PowerShell – Convert MS Office (DOC/XLS/etc) to PDF and Merge PDF

Wanted to record live coding video for how to use PowerShell to convert any Microsoft Office source file (DOCX / XLSX / PPTX / etc.) into PDF and then merge all PDF into a single combined PDF.

Features include:

  • Convert DOCX, DOC, DOT to PDF
  • Convert XLSX, XLS, CSV to PDF
  • Convert PPTX, PPT to PDF
  • Convert PUB to PDF
  • Convert VSD, VSS to PDF
  • Merge many PDF into single multi-page PDF
  • Dependency on local MS Office “Interop” DLL for conversion
  • Dependency on “itextsharp.dll” for multi-page PDF merge

Cheers.

Source Code

Video

Screenshots

References

VIDEO – Export SPO all UPS to flat CSV with PowerShell

Video demo of [Export-SPO-All-UPS] PowerShell to export all SharePoint Online (SPO) user profile service (UPS) values to flat CSV file. Cheers

Video

Source Code

  • https://github.com/spjeff/office365/blob/master/office365-export-profiles/Export-SPO-All-UPS.ps1

References

  • https://www.microsoft.com/en-us/download/confirmation.aspx?id=42038
  • https://gist.github.com/asadrefai/ecfb32db81acaa80282d
  • https://community.idera.com/database-tools/powershell/ask_the_experts/f/learn_powershell_from_don_jones-24/2824/exporting-key-value-pair-using-export-csv-cmdlet
  • https://sharepoint.stackexchange.com/questions/108664/powershell-script-for-user-profile-properties-in-sharepoint-online-2013

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲