Skip to main content

How to find unutilized O365 services from powershell

Microsoft Office 365 is a comprehensive suite of productivity tools, and many organizations have a subscription to the service. However, despite its popularity, many of its features and services go unused or underutilized. Here are some common examples:

  1. OneDrive for Business: OneDrive is a cloud-based storage solution that allows users to store, access, and collaborate on files from anywhere. However, many organizations still rely on traditional file servers, which can lead to OneDrive going unused.

  2. SharePoint: SharePoint is a powerful collaboration platform that enables teams to work together on projects, documents, and other content. However, many organizations are not using it to its full potential, either due to lack of knowledge or simply not incorporating it into their workflows.

  3. Teams: Teams is a chat-based collaboration platform that brings together various communication and collaboration tools into one place. While it is becoming increasingly popular, many organizations are not taking advantage of its full range of features, such as the ability to host meetings and webinars, access documents, and share screens.

  4. PowerApps: PowerApps is a low-code platform that enables users to build custom apps for their organizations. While it has the potential to streamline many processes and improve productivity, many organizations are not taking advantage of this service.

  5. Stream: Stream is a video platform that allows users to upload, share, and view videos within their organization. While it has the potential to greatly enhance communication and collaboration, many organizations are not using it to its full potential.

By taking the time to understand and utilize these services, organizations can greatly improve their productivity, communication, and collaboration.



 Connect-MsolService


$UnusedServices = Get-MsolSubscribedSku | Where-Object {$_.ConsumedUnits -eq 0}


If ($UnusedServices) {

    Write-Host "Unutilized Office 365 services:"

    Write-Host ""

    $UnusedServices | Select-Object SkuPartNumber, ServiceUnitName, ConsumedUnits | Format-Table

}

Else {

    Write-Host "No unutilized Office 365 services found."

}




This script starts by connecting to the Microsoft Online Services using the Connect-MsolService cmdlet. It then uses the Get-MsolSubscribedSku cmdlet to retrieve a list of all subscribed services in your Microsoft 365 tenant. The Where-Object cmdlet is used to filter the results to only show services where the number of consumed units (as indicated by the ConsumedUnits property) is equal to 0.

Finally, the script checks to see if any unutilized services were found, and if so, it writes the results to the console using the Write-Host cmdlet and formats the output as a table using the Format-Table cmdlet. If no unutilized services were found, the script writes a message to the console indicating that no results were found.

Comments

Post a Comment

Popular posts from this blog

Microsoft power apps to generate day end email stats

  Power automate to generate a report to get total incoming outgoing emails in my mailbox for the day You can use Microsoft Power Automate (formerly Microsoft Flow) to generate a report of the total number of incoming and outgoing emails in your mailbox for a specific day. Here's a basic example of how you can get started: Create a new flow: Start by creating a new flow in Power Automate. You can choose a template or start from scratch, depending on your preference. Connect to your email account: Next, connect Power Automate to your email account. You can use the Office 365 Outlook Connector or the Exchange Connector, depending on which email service you use. Trigger the flow: Choose a trigger for the flow that will run it automatically on a schedule. For example, you could use the "Recurrence" trigger to run the flow every day at a specific time. Count the emails: Use the "Get email" action to retrieve all the emails in your inbox for the specific day. Then, us...
Post a Comment
Read more

Microsoft Viva Insights and Viva Insights Manager app

  Microsoft Viva Insights is a platform designed to help organizations promote employee well-being and productivity by providing data-driven insights and recommendations. It is an AI-powered tool that provides personalized insights to individuals, managers, and leaders. Viva Insights uses data from multiple sources such as Office 365, LinkedIn, and other business applications to analyze work patterns and provide insights on employee well-being, productivity, and collaboration. The platform is designed to help individuals manage their work-life balance by providing insights and recommendations on managing work hours, prioritizing tasks, and taking breaks. It also enables managers to identify potential burnout risks, track employee engagement, and support their team's well-being. Viva Insights provides a range of reports and dashboards that allow organizations to track employee well-being and productivity metrics and make data-driven decisions to support their employees. Additionally...
Post a Comment
Read more

Microsoft Copilot: Your AI-powered Productivity Partner

Microsoft Copilot is not just a name; it's a vision for the future of work. It's a suite of AI-powered tools designed to revolutionize the way we work, making us more efficient, creative, and productive. Copilot isn't just one tool; it's an ever-evolving ecosystem of features and functionalities that are constantly being updated and improved. What is Microsoft Copilot? At its core, Microsoft Copilot is a large language model (LLM) chatbot developed by Microsoft. It was initially launched as Bing Chat in February 2023 and has since evolved into a more comprehensive suite of tools integrated into various Microsoft products and services. Copilot leverages the power of LLMs to understand your needs and provide assistance in various ways, from simple tasks like answering questions to more complex tasks like generating creative content or summarizing documents. Copilot in Action Here are some of the ways Copilot can be used to enhance your productivity: Microsoft 365 Copilot:...
Post a Comment
Read more