Tag - admin

SharePoint ToolBox 119 Microsoft Script Lab and PowerShell Scripts

19. April 2017
Michael Greth
Allgemein, Reviews Michael Greth

Script Lab, a Microsoft Garage Project

Script Lab is a tool for anyone who wants to learn about writing add-ins for Excel, Word, or PowerPoint. The focus is the Office JavaScript API, which is the technology you need for building Office add-ins that run across platforms. Maybe you’re an experienced Office developer and you want to quickly prototype a feature for your add-in. Or maybe you’ve never tried writing code for Office and you just want to play with a sample and tweak it to learn more. Either way, Script Lab is for you.

Script Lab has three main features:

  • Code in a pane beside your spreadsheet. IntelliSense shows suggestions while you type so you can easily discover and use the Office JavaScript objects and methods. And if you don’t want to start from scratch there are plenty of samples preinstalled with Script Lab. Your snippets can use any TypeScript features like the magical async/await and conveniences like arrow functions and template strings. But it’s not only script: your snippets can also use HTML, CSS, and references to external libraries and data on the web. Script Lab uses the Monaco editor, the same tech that powers VS Code, so it’s beautiful and lightweight.
  • Run the code in another pane beside the editor. Execution can include logic, API calls to Office, UI in the pane, and even output to a console. Every time you make a code change you can refresh the editor and run the new version in seconds.
  • Share your snippets through GitHub. If you create a snippet you’d like to share, you can use Script Lab to save it. Then send the link to someone else to try it and tweak it on their computer. The Import feature lets you load other people’s snippets. We think sharing will be especially useful for asking and answering questions about add-ins on Stack Overflow (http://stackoverflow.com/questions/tagged/office-js).

You can install Script Lab right now for free from the Office Store. It works for Excel, Word, and PowerPoint on Office 2013 and later, Office Online, and Office for Mac.

The source code is open to the community at https://github.com/OfficeDev/script-lab. We welcome your contributions to the tool and to our snippets repo. We’re excited to keep building Script Lab with your help!

Reporting Office 365 Admin Role Group Members

This script produces a report of the membership of Office 365 admin role groups. The report is output to CSV file.

This script relies on the AzureAD PowerShell module, which you can install from the PowerShell Gallery.

1. Download the script from the link above.
2. Run the script using the usage examples below. You will be prompted to authenticate to Azure AD if you are not already connected.

Parameters

  • ReportFile – You can provide a custom output file name. The file name you specify will be modified with the current date, for example MyReportFileName.csv will become MyReportFileName-ddMMyyyy.csv. If a file of the same name exists, a unique character string will also be appended to the file name.

SharePoint ToolBox 102

2. September 2015
Michael Greth
Allgemein, Reviews Michael Greth, ToolBox

Taxonomy Toolkit 2.1.0

For use with Microsoft SharePoint, Taxonomy Toolkit provides PowerShell cmdlets and a C# API for importing, exporting, and bulk editing of taxonomy objects from the Managed Metadata Service. The data is stored using TAXML, an XML-based file format. All operations are performed using the SharePoint Client OM. Taxonomy Toolkit does not require administrator permissions and is compatible with both on-prem and Office 365 cloud-hosted sites.

Taxonomy Toolkit was created by a Microsoft employee as part of the Garage spirit of developing interesting project ideas on the side without official sponsorship. The tool gained popularity internally, and after many requests to share it with customers, the author eventually obtained permission to publish the code under an open source license.

SharePoint Feature Administration and Clean Up Tool

The Feature Admin Tool finds faulty FeatureDefinitions and cleanly uninstalls them. It finds feature remainders in sites, SiteCollections, WebApps and in the Farm, caused e.g. by forcefully uninstalled Features from a farm without deactivating them before. These faulty features, never visible, cause errors.

SPSWakeUp – Wake Up Your SharePoint !

SPSWakeUp is a PowerShell script tool to warm up all site collection in your SharePoint environment. It’s compatible with all supported versions for SharePoint (2007, 2010 and 2013).