PowerShell

Using Get-MgUserCalendarCount in Graph PowerShell

The Get-MgUserCalendarCount cmdlet is part of the Microsoft Graph PowerShell module specifically used to retrieve the number of calendar resources associated with a specified user. This cmdlet is particularly useful when managing multiple calendars and needing a quick overview of how many are linked to a user's account.

Cmdlet Syntax

Get-MgUserCalendarCount -UserId <String> [-Filter <String>]

The parameters:

-UserId: Specifies the user (by User ID or UPN) for whom you want to get the calendar count.
-Filter: Filters results based on specific properties. For example, filter based on calendar names or other properties.

Usage Examples

Retrieve the total calendar count for a specific user

This example retrieves the total number of calendars associated with the user john.doe@company.com.

Get-MgUserCalendarCount -UserId "john.doe@company.com"

Retrieve the calendar count with a specific filter

To filter calendars by a property that exists on the calendar resource, you can use valid properties like name or owner. This example filters the calendars by the name "Work Calendar".

Get-MgUserCalendarCount -UserId "john.doe@company.com" -Filter "name eq 'Work Calendar'"

Cmdlet Tips

User ID: The -UserId parameter accepts both the UserPrincipalName (UPN) and User GUID. Make sure you have the correct user information before executing the command.
Filter and Search: Combining -Filter and -Search parameters allows for more granular calendar counts. However, ensure that the property being filtered or searched exists.
Consistency Level: For large datasets, always use the -ConsistencyLevel Eventual to ensure accurate results.

Possible Errors & Solutions

Error	Cause	Solution
Property 'createdDateTime' is not found on type 'microsoft.graph.calendar'	The `createdDateTime` property does not exist on calendar objects in certain contexts.	Verify the available properties for calendar objects using the `Get-MgUserCalendar` cmdlet and correct the filter accordingly.
Invalid User ID or UPN	The `-UserId` provided is incorrect or does not exist.	Double-check the UserPrincipalName (UPN) or GUID and ensure the user exists in the tenant.
The term 'Get-MgUserCalendarCount' is not recognized as the name of a cmdlet	Microsoft Graph PowerShell module is not installed or imported.	Install and import the module: `Install-Module -Name Microsoft.Graph Import-Module Microsoft.Graph`

Use Cases

Track Calendar Utilization: IT administrators can track the number of calendars created by each user, ensuring users are not exceeding organizational limits.
Calendar Cleanup: Use the calendar count to identify inactive calendars by users, which can be removed or archived to reduce clutter in shared environments.
Security and Audit Reports: Generate reports on how many calendars are maintained per user, especially in organizations that heavily use shared calendars for different departments and projects.

Conclusion

The Get-MgUserCalendarCount cmdlet is a simple yet powerful tool for tracking and auditing calendar usage in Microsoft 365. It helps administrators manage users' calendars more effectively, ensuring data cleanliness and compliance. When used with -Filter and -Search, the cmdlet becomes more versatile, allowing you to retrieve specific results that align with business requirements. Make sure to handle errors efficiently by verifying user data and using consistent parameters.