• February 11, 2021

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.   

Download

• February 11, 2021
• No Comments
• Uncategorized

• February 4, 2021

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

• https://github.com/spjeff/office365/blob/master/office365-msteams-guest-report/O365-MSTeams-Guest-Report.ps1

References

• https://techcommunity.microsoft.com/t5/microsoft-teams/microsoft-teams-tenant-wide-csv-report/m-p/151875
• https://docs.microsoft.com/en-us/powershell/exchange/connect-to-exchange-online-powershell?view=exchange-ps

• February 4, 2021
• No Comments
• Uncategorized

• January 28, 2021

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

• https://github.com/spjeff/PowerShellPDF

Video

Screenshots

References

• https://stuartsplace.com/computing/programming/powershell/merging-files-with-powershell
• https://github.com/escottj/Doc2PDF/blob/master/Doc2PDF.ps1
• https://docs.microsoft.com/en-us/visualstudio/vsto/office-primary-interop-assemblies?view=vs-2019

• January 28, 2021
• No Comments
• Uncategorized

• January 17, 2021

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

• January 17, 2021
• No Comments
• Uncategorized