Can I filter users who have no signInActivity?

%3CLINGO-SUB%20id%3D%22lingo-sub-3094092%22%20slang%3D%22en-US%22%3ECan%20I%20filter%20users%20who%20have%20no%20signInActivity%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3094092%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20I%20have%20read%20and%20used%20the%20method%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Factive-directory%2Freports-monitoring%2Fhowto-manage-inactive-user-accounts%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Factive-directory%2Freports-monitoring%2Fhowto-manage-inactive-user-accounts%3C%2FA%3E%26nbsp%3Bto%20check%20for%20users%20who%20have%20been%20inactive%20for%20X%20time.%3C%2FP%3E%3CP%3EA%20filter%20like%20this%20is%20suggested%26nbsp%3B%3CBR%20%2F%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgraph.microsoft.com%2Fbeta%2Fusers%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgraph.microsoft.com%2Fbeta%2Fusers%3C%2FA%3E%3F%3CSTRONG%3Efilter%3DsignInActivity%2FlastSignInDateTime%20le%202019-06-01T00%3A00%3A00Z%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20this%20does%20not%20work%20for%20people%20who%20never%20logged%20in%20and%20have%20no%20signInActivity%20and%20cant%20seem%20to%20find%20a%20way%20to%20filter%20on%20it%20being%20null%20or%20empty%20or%20whatever.%3CBR%20%2F%3E%3CBR%20%2F%3EDo%20I%20have%20to%20fetch%20all%20the%20users%20and%20filter%20locally%20on%20that%20dataset%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3094092%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAPI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3097306%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20filter%20users%20who%20have%20no%20signInActivity%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3097306%22%20slang%3D%22en-US%22%3EFiltering%20in%20Graph%20remains%20quite%20limited%2C%20so%20it's%20very%20likely%20that%20you%20have%20to%20do%20thing%20client-side.%20If%20you%20do%20come%20up%20with%20a%20filter%20that%20actually%20does%20this%2C%20please%20share%20%3A)%3C%2Fimg%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

So I have read and used the method here https://docs.microsoft.com/en-us/azure/active-directory/reports-monitoring/howto-manage-inactive-use... to check for users who have been inactive for X time.

A filter like this is suggested 
https://graph.microsoft.com/beta/users?filter=signInActivity/lastSignInDateTime le 2019-06-01T00:00:00Z

 

But this does not work for people who never logged in and have no signInActivity and cant seem to find a way to filter on it being null or empty or whatever.

Do I have to fetch all the users and filter locally on that dataset?

 

1 Reply
Filtering in Graph remains quite limited, so it's very likely that you have to do thing client-side. If you do come up with a filter that actually does this, please share :)