SPJeff - Jeff Jones
289 FOLLOWERS
This blog is all about SharePoint, Office 365, Azure, and Front end JS geek.
SPJeff - Jeff Jones
3y ago
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 ..read more
SPJeff - Jeff Jones
3y ago
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 ..read more
SPJeff - Jeff Jones
3y ago
Wanted to demo Azure Runbook with daily PowerShell PS1 that send SharePoint storage report email with HTML table and CSV attachment. Features include:
Hosted on Azure Platform-As-A-Service (PAAS)
Read source data SharePoint Online (SAAS)
SMTP for routing email with Exchange online
Credential storage in Azure Automation secure string
Logging with full debug
Local execution with Visual Studio code to debug
Demo covers the creation of local PowerShell PS1 and execute to confirm functionality. Script reads Tenant Site Collection from SharePoint Online leveraging Client App ID a ..read more
SPJeff - Jeff Jones
3y ago
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/questi ..read more
SPJeff - Jeff Jones
3y ago
Wanted to share brief demo of the user experience in web browser and SharePoint Designer after Microsoft deprecates the Workflow 2010 feature. SharePoint Designer 2013 continues to display the workflow menu and definition. However, during publish we see the error below. Web browser view displays a yellow toolbar with link to learn more about the deprecated removed feature. Tenant used for this video is set to “first release” for early preview and in that case is showing the Workflow 2010 feature removed sooner than other tenants. Sharing th ..read more
SPJeff - Jeff Jones
3y ago
Wanted to record a quick demo for how to switch from the current established “SharepointPnPPowerShellOnline” module into new “PNP.PowerShell” module based on .Net Core. Shout out to @ToddKlindt for the great blog post. Cmdlets and references below. Cheers
Video
Source Code
Uninstall-Module SharePointPnPPowerShellOnline –AllVersions
Install-Module PnP.PowerShell –AllowPrerelease
Register-PnPManagementShellAccess
References
https://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=881
https://docs.microsoft.com/en-us/powershell/sharepoint/sharepoint-pnp/sharepoi ..read more
SPJeff - Jeff Jones
3y ago
Quick demo for how to customize the Central Admin GUI default Sync database name (prefilled with GUID) to custom value more readable and admin friendly.
Simply press F12, select the text field, and remove “disabled=disabled” from the <INPUT> HTML element. Now able to enter any value and click “Create” UPS.
Cheers
Video
Screenshot ..read more
SPJeff - Jeff Jones
3y ago
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
What’s in that patch – Dev 2020.PDF ..read more
SPJeff - Jeff Jones
3y ago
Loads all Microsoft 365 cloud PowerShell modules in a single window. No more wasted time jumping between download pages and locating various Import-Module from each product team. Collected all here centrally to provide M365 admins with a single PowerShell PS1 to install and import every command they might need. Enables cloud admin productivity to quickly access every command.
Cheers!
Video
Screenshot GitHub Repo
https://github.com/spjeff/m365ultimate
References
https://docs.microsoft.com/en-us/microsoft-365/enterprise/connect-to-all-microsoft-365-services-in-a ..read more
SPJeff - Jeff Jones
3y ago
Brief demo video to show how “OnCheck()” formula can be used to group Toggle controls. Business goal is to check only one at a time. When clicking to Check Toggle ON all others controls need to set OFF. We can accomplish this with “OnCheck()” formula to disable all peers. Video demo shows the construction of parameters for Patch() function with JSON values to toggle controls OFF and “Refresh()” formula to update display. Cheers.
Code
Toggle1 / OnCheck = Patch(Test,ThisItem,{Toggle2:false,Toggle3:false});Reset(DataCardValue15);Reset(Da ..read more