[m_zafar]

Have got over 750 users and using cyrstal to analyse the data and produce reports. Need to figure out the field tha shows when a user was activated as i am not convinced alot are used regularly.

[juwaack68]

What version of BES are you using, and what platform?

For Exchange, there is a field in the userconfig table called ActivationTime you can use. Here a query I use that may help you out:

select 
 a.DisplayName,
 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
 where a.id = b.userconfigid
 order by a.displayname

[m_zafar]

im using 4.6 on exchange however i dont touch the exchange environment

hence i am using an odbc connection to the db and linking it to crystal reports to read the data.

I can see all the tables however not to sure where the field for activation is held

[m_zafar]

found it

Under vUserConfigStats select Activation time

Thanks juwaack68

[m_zafar]

managed to pull out stats on when the user was activated and how much they actually used their device. Our 80 users not used their devices for more then 2 weeks after activation. Do other BES admins find this. What a waste of money

[freakinvibe]

We sort by "Last contact time" in the BES Management console (4.1.7 MR3). Anyone that had no contact for more than 3 months must either have a good explanantion or give the device back.

[m_zafar]

you get many?