VIDEO – Microsoft Teams Tenant Wide CSV Report
SPJeff - Jeff Jones
by spjeff
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
Visit website
VIDEO PowerShell – Convert MS Office (DOC/XLS/etc) to PDF and Merge PDF
SPJeff - Jeff Jones
by spjeff
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
Visit website
VIDEO – Azure Automation Runbook to manage SharePoint Online SPO
SPJeff - Jeff Jones
by spjeff
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
Visit website
VIDEO – Export SPO all UPS to flat CSV with PowerShell
SPJeff - Jeff Jones
by spjeff
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
Visit website
VIDEO – Workflow 2010 Deprecated User Experience (UX)
SPJeff - Jeff Jones
by spjeff
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
Visit website
How to switch to PNP.PowerShell (PS7) from SharepointPnPPowerShellOnline (PS5.1)
SPJeff - Jeff Jones
by spjeff
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
Visit website
FIXED – Create User Profile Service – Sync database not editable
SPJeff - Jeff Jones
by spjeff
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
Visit website
What’s in that patch? Dec 2020
SPJeff - Jeff Jones
by spjeff
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
Visit website
M365 Ultimate PowerShell
SPJeff - Jeff Jones
by spjeff
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
Visit website
VIDEO – PowerApps Grouped Toggle (select only one)
SPJeff - Jeff Jones
by spjeff
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
Visit website

Follow SPJeff - Jeff Jones on FeedSpot

Continue with Google
Continue with Apple
OR