What kind of database are you using? Remote SQL or local MSDE? I use a tool called
Query Express. It's free and a 1 file application (which is wonderful). I have it installed on my own PC to access the BES that has the remote SQL database, and locally on the 3 BES servers I have using MSDE.
I then run this query to find device information, including when the user's account was created on the BES:
Code:
select
a.DisplayName,
c.ModelName,
c.PhoneNumber,
c.PIN,
c.HomeNetwork,
convert(varchar(10),a.CreationTime, 101)CreationDate,
convert(varchar(10),a.ActivationTime, 101)ActivationDate,
b.MsgsForwarded,
b.MsgsSent,
convert(varchar(10),b.LastFwdTime, 101)LastFwdDate,
convert(varchar(10),b.LastSentTime, 101)LastSentDate
from userconfig a, userstats b, vHandheldSummaryInfo c
where a.id = b.userconfigid and a.displayname = c.displayname
order by a.displayname