PowerShell Archive

Welcome to the PowerShell Archive! Here, you’ll find a treasure trove of knowledge, tips, and insights about one of the most powerful and versatile scripting languages for Windows systems. Whether you’re a seasoned IT professional, a budding scripter, or simply curious about the capabilities of PowerShell, this archive is your go-to resource for all things PowerShell. From beginner-friendly tutorials to advanced techniques, we’ve got you covered. Join us as we delve into the world of PowerShell, exploring its features, syntax, and real-world use cases. Get ready to unlock the full potential of PowerShell and elevate your scripting game to the next level. Let’s dive in and explore the power of PowerShell together!

Archive by Month

Archive of PowerShell Posts


Archive of Azure Posts

  • How to configure Azure App registration for MS Graph
    ✔️ App registrations for MS Graph: Unleash powerful capabilities through granted requests. ✔️ What is an app registration? Learn its purpose, usage, and boundaries. ✔️ Security considerations for app registrations: Explore key factors. ✔️ How to create an app registration with the right permissions for MS Graph: A step-by-step guide.

PowerShell Archive of SharePoint Online

  • How to Get SharePoint Files with MSGraph with PowerShell
    Learn how to efficiently retrieve SharePoint files using the MSGraph module in PowerShell. This comprehensive guide outlines the prerequisites, provides a demo setup, and offers a recursive PowerShell script to get all SharePoint files, including folders. Discover how to manage metadata, obtain DriveItem IDs, download specific files, and assess storage in your SharePoint libraries. With step-by-step instructions and code snippets, you can seamlessly integrate MSGraph to streamline your SharePoint file management tasks.
  • How To Download a SharePoint Library Using Graph API (PowerShell)
    SharePoint is a powerful platform for managing and collaborating on documents, but downloading files from SharePoint libraries can be a tricky, especially when it comes to deal with large files or a large amount of documents. In this post, I want to show you a straightforward guide to download a SharePoint Library using PowerShell with Microsoft’s Graph API for SharePoint administrators, develops or system integrators. This tutorial will help you streamline your automation in terms of downloading SharePoint libraries. At the end, you’ll find a ready to use PowerShell script, which you can use to download the SharePoint Library using Graph API.
  • How to download files from SharePoint using Graph API (PowerShell)
    Downloading files from SharePoint is a common use case, when we are integrating 3rd party systems with SharePoint. In my previous articles, I have been explaining how you can upload files to SharePoint using PNP module. In this article, I want to show you how you can achieve download files from SharePoint using Graph API.
  • How to upload files to SharePoint using Graph API (PowerShell)
    Uploading files to SharePoint is a common use case, when we are integrating 3rd party systems with SharePoint. In my previous articles, I have been explaining how you … Read more
  • Create SharePoint list items using Graph API (PowerShell)
    SharePoint List items do represent a row of structured data in our SharePoint. Besides creating them manually, you have the opportunity to create them programmatically. In this article I want to show you how you can create SharePoint list items using Graph API with PowerShell.
  • How to get SharePoint List Items with Graph API (PowerShell)
    In this article I am explaining how you can get SharePoint List items with Graph API. I took PowerShell to get the items, but you could also get all the items with a web request in the tool of your choice e.g. Postman.
  • How to get all lists and libraries in SharePoint Online
    Learn how to get all lists and libraries with two PowerShell scripts to understand what is going on in your SharePoint tenant.
  • Upload documents to SharePoint (PNP.PowerShell)
    Learn how to upload documents to SharePoint with PowerShell. Integrating different systems to SharePoint can be achieved easily with this.
  • SharePoint get all sites and subsites PowerShell script
    SharePoint sites are created very fast. With a few clicks, admins and users can create dozens of sites and subsites. Since it is so easy to create sites, we as admins should have an overview, what is going on at our SharePoint environment. I wrote scripts for this purpose to get all sites and subsites of your SharePoint, so you can trim your SharePoint to your business needs. You will find a script for SharePoint Server and SharePoint Online.
  • SharePoint Downloader | Comfortable file download in 2 steps
    In this article, you’ll learn how to download SharePoint files in the GUI and with PowerShell. I also provide my tool, the “SharePoint Downloader” – a ready-to-run script, which you can use to download your SharePoint files.
  • 3 of the most important SharePoint PowerShell Modules and Snappins
    There are various ways to access SharePoint Online and SharePoint Server. Check out and learn what the main differences are. When to use which module / snapping, and which are the pros and cons from my point of view. You will also see, what you can change with each SharePoint PowerShell Module.
  • Change SharePoint site collection logo faster with PowerShell
    The corporate design covers besides colors and fonts a logo, which is located in the upper left corner of the SharePoint site collection. If you want to automate … Read more
  • How to connect to SharePoint Online with SharePointOnlinePowerShell
    Besides the possibility to manage your SharePoint Online in the SharePoint admin center, you have the option to do it with PowerShell. For this tasks Microsoft has published … Read more
  • How I easily add Webparts to SharePoint Pages by PowerShell
    A page consists of multiple webparts. With the webparts you can refer to other lists, libraries and apps within a page. You can add webparts SharePoint Pages manually … Read more
  • Access SharePoint via Graph API in PowerShell
    Learn how to access SharePoint with Graph API with ready to use PowerShell Scripts
  • Add-PNPField: Add SharePoint columns with PowerShell
    Cheatsheet: Learn how to add SharePoint Columns with PNP PowerShell to automate the creation of your Microsoft lists and libraries. Ensure that your intranet follows your archtecture by automation.
  • Add items to SharePoint Online lists with Powershell
    When you want to integrate 3rd party systems to SharePoint, you might need to add items to SharePoint Online lists with PowerShell. In this article, you learn, how to do it for each data type.
  • How to use Word and Excel templates in SharePoint
    Enhance the efficency of your intranet by using word and excel templates for your documents.
  • Remove SharePoint Sites fastly
    Howdy guys, sometimes we create ton of sites just for testing. A clean tenant is a must for an efficient management. Have you ever removed sites by hand? … Read more
  • Term label propagation in SharePoint Online
    Rome was not build on a day so isn‘t our taxonomy. Business requirements change frequently, so we have to adapt our systems to support these changes. This article … Read more
  • Dealing with existing SharePoint connections
    We all can Imagine the scenario. You create sites in sharepoint and now you want to edit multiple sites afterwards with PowerShell. In order to be safe, we … Read more
  • Filtering for SharePoint items with CAML Queries
    Most of our times, we just need just a bunch of items, to export them or to change their values. This post should help you to show, how … Read more
  • Determine internal name of SharePoint Columns with GUI
    You have to determine the internal name of SharePoint columns, when you want to get the values of the items programatically or develop some apps with PowerApps. If … Read more
  • Getting FieldValues of Items
    Getting all values of all items If you want to retrieve all fieldvalues of an item, you can use following steps. I am getting the opportunities of the … Read more
  • PNP.PowerShell: How to connect to SharePoint Online with PowerShell
    This article describes how to connect to SharePoint Online by using the PowerShell Module PNP.PowerShell Prerequisites An global admin approval for the enterprise app PNP.PowerShell Internet access Installation … Read more

PowerShell Archive of SharePoint Server

  • SharePoint Site Usage: Get active Sites for last 6 months with PowerShell
    When migrating our SharePoint to SharePoint Online, it can be really hard to separate the wheat from the chaff. SharePoint Site usage helps you find, what is actually used in your current farm. SharePoint farms grow by new projects and with the change of structures. If you want to have an overview, it is every time a good idea, to get rid of old stuff.
  • SharePoint get all sites and subsites PowerShell script
    SharePoint sites are created very fast. With a few clicks, admins and users can create dozens of sites and subsites. Since it is so easy to create sites, we as admins should have an overview, what is going on at our SharePoint environment. I wrote scripts for this purpose to get all sites and subsites of your SharePoint, so you can trim your SharePoint to your business needs. You will find a script for SharePoint Server and SharePoint Online.
  • 3 of the most important SharePoint PowerShell Modules and Snappins
    There are various ways to access SharePoint Online and SharePoint Server. Check out and learn what the main differences are. When to use which module / snapping, and which are the pros and cons from my point of view. You will also see, what you can change with each SharePoint PowerShell Module.
  • Determine internal name of SharePoint Columns with GUI
    You have to determine the internal name of SharePoint columns, when you want to get the values of the items programatically or develop some apps with PowerApps. If … Read more
  • PNP.PowerShell: How to connect to SharePoint Online with PowerShell
    This article describes how to connect to SharePoint Online by using the PowerShell Module PNP.PowerShell Prerequisites An global admin approval for the enterprise app PNP.PowerShell Internet access Installation … Read more

Click here to go back to home.

Leave a Reply