Personally I use
QueryExpress as this enables me to query the SQL sever directly from my PC. Its a single exe file that doesn't need to be installed.
The SQL I use is:
Code:
select
Right(DisplayName, Len(DisplayName) - CharIndex(',',DisplayName)-1) + ' ' + Left(DisplayName, CharIndex(',',DisplayName)-1) AS UserName,
vUserConfigStats.Id,
PIN,
PhoneNumber,
MsgsPending,
LastContactTime,
HomeNetwork,
IMEI,
AppsVer,
ModelName,
ITPolicyName,
PasswordEnabled,
MsgsForwarded,
MsgsSent,
MsgsExpired,
MsgsFiltered,
MsgsFailed,
LastFwdTime,
LastSentTime,
ServerDN,
vUserConfigStats.CreationTime,
GroupName
FROM vUserConfigStats JOIN GroupConfig
ON vUserConfigStats.GroupConfigID = GroupConfig.Id
ORDER BY LastContactTime
Shows me all I need and more some days.