In this blog post, I will explore the latest enhancements to the Get-CsOnlineUser cmdlet, including significant performance improvements and new filtering capabilities that allow you to retrieve information more efficiently. I will also provide examples of how to use the new attributes as filters in your PowerShell scripts to get the information you need about your Teams users.<\/p>\n\n\n\n
Performance Improvements<\/strong> <\/p>\n\n\n\n Use the New Attributes as Filters in your PowerShell Scripts<\/strong><\/p>\n\n\n\n At the moment two attributes quoted in the documentation are wrong compared to what you get from the tenant<\/p>\n\n\n\n CompanyName should be Company Note: In the examples I have just created a list of users that match the filter.<\/p>\n\n\n\n This command will retrieve all users who are located in the state of Washington, and in any city that contains “Bell” in its name<\/p>\n\n\n\n This command will retrieve all users who have the “PhoneSystem” feature enabled<\/p>\n\n\n\n This command will retrieve all users who were created between January 1st and March 6th, 2023<\/p>\n\n\n\n This command will retrieve all users whose SipProxyAddress contains “m365x01033383.onmicrosoft.com”<\/p>\n\n\n\n This command will retrieve all users whose CompanyName is “Contoso”<\/p>\n\n\n\n This command will retrieve all users whose HostingProvider is set to ” sipfed.online.lync.com”<\/p>\n\n\n\n This command will retrieve all users whose Alias contains “John”<\/p>\n\n\n\n This command will retrieve all soft deleted users who were deleted after January 1st, 2023<\/p>\n\n\n\n This command will retrieve all users whose PreferredDataLocation is set to “EUR”<\/p>\n\n\n\n This command will retrieve all users whose LastName is “Vance”.<\/p>\n\n\n\n The Get-CsOnlineUser PowerShell cmdlet is a powerful tool that enables you to retrieve information about your Teams users, and with the Teams PowerShell Module 5.0.0 it has been updated with new features and performance improvements to make managing your Teams users even easier (see the Release Notes here)<\/p>\n In this blog post, I will explore the latest enhancements to the Get-CsOnlineUser cmdlet, including significant performance improvements and new filtering capabilities that allow you to retrieve information more efficiently. I will also provide examples of how to use the new attributes as filters in your PowerShell scripts to get the information you need about your Teams users<\/p>\n","protected":false},"author":1,"featured_media":2857,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_sitemap_exclude":false,"_sitemap_priority":"","_sitemap_frequency":"","twitterCardType":"","cardImageID":0,"cardImage":"","cardTitle":"","cardDesc":"","cardImageAlt":"","cardPlayer":"","cardPlayerWidth":0,"cardPlayerHeight":0,"cardPlayerStream":"","cardPlayerCodec":"","footnotes":""},"categories":[810,753,752,757],"tags":[762,759,751,77,755,83],"class_list":["post-2851","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-810","category-microsoft365","category-microsoft-teams","category-office-365","tag-microsoftteams","tag-microsoft-365","tag-microsoft-teams","tag-office-365","tag-teams","tag-voice"],"_links":{"self":[{"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=\/wp\/v2\/posts\/2851","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2851"}],"version-history":[{"count":1,"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=\/wp\/v2\/posts\/2851\/revisions"}],"predecessor-version":[{"id":2858,"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=\/wp\/v2\/posts\/2851\/revisions\/2858"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=\/wp\/v2\/media\/2857"}],"wp:attachment":[{"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2851"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2851"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/modern-workplace.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2851"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
The image is get-csonlineuser from version 4.9.3 (above) and from version 5.0.0 (below). The test was from the same workstation and on the same tenant. The required time goes down from 34 seconds to 8<\/p>\n\n\n\n![\"\"](\"https:\/\/modern-workplace.uk\/wp-content\/uploads\/2023\/03\/PowerShell5_0_0.jpg\")
<\/a><\/figure>\n\n\n\n
State should be StateOrProvince<\/p>\n\n\n\nGet-CsOnlineUser -Filter {Stateorprovince -eq \"WA\" -and City -like \"Bell\"} | ft userprincipalname<\/code><\/pre>\n\n\n\n![\"\"](\"https:\/\/modern-workplace.uk\/wp-content\/uploads\/2023\/03\/Module5_0_0_1.jpg\")
<\/a><\/figure>\n\n\n\nGet-CsOnlineUser -Filter {FeatureTypes -contains \"PhoneSystem\"} | ft userprincipalname<\/code><\/pre>\n\n\n\n![\"\"](\"https:\/\/modern-workplace.uk\/wp-content\/uploads\/2023\/03\/Module5_0_0_1_feature.jpg\")
<\/a><\/figure>\n\n\n\nGet-CsOnlineUser -Filter {WhenCreated -gt \"2023-01-01T00:00:00Z\" -and WhenCreated -lt \"2023-03-06T23:59:59Z\"} | ft userprincipalname<\/code><\/pre>\n\n\n\nGet-CsOnlineUser -Filter {SipProxyAddress -like \"*m365x01033383.onmicrosoft.com\"} | ft userprincipalname<\/code><\/pre>\n\n\n\nGet-CsOnlineUser -Filter {Company -eq \"Contoso\"}<\/code><\/pre>\n\n\n\nGet-CsOnlineUser -Filter {HostingProvider -eq \"sipfed.online.lync.com\"} | ft userprincipalname<\/code><\/pre>\n\n\n\nGet-CsOnlineUser -Filter {Alias -like \"*john*\"}<\/code><\/pre>\n\n\n\nGet-CsOnlineUser -Filter {SoftDeletionTimestamp -gt \"2023-01-01T00:00:00Z\"}<\/code><\/pre>\n\n\n\nGet-CsOnlineUser -Filter {PreferredDataLocation -eq \"EUR\"}<\/code><\/pre>\n\n\n\nGet-CsOnlineUser -Filter {LastName -eq \"Vance\"}<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"