One script I run every now and then is one to check device free space - and if I'm in a really good mood I might even warn users with low space that their device could crash at any moment.
Remember only use 'select' in this statement so as not to potentially cause harm to your BESMgmt database.
Code:
select
b.DisplayName,
convert(int, substring(a.data, patindex('%3>%',a.Data)+2, patindex('%</t3>%',a.data) - patindex('%3>%',a.Data) - 2))
from [dbo].syncdevicemgmt a, [dbo].UserConfig b
where a.tableid ='5' and a.userconfigid = b.id
order by 2
SQL script to find users' device free memory
Better yet, use a backup of the DB 
Linear Mode
