[noeffectx]

Hello guys,


Can someone help me on my little issue. My boss wants me to submit a report of userlist on BES and when they got added on BES.

I'm trying to modify the view columns on BES but cant find it. Is there a log where I can find this list?


Thanks

[usererror]

This is on version 4.x? I know there is a way to do it, just don't remember. have you tried right clicking on the column headings? I had added/removed some of the columns on my view, but now I'm up on BES 5.0

[juwaack68]

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:

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

[KOR]

I'm curious - what is he/she going to do with the information? I can understand a user list, usage stats, etc., but when they were added to BES?

[DavidAdams]

I would guess audit purposes, of the show me the when they joined and the associated approval for same.

[noeffectx]

Originally Posted by KOR

I'm curious - what is he/she going to do with the information? I can understand a user list, usage stats, etc., but when they were added to BES?

My company pay's the employee $50 a month if their on the BES. Problem is a lot of users are saying their on bes for several months now and didn't got paid the right amount.

[noeffectx]

Originally Posted by juwaack68

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:

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

Remote MSSQL - Going to try QUERY Express later. Will give you an update. Thanks

[juwaack68]

Originally Posted by noeffectx

My company pay's the employee $50 a month if their on the BES. Problem is a lot of users are saying their on bes for several months now and didn't got paid the right amount.

Just keep in mind that if a user is removed/re-added on the BES (for troubleshooting purposes, perhaps), then the creation date changes to date they were re-added.

Do you have another way to track when someone gets added - like via a Helpdesk ticket/request?