S
Sohel Shaikh
This metric identifies users who show OneDrive storage usage or activity but do not have a OneDrive license assigned. This can highlight potential licensing gaps, misconfigurations, or orphaned data left behind after a license removal.
Query :
Users[?(One_Drive_Last_Activity_Date != null || Storage_Used_In_Bytes >
0
) && Has_One_Drive_License == 'False'].[
displayName:
Display_Name,
storageUsed:
Storage_Used,
hasOneDriveLicense:
Has_One_Drive_License,
lastActivity:
One_Drive_Last_Activity_Date]