{"id":7036,"date":"2023-06-12T14:35:26","date_gmt":"2023-06-12T14:35:26","guid":{"rendered":"https:\/\/pariswells.com\/blog\/?p=7036"},"modified":"2024-08-31T05:33:44","modified_gmt":"2024-08-31T05:33:44","slug":"find-old-inactive-computerdevices-and-user-accounts-in-azure-active-directory","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/research\/find-old-inactive-computerdevices-and-user-accounts-in-azure-active-directory","title":{"rendered":"Find Old Inactive Computer\\Devices and User Accounts in Azure Active Directory"},"content":{"rendered":"\n

Azure AD Accounts<\/h2>\n\n\n\n

Inactive Guest or Member Users<\/h3>\n\n\n\n

Graph Explorer ( change Date ) : https:\/\/graph.microsoft.com\/v1.0\/users?$filter=signInActivity\/lastSignInDateTime le 2023-05-13T00:00:00Z<\/p>\n\n\n\n

Inactive Member Users<\/h3>\n\n\n\n

https:\/\/graph.microsoft.com\/v1.0\/users?$filter=signInActivity\/lastSignInDateTime le 2023-05-13T00:00:00Z&$filter=userType eq ‘Member’&$filter=accountEnabled eq true<\/p>\n\n\n\n

Inactive Guest Users<\/h3>\n\n\n\n

https:\/\/graph.microsoft.com\/v1.0\/users?$filter=signInActivity\/lastSignInDateTime le 2023-05-13T00:00:00Z&$filter=userType eq ‘Guest’&$filter=accountEnabled eq true<\/p>\n\n\n\n

How to report on Inactive Users that are not Syncing from Onprem ( Cloud Only ) <\/h3>\n\n\n\n

The Value onPremisesSyncEnabled<\/strong> in Graph API we cannot report on in the \/users Graph API , the workaround is to create a Dynamic group with Only Cloud Only users and use Groups API ( Member of ) <\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n

https:\/\/graph.microsoft.com\/beta\/groups\/%AZUREGROUPID%\/members?$count=true&$filter=accountEnabled eq true&$filter=signInActivity\/lastSignInDateTime le 2023-05-13T00:00:00Z&$filter=userType eq ‘Member’&$select=userPrincipalName<\/p>\n\n\n\n

Inactive Devices<\/h3>\n\n\n\n

Graph Explorer ( change Date ) : https:\/\/graph.microsoft.com\/v1.0\/devices?$filter=approximateLastSignInDateTime le 2023-05-13T00:00:00Z<\/p>\n\n\n\n

Emai Report Inactive Devices<\/strong><\/p>\n\n\n\n

https:\/\/www.burgerhout.org\/device-clean-up-in-azuread-intune<\/a><\/p>\n\n\n\n

How to get Json Odata exported from Graph Explorer to Excel<\/strong><\/p>\n\n\n\n

https:\/\/www.howtogeek.com\/775651\/how-to-convert-a-json-file-to-microsoft-excel\/<\/a><\/p>\n\n\n\n

Inactive Guest Accounts<\/h3>\n\n\n\n
\"\"<\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"

Azure AD Accounts Inactive Guest or Member Users Graph Explorer ( change Date ) : https:\/\/graph.microsoft.com\/v1.0\/users?$filter=signInActivity\/lastSignInDateTime le 2023-05-13T00:00:00Z Inactive Member Users https:\/\/graph.microsoft.com\/v1.0\/users?$filter=signInActivity\/lastSignInDateTime le 2023-05-13T00:00:00Z&$filter=userType eq ‘Member’&$filter=accountEnabled eq […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-7036","post","type-post","status-publish","format-standard","hentry","category-research"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/7036","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/comments?post=7036"}],"version-history":[{"count":4,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/7036\/revisions"}],"predecessor-version":[{"id":8260,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/7036\/revisions\/8260"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=7036"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=7036"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=7036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}