SOLVED

I cannot see how to deal with SecureScore 'Disable accounts not used in last 30 days'

%3CLINGO-SUB%20id%3D%22lingo-sub-87136%22%20slang%3D%22en-US%22%3EI%20cannot%20see%20how%20to%20deal%20with%20SecureScore%20'Disable%20accounts%20not%20used%20in%20last%2030%20days'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-87136%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20'learn%20more'%20page%20explanation%20does%20not%20seem%20to%20fit%20my%20tennant.%3C%2FP%3E%3CP%3EWhen%20I%20go%20to%20'launch%20now'%20then%20I%20do%20indeed%20get%20a%20list%20of%20active%20users%2C%20but%20how%20can%20I%20see%20the%20users%20that%20have%20not%20logged%20on%20recently%3F%20I%20downloaded%20the%20spreadsheet%2C%20but%20there%20is%20no%20'last%20logged%20on'%20column.%3C%2FP%3E%3CP%3EMy%20users%20are%20synchronised%20with%20my%20onsite%20AD%2C%20and%20we're%20using%20ADFS.%3C%2FP%3E%3CP%3EMark%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-190524%22%20slang%3D%22en-US%22%3ERe%3A%20I%20cannot%20see%20how%20to%20deal%20with%20SecureScore%20'Disable%20accounts%20not%20used%20in%20last%2030%20days'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-190524%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Mark%20and%20Vasil%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%20for%20bring%20this%20to%20our%20attention.%26nbsp%3B%20I%20have%20asked%20the%20engineering%20team%20to%20create%20a%20bug%20request%20to%20update%20the%20link%20to%20point%20to%20the%20report%20that%20you%20called%20out.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-188416%22%20slang%3D%22en-US%22%3ERe%3A%20I%20cannot%20see%20how%20to%20deal%20with%20SecureScore%20'Disable%20accounts%20not%20used%20in%20last%2030%20days'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-188416%22%20slang%3D%22en-US%22%3E%3CP%3EI%20downloaded%20the%20list%2C%20converted%20to%20an%20Excel%20table%20and%20used%20%3Dmax(range%20of%20cells%20on%20row%20with%20usage%20dates%20in%20them)%20to%20find%20the%20last%20used%20feature%20date.%20filtered%20the%20list%2C%20and%20bingo!%3C%2FP%3E%3CP%3EMaybe%20the%20user%20list%20should%20not%20be%20the%20user%20list%20if%20there%20is%20not%20a%20'days%20since%20last%20used'%20column%20and%20the%20target%20of%20the%20secure%20score%20item%20should%20be%20the%20license%20activity%20report.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fportal.office.com%2Fadminportal%2Fhome%23%2FreportsUsage%2FLicenseActivity%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fportal.office.com%2Fadminportal%2Fhome%23%2FreportsUsage%2FLicenseActivity%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-87210%22%20slang%3D%22en-US%22%3ERe%3A%20I%20cannot%20see%20how%20to%20deal%20with%20SecureScore%20'Disable%20accounts%20not%20used%20in%20last%2030%20days'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-87210%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20reports%20in%20the%20O365%20Admin%20portal%20give%20you%20this%20information%3A%20%3CA%20href%3D%22https%3A%2F%2Fportal.office.com%2Fadminportal%2Fhome%23%2FreportsUsage%2FLicenseActivity%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fportal.office.com%2Fadminportal%2Fhome%23%2FreportsUsage%2FLicenseActivity%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

The 'learn more' page explanation does not seem to fit my tennant.

When I go to 'launch now' then I do indeed get a list of active users, but how can I see the users that have not logged on recently? I downloaded the spreadsheet, but there is no 'last logged on' column.

My users are synchronised with my onsite AD, and we're using ADFS.

Mark

3 Replies
best response confirmed by Mark Taylor (Occasional Contributor)

I downloaded the list, converted to an Excel table and used =max(range of cells on row with usage dates in them) to find the last used feature date. filtered the list, and bingo!

Maybe the user list should not be the user list if there is not a 'days since last used' column and the target of the secure score item should be the license activity report.

https://portal.office.com/adminportal/home#/reportsUsage/LicenseActivity 

 

Hi Mark and Vasil,

 

Thanks for bring this to our attention.  I have asked the engineering team to create a bug request to update the link to point to the report that you called out.