Month: September 2024
Regarding search functionality of the SharePoint online version
Hi all,
Please note how can we effectively navigate via a huge set up contents to get the desired search results while using SharePoint online.
Hi all, Please note how can we effectively navigate via a huge set up contents to get the desired search results while using SharePoint online. Read More
make a list of objects having a text as value
I would like to be able to select all objects à garder and on one other column all the lourder I always get a #valeur or #nom
is it possible that excel doesn’t like text ?
I am using office 2010
thank you for your help
3/43932 1/23039 v 1/23007 v 1/2sans a garder 1/28938 à garder 1/43643 1/43805 1/43017 1/83804 à garder 1/83028 à garder 1/168927 à garder 1/103927 1/108935 GrösseInv VP 3/4sans nr alto 3/4sans Bachelet? 1/23930 3/43076 3/43908 3/43919 1/43914 1/43906 3/43910 1/43913 1/43941 lourder 1/48938 à garder 1/43942 1/103945 1/43921 1/23090 1/23003 lourder 3/43934 à garder 3/43002 lourder 3/43902 lourder 1/43912 lourder 1/43802 à garder 3/43803 à garder 1/23900 3/43806 à garder 3/43909 lourder 3/4683 lourder 3/43926 lourder 1/2687 lourder 3/43002 3/43903 1/23026 lourder 3/43933 lourder 3/43920 lourder
I would like to be able to select all objects à garder and on one other column all the lourder I always get a #valeur or #nom is it possible that excel doesn’t like text ?I am using office 2010thank you for your help 3/43932 1/23039 v 1/23007 v 1/2sans a garder 1/28938 à garder 1/43643 1/43805 1/43017 1/83804 à garder 1/83028 à garder 1/168927 à garder 1/103927 1/108935 GrösseInv VP 3/4sans nr alto 3/4sans Bachelet? 1/23930 3/43076 3/43908 3/43919 1/43914 1/43906 3/43910 1/43913 1/43941 lourder 1/48938 à garder 1/43942 1/103945 1/43921 1/23090 1/23003 lourder 3/43934 à garder 3/43002 lourder 3/43902 lourder 1/43912 lourder 1/43802 à garder 3/43803 à garder 1/23900 3/43806 à garder 3/43909 lourder 3/4683 lourder 3/43926 lourder 1/2687 lourder 3/43002 3/43903 1/23026 lourder 3/43933 lourder 3/43920 lourder Read More
Find value in matrix based on today’s date in column
I have a matrix with a date sequence
=SEQUENCE(1;366;(DATE($D$6;1;1));1)
in the columns and names (text) in the rows.
I would like to write a formula that matches three search criteria: (1) today’s date (column D in the picture), AND (2) the value ‘Duty’ in the matrix, AND (3) the value ‘Manager’ in column A. The return value in the example should be “Carl” (B7).
I have a matrix with a date sequence =SEQUENCE(1;366;(DATE($D$6;1;1));1)in the columns and names (text) in the rows. I would like to write a formula that matches three search criteria: (1) today’s date (column D in the picture), AND (2) the value ‘Duty’ in the matrix, AND (3) the value ‘Manager’ in column A. The return value in the example should be “Carl” (B7). Read More
App is very slow with more than 50000 e-mails that are marked as important
Hello,
for several years I setup an email alarming system. Evertime the plc would make an alarm it would send a copy of that email to a shared outlook inbox. There were about 50000 emails accumulated.
Then, there is some automation, that would automaticly add a todo, when there is an email, that is marked “important”. Deleting the emails was easy. Deleting the todo’s is not easy at all!
The todo app is very slow, so that using it is almost impossible!
Is there an api or cli tool to bulk for-ever-delete those todos?
Hello,for several years I setup an email alarming system. Evertime the plc would make an alarm it would send a copy of that email to a shared outlook inbox. There were about 50000 emails accumulated. Then, there is some automation, that would automaticly add a todo, when there is an email, that is marked “important”. Deleting the emails was easy. Deleting the todo’s is not easy at all!The todo app is very slow, so that using it is almost impossible!Is there an api or cli tool to bulk for-ever-delete those todos? Read More
How to fix this filer issue in share point flow for archiving the old data’s
It seems that the error occurred due to an issue with the filter query in the ‘Get items’ action. The expression “Created It ‘2023-09-25T06:50:53.3142477Z'” is causing the query creation to fail. To fix this error, ensure that the filter query is correctly formatted to filter items based on the ‘Created’ field. Check the syntax and data type compatibility of the filter query to resolve this issue. could you help me on this.
It seems that the error occurred due to an issue with the filter query in the ‘Get items’ action. The expression “Created It ‘2023-09-25T06:50:53.3142477Z'” is causing the query creation to fail. To fix this error, ensure that the filter query is correctly formatted to filter items based on the ‘Created’ field. Check the syntax and data type compatibility of the filter query to resolve this issue. could you help me on this. Read More
Forgot iPad Password? How to Unlock iPad without password on Windows PC?
Hi all,
I am a new Windows 11 user and need some help in here. My son changed the screen passcode of my iPad and it is now locked due to too many failed attempts. I used to reset iPad without password on my Mac but I don’t have a Mac anymore. The only computer with me is a Windows 11 laptop.
I am eager to know what is the right step to unlock iPad without passcode if I forgot the password? I did some search and found out there are many ways to do this. Currently, I am quite confused and don’t know how to proceed next.
Looking forward to your advice!
Hi all, I am a new Windows 11 user and need some help in here. My son changed the screen passcode of my iPad and it is now locked due to too many failed attempts. I used to reset iPad without password on my Mac but I don’t have a Mac anymore. The only computer with me is a Windows 11 laptop. I am eager to know what is the right step to unlock iPad without passcode if I forgot the password? I did some search and found out there are many ways to do this. Currently, I am quite confused and don’t know how to proceed next. Looking forward to your advice! Read More
Problems Logging In Due to Multi-Factor Authentication
At the moment, I am unable to log in to Azure with my account (Global Administrator). Although I am also a Microsoft Partner and have 10 credits for support requests, I cannot create a support request here. Therefore, I have to post in this forum. I can log in to Office 365, PowerApps, Power Automate, and other services with MFA without any issues. However, when I log in to portal.azure.com, I am prompted for authentication again immediately after logging in, and I cannot proceed further from there.
I have created two tickets with Office 365 and Microsoft Entra ID, but neither ticket has successfully resolved the issue. Here is what we have tried so far:
Disabled MFA, but MFA still appears.Successfully removed my guest account from other organizations.
The problem still persists. What can I do here? Can Microsoft Azure contact me since I still have 10 credits?
At the moment, I am unable to log in to Azure with my account (Global Administrator). Although I am also a Microsoft Partner and have 10 credits for support requests, I cannot create a support request here. Therefore, I have to post in this forum. I can log in to Office 365, PowerApps, Power Automate, and other services with MFA without any issues. However, when I log in to portal.azure.com, I am prompted for authentication again immediately after logging in, and I cannot proceed further from there.I have created two tickets with Office 365 and Microsoft Entra ID, but neither ticket has successfully resolved the issue. Here is what we have tried so far:Disabled MFA, but MFA still appears.Successfully removed my guest account from other organizations.The problem still persists. What can I do here? Can Microsoft Azure contact me since I still have 10 credits? Read More
Installing the Entire Microsoft Graph PowerShell SDK Seems Like the Right Idea
An article described some benefits that could be gained from not installing the complete Microsoft Graph PowerShell SDK. The question is whether the claimed benefits are more theoretical than actual. It’s hard to say because it all depends on how someone uses the SDK for development or to run scripts. Anyway, it’s a topic worth discussing.
https://office365itpros.com/2024/09/24/microsoft-graph-powershell-sdk-code/
An article described some benefits that could be gained from not installing the complete Microsoft Graph PowerShell SDK. The question is whether the claimed benefits are more theoretical than actual. It’s hard to say because it all depends on how someone uses the SDK for development or to run scripts. Anyway, it’s a topic worth discussing.
https://office365itpros.com/2024/09/24/microsoft-graph-powershell-sdk-code/ Read More
Can’t add a guest user to a Shared Channel
We have lots of teams and channels and also guests in our tenant.
Now, I have a team with a shared channel with a partner and all are set up in B2B and working fine for some users from our partner but when I try to add more users from the partner I get a error message that doesn’t say much.
What’s the best practice here?
Should I remove the user as a guest from our tenant and try to readd the user to the shared channel or how to move forward?
Is it not possible to mix guest and external access? What if a user is guest in one team and external in another where he is in a shared channel?
BR,
Thomas
We have lots of teams and channels and also guests in our tenant.Now, I have a team with a shared channel with a partner and all are set up in B2B and working fine for some users from our partner but when I try to add more users from the partner I get a error message that doesn’t say much.What’s the best practice here?Should I remove the user as a guest from our tenant and try to readd the user to the shared channel or how to move forward?Is it not possible to mix guest and external access? What if a user is guest in one team and external in another where he is in a shared channel? BR,Thomas Read More
‘Bookings with me’ not working
Am getting the message: ‘We can’t get this info right now. Please try again.’ Or the bookings page just won’t load. Seems others are having the same issue: https://answers.microsoft.com/en-us/msoffice/forum/all/bookings-with-me-not-working/3cbd8bb4-c690-412e-baf9-ad0b92718e16
Am getting the message: ‘We can’t get this info right now. Please try again.’ Or the bookings page just won’t load. Seems others are having the same issue: https://answers.microsoft.com/en-us/msoffice/forum/all/bookings-with-me-not-working/3cbd8bb4-c690-412e-baf9-ad0b92718e16 Read More
Keep the row numbers in pivot table when you sort on field
I have made a pivot table and added a column at the end which is called comments. The purpose for that column is off course to make comments to the separate row in the pivot table. This works fine when i look at all the rows in the table, but when i use filter you get a shorter list, and the comments doesn’t follow the rows. You get a renumbering of the rows always starting with 1 and counting 1,2,3,4 and so on, instead that the row numbers stay constant as for the table without filter. Is it possible to keep the row number constant in a pivot table?
I have made a pivot table and added a column at the end which is called comments. The purpose for that column is off course to make comments to the separate row in the pivot table. This works fine when i look at all the rows in the table, but when i use filter you get a shorter list, and the comments doesn’t follow the rows. You get a renumbering of the rows always starting with 1 and counting 1,2,3,4 and so on, instead that the row numbers stay constant as for the table without filter. Is it possible to keep the row number constant in a pivot table? Read More
Breakout room issues to assign user to a room
Anyone else seen issues to assign a user to a break out room? Screenshot in Swedish but the “i” say “This user can’t access breakout room”
At the time for testing that user was signed in to Teams with an external identity and used Edge browser.
Ended meeting and rejoined and this time it worked but that is not the case all the time. Issue seems to be random.
This happens quite often last couple of months, anyone seen this?
Anyone else seen issues to assign a user to a break out room? Screenshot in Swedish but the “i” say “This user can’t access breakout room” At the time for testing that user was signed in to Teams with an external identity and used Edge browser.Ended meeting and rejoined and this time it worked but that is not the case all the time. Issue seems to be random. This happens quite often last couple of months, anyone seen this? Read More
Update Username
I go by the username Trevor in my user accounts. When I navigate to C:Users, my profile appears as “trevo.” I would like to update that. This issue has persisted since my previous PC. Just to clarify, I don’t actually log in.
I go by the username Trevor in my user accounts. When I navigate to C:Users, my profile appears as “trevo.” I would like to update that. This issue has persisted since my previous PC. Just to clarify, I don’t actually log in. Read More
Troubleshooting NTFS Permissions and Ownership Challenges
Greetings, Community Members,
I want to express my gratitude for the chance to be a part of this incredible forum where knowledge is shared and gained.
I am facing an issue with a friend’s Windows 11 Pro PC, which crashed after updates. Following a format, certain folders on the D drive have become inaccessible, with files showing an “access denied” error message. This may be due to changes in NTFS permissions and ownership that were previously assigned.
I attempted to use “Take ownership Pro,” but it was unsuccessful. Additionally, manual attempts to adjust inheritance and ownership have proved challenging. Is there an alternative method to gain full control of the folder? It’s important to note that I am working on this issue from a Windows 10 PC. Could this be a reason for the failure?
Any assistance provided would be greatly appreciated. Thank you.
Greetings, Community Members, I want to express my gratitude for the chance to be a part of this incredible forum where knowledge is shared and gained. I am facing an issue with a friend’s Windows 11 Pro PC, which crashed after updates. Following a format, certain folders on the D drive have become inaccessible, with files showing an “access denied” error message. This may be due to changes in NTFS permissions and ownership that were previously assigned. I attempted to use “Take ownership Pro,” but it was unsuccessful. Additionally, manual attempts to adjust inheritance and ownership have proved challenging. Is there an alternative method to gain full control of the folder? It’s important to note that I am working on this issue from a Windows 10 PC. Could this be a reason for the failure? Any assistance provided would be greatly appreciated. Thank you. Read More
How to Remove Desktop from the Navigation Pane
Hello,
I’d like to find out how I can eliminate the Desktop from the navigation pane.
The initial setup was problematic, with folders such as Downloads and Pictures pinned to Quick Access, resulting in some folders being duplicated.
Thanks,
Henry
Hello, I’d like to find out how I can eliminate the Desktop from the navigation pane. The initial setup was problematic, with folders such as Downloads and Pictures pinned to Quick Access, resulting in some folders being duplicated. Thanks,Henry Read More
Windows 7 is taking longer than 30 minutes to boot up after shutdown or restart.
Hello, I have been encountering persistent delays in booting up my primary laptop, which runs on Windows 7. Each time I power it down and restart, the system takes an exceedingly long time to reach the Windows desktop, sometimes around 30 minutes or even more.
I suspect that these delays could be originating from complications within the system Registry. This hypothesis is supported by a couple of observations:
* Whenever I search within the Registry (using Ctrl+F), it takes an exorbitant amount of time, often leading to the application freezing and requiring me to forcibly terminate the process via the Task Manager. Due to this, I usually opt to put the laptop to sleep instead of shutting it down, as it resumes from sleep mode almost instantaneously.
* Additionally, when I attempt to save the Registry through Export, the process takes an exceptionally long time to complete, lasting up to 25 minutes and resulting in a huge file size of 10.4GB.
These symptoms strongly suggest that the Registry may be corrupted, thus leading to the prolonged boot-up times.
I am seeking assistance on whether there is a cost-effective solution to address this issue. While my profile mentions Windows 10 devices, it is worth noting that my other devices running Windows 10 are relatively new and not experiencing the same boot-up or Registry problems as my main Windows 7 laptop.
Hello, I have been encountering persistent delays in booting up my primary laptop, which runs on Windows 7. Each time I power it down and restart, the system takes an exceedingly long time to reach the Windows desktop, sometimes around 30 minutes or even more. I suspect that these delays could be originating from complications within the system Registry. This hypothesis is supported by a couple of observations:* Whenever I search within the Registry (using Ctrl+F), it takes an exorbitant amount of time, often leading to the application freezing and requiring me to forcibly terminate the process via the Task Manager. Due to this, I usually opt to put the laptop to sleep instead of shutting it down, as it resumes from sleep mode almost instantaneously.* Additionally, when I attempt to save the Registry through Export, the process takes an exceptionally long time to complete, lasting up to 25 minutes and resulting in a huge file size of 10.4GB. These symptoms strongly suggest that the Registry may be corrupted, thus leading to the prolonged boot-up times. I am seeking assistance on whether there is a cost-effective solution to address this issue. While my profile mentions Windows 10 devices, it is worth noting that my other devices running Windows 10 are relatively new and not experiencing the same boot-up or Registry problems as my main Windows 7 laptop. Read More
Is it normal for automatic maintenance to run when my computer is idle every day?
Hello,
I have observed that my Windows 11 computer initiates Automatic Maintenance multiple times throughout the day. This typically occurs when my computer has been idle for approximately 10 minutes and ceases as soon as I resume my work. Upon returning to work, I promptly check the Security and Maintenance Center, which confirms that the maintenance process was executed mere minutes before. It appears that the system initiates maintenance during idle periods and halts once I am actively using the computer. Is this behavior to be expected?
However, there are instances when the Automatic Maintenance does not cease, and it seems to continue running even after I have resumed work from an idle state. Shouldn’t it stop immediately when I am active again? At times, the maintenance process persists until I either shut down my computer or manually intervene to end it. Is this normal? Has anyone encountered this issue before? Should I simply wait for it to stop on its own?
Furthermore, I believe that the Automatic Maintenance is functioning properly since I have noted information pertaining to defragmentation and ESENT, with no reported errors. These recent observations have raised concerns for me as I lack a comprehensive understanding of how this process operates. Could someone kindly provide insight into these queries? Your assistance is greatly appreciated.
Thank you.
Hello, I have observed that my Windows 11 computer initiates Automatic Maintenance multiple times throughout the day. This typically occurs when my computer has been idle for approximately 10 minutes and ceases as soon as I resume my work. Upon returning to work, I promptly check the Security and Maintenance Center, which confirms that the maintenance process was executed mere minutes before. It appears that the system initiates maintenance during idle periods and halts once I am actively using the computer. Is this behavior to be expected? However, there are instances when the Automatic Maintenance does not cease, and it seems to continue running even after I have resumed work from an idle state. Shouldn’t it stop immediately when I am active again? At times, the maintenance process persists until I either shut down my computer or manually intervene to end it. Is this normal? Has anyone encountered this issue before? Should I simply wait for it to stop on its own? Furthermore, I believe that the Automatic Maintenance is functioning properly since I have noted information pertaining to defragmentation and ESENT, with no reported errors. These recent observations have raised concerns for me as I lack a comprehensive understanding of how this process operates. Could someone kindly provide insight into these queries? Your assistance is greatly appreciated. Thank you. Read More
Boost Your Career with Microsoft Azure Certification Courses
In an exciting move for tech enthusiasts and professionals alike, I’m excited to share an excellent opportunity for tech enthusiasts and professionals to enhance their cloud computing skills. Microsoft is offering valuable Azure certification courses that could potentially elevate your career in the dynamic world of cloud technology.
Unlock Azure Expertise with Microsoft Learn
Microsoft, a leader in cloud computing, provides a wealth of learning resources for its Azure platform through Microsoft Learn. While all certification pathways are available via Microsoft Learn, we’re highlighting two particularly comprehensive courses that cover both fundamental and advanced concepts of Azure.
Featured Azure Courses
Microsoft has rolled out two pivotal courses that cover the fundamentals and advanced concepts of Azure:
1. Microsoft Azure Fundamentals (AZ-900T00)
Duration: 24 hours
Perfect for: Beginners and those new to cloud concepts
Course Link: Azure Fundamentals
2. Developing Solutions for Microsoft Azure (AZ-204T00)
Duration: 120 hours
Ideal for: Developers looking to create Azure-based solutions
Course Link: Developing Solutions for Azure
Why These Courses Matter?
In today’s digital landscape, cloud skills are not just an asset; they’re a necessity. Azure certification can significantly boost your marketability and open doors to lucrative career opportunities. These courses provide high-quality cloud education, enabling learners worldwide to upskill and stay competitive in the job market.
What to Expect from the Courses
Both courses offer a rich learning experience, including:
Engaging video lectures
Hands-on tutorials
Easy-to-understand notes
Real-world scenarios and best practices
The Azure Fundamentals course provides a solid foundation in cloud concepts, while the Developing Solutions course dives deep into creating scalable solutions on the Azure platform.
How to Get Started
Getting started is as simple as clicking on the course links provided above. You can learn at your own pace, fitting the courses into your busy schedule. Remember that while the courses are accessible, there is a cost associated with the certification examinations.
The Impact on Your Career
Completing these courses and earning Azure certifications can:
Enhance your resume and LinkedIn profile
Increase your earning potential
Make you stand out in job interviews
Prepare you for the future of cloud computing
Explore All Certification Pathways
While we’ve highlighted two of many excellent courses, it’s important to note that Microsoft Learn offers a wide range of certification pathways. We encourage you to explore the full spectrum of Azure certifications available to find the path that best suits your career goals and interests.
Spread the Word
This opportunity is too good to keep to yourself. Share this information with your colleagues, friends, and professional network. By doing so, you’re not just sharing a link; you’re potentially changing someone’s career trajectory.
Conclusion
Microsoft’s comprehensive Azure certification courses demonstrate their commitment to fostering a skilled global workforce. As cloud technology continues to shape the future of IT, investing in these learning resources could be your step towards becoming a cloud computing expert.
Don’t miss this chance to elevate your skills. Dive into the world of Azure today and set yourself up for a brighter, cloud-powered future!
Remember to explore all certification pathways available on Microsoft Learn. The cloud is the limit!
Microsoft Tech Community – Latest Blogs –Read More
Dapr v1.14.4 now available in the Dapr extension for AKS and Arc-enabled Kubernetes
The Dapr extension for AKS and Arc-enabled Kubernetes now supports Dapr v1.14.4.
Dapr is a developer framework for building cloud-native applications, making it easier to run multiple microservices on Kubernetes and interact with external state stores/databases, secret stores, pub/sub brokers, and other cloud services and self-hosted solutions.
The Dapr v1.14 release offers several new features, including a new Jobs API for scheduling and running jobs, a new Scheduler control plane service, streaming subscriptions, actor multi-tenancy with namespaces, outbox pattern projections, HTTP metrics path matching, many fixes in the core runtime and components, and more.
Learn how to get started with the Dapr extension
Learn more about Dapr
Read the release notes for Dapr 1.14.4
Review the level of support provided to the Dapr extension.
Highlights
The v1.14 release includes several significant highlights:
Outbox message projections (stable)
Service invocation for non-Dapr endpoints (stable)
The ability to invoke non-Dapr endpoints using the Dapr Service Invocation API is now stable.
Jobs API and Scheduler service (preview)
Scheduler service (preview)
Increased throughput and scalability for actors and workflows (preview)
kind: Configuration
metadata:
name: featureconfig
spec:
features:
– name: SchedulerReminders
enabled: true
Streaming subscriptions (preview)
A subscription HTTP endpoint in your application (typically required by the current programmatic and declarative subscriptions), making them easy to configure in code.
An app to be configured with the sidecar to receive messages.
Actor multi-tenancy with namespacing
HTTP metrics filtering with path matching
Dapr Shared
Using a Kubernetes Daemonset for a per-node deployment
Using a Deployment for a per-cluster deployment.
Features & component updates
Many feature and component statuses have been updated in this release. See the full list in the release notes.
Microsoft Tech Community – Latest Blogs –Read More
Installing the Entire Microsoft Graph PowerShell SDK Seems Like the Right Idea
Some Say It’s a Bad Idea to Install Every Microsoft Graph PowerShell SDK Sub-Module
An interesting article by Sam Ende made the case for not installing every one of the 38 sub-modules in the Microsoft Graph PowerShell SDK, not to mention the 171 sub-modules used by Azure PowerShell. The idea is that you review the full set of modules and only install the modules needed top run scripts. This is not a new notion. Azure Automation requires explicit installation of modules as resources for automation accounts before the cmdlets in the modules are used.
Advantages of Not Installing Every Sub-Module
Proponents of the idea cite several advantages. Taking the Graph SDK as an example, let’s discuss them:
Faster Auto-Import and Tab-Completion: Auto-import is what happens when a script references a cmdlet that isn’t already loaded into the session. If the module containing the cmdlet is installed, PowerShell loads it. Tab completion is what happens if you enter a partial cmdlet name and press tab. PowerShell cycles through the set of matching cmdlets for you to chose from. It makes sense that auto-import and tab completion will function faster when less processing is needed and I do see a slight delay when an SDK cmdlet is first referenced, but overall, I think the gain is marginal.
Reduced Memory Usage: Every module that’s loaded into a PowerShell session consumes some memory. On a theoretical level, if a session loads every SDK module, it might consume a lot of memory. However, auto-import means that PowerShell only loads modules when necessary, so I’m not worried about memory consumption on a modern PC.
Avoiding Conflicts: Because a cmdlet name most only be unique within a module, the possibility for cmdlet name clashes increases as the number of loaded modules mounts. However, Microsoft takes care of ensuring that SDK cmdlet names are unique (but very long at times), so this should not be an issue, even when beta modules and the Microsoft Entra module are considered. A bigger issue is Microsoft’s inability to coordinate module dependencies across products, something that still happens.
Improved Security: The fear is that unused modules might not be regularly updated. I assume the lack of updating is the fault of the user rather than the developer because Microsoft updates every module in the Microsoft Graph PowerShell SDK monthly using a process called AutoRest. If you automate module updating and make sure that this is done regularly, the fact that a few unused modules are on a drive shouldn’t be a concern.
Simplified Management: It’s true that the fewer components that must be maintained, the less chance that problems will sneak in to compromise an environment. However, if you perform periodic maintenance, all should be well. I use a script to maintain the full set of Microsoft 365-related modules (including Exchange Online, SharePoint Online, Teams, SharePoint PnP, DSC, etc.). Using PowerShell to manage PowerShell seems like the right thing to do.
From V2.0 on, the Microsoft Graph PowerShell SDK is divided into separate production and beta modules. I install the complete set of production and beta modules. I never know when a script will require a cmdlet that’s in a relatively underused module and prefer to have everything to hand at the expense of a little extra disk space (my automated script removes old versions of the SDK modules). I also install the Microsoft Entra module to keep an eye on its progress.
Determining Modules to Install
My preference is to install the complete Microsoft Graph PowerShell SDK. But if you want to reduce the set of modules, you must decide which to install. You can check each module to find the cmdlets it contains with the Get-Command cmdlet, like this:
Get-Command -Module Microsoft.Graph.Authentication | Sort-Object Name | Format-table Name, CommandType
Name CommandType
—- ———–
Add-MgEnvironment Cmdlet
Connect-Graph Alias
Connect-MgGraph Cmdlet
Disconnect-Graph Alias
Disconnect-MgGraph Cmdlet
An analysis of all the Graph SDK and Entra module cmdlets can be accomplished by extracting details of the cmdlets from all the modules. Here’s code to do the job:
$Report = [System.Collections.Generic.List[Object]]::new()
[array]$Modules = Get-InstalledModule -Name Microsoft.Graph.* | Select-Object Name, Version | Sort-Object Name
Write-Host (“{0} Microsoft Graph modules found” -f $Modules.Count)
ForEach ($Module in $Modules) {
Write-Host (“Processing module {0} version {1}” -f $Module.Name, $Module.Version)
If ($Module.Name -ne “Microsoft.Graph.Beta”) {
[array]$Cmdlets = Get-Command -Module $Module.Name
ForEach ($Cmdlet in $Cmdlets) {
$ReportLine = [PSCustomObject] @{
ModuleName = $Module.Name
ModuleVersion = $Module.Version
CmdletName = $Cmdlet.Name
CmdletType = $Cmdlet.CommandType
}
$Report.Add($ReportLine)
}
}
}
$Report | Sort-Object CmdletName | Out-GridView -Title ‘Microsoft Graph Cmdlets’
The script will take some time to run. On my PC, it reported 25,130 cmdlets in 38 Graph (production) modules, 44 Graph (beta) modules, and 2 Entra modules (Figure 1). Your numbers might differ depending on the version of the SDK (I used 2.23.0).
Another method is to check the modules loaded in an interactive session after running some representative scripts. Here’s what’s reported for my current interactive session.
Get-Module | Where-Object {$_.Name -like “*Graph*”} | Format-Table Name, Version
Name Version
—- ——-
Microsoft.Graph.Authentication 2.23.0
microsoft.graph.beta.calendar 2.23.0
microsoft.graph.beta.identity.directorymanagement 2.23.0
microsoft.graph.beta.people 2.23.0
microsoft.graph.beta.users 2.23.0
microsoft.graph.beta.users.actions 2.23.0
microsoft.graph.beta.users.functions 2.23.0
Microsoft.Graph.Calendar 2.23.0
Microsoft.Graph.DirectoryObjects 2.23.0
Microsoft.Graph.Groups 2.23.0
Microsoft.Graph.Identity.DirectoryManagement 2.23.0
Microsoft.Graph.Mail 2.23.0
Microsoft.Graph.PersonalContacts 2.23.0
Microsoft.Graph.Reports 2.23.0
Microsoft.Graph.Users 2.23.0
I can’t remember how long the session lasted (at least a few days) or what scripts were run (several), but this is a good indication of the modules that you actually use. The Microsoft.Graph.Authentication module is always required as without it you cannot authenticate.
A Personal Choice
Deciding what Microsoft Graph PowerShell SDK modules to install is a personal call. It is highly dependent on the objects that you focus on (like users, groups, and devices) and the actions taken in scripts. It might be worthwhile to check what modules you use as described above. You might then decide to trim what’s install or, if you’re like me, leave well enough alone and install everything.
Support the work of the Office 365 for IT Pros team by subscribing to the Office 365 for IT Pros eBook. Your support pays for the time we need to track, analyze, and document the changing world of Microsoft 365 and Office 365.
