[big.phil]

check out the link for the available features of that product

Conceivium Business Solutions, Inc.

[Frank Castle]

Nice little app for exports, can you add the ability to export GROUPS, I have a ton setup and sort my reports by these groups.

Should note you need to run this with an ID that has permission to the DB.

[hdawg]

Originally Posted by SoUnCool

can you read MDS log file using that tool too ?

Get the book BlackBerry Hacks by Dave Mabe and with MS logparser and you can be a wizard.

[big.phil]

Originally Posted by jletendre

Nice little app for exports, can you add the ability to export GROUPS, I have a ton setup and sort my reports by these groups.

Should note you need to run this with an ID that has permission to the DB.

I think it should go without saying that you would need permissions to READ the database. the only tables being used at this time for data are: UserConfig, UserStats, GroupConfig, SyncDeviceMgmtSummary, ServerConfig

I have added it. what columns are of use in the GroupConfig table? right now i have GroupName and GroupDescription in version 1.0.0.3.

[Frank Castle]

Thanks .. just GroupName is fine .. I like to sort by the group when I run a report. (Each group is a division so it makes it easy to filter down)

[SoUnCool]

Originally Posted by hdawg

Get the book BlackBerry Hacks by Dave Mabe and with MS logparser and you can be a wizard.

thanks for the tip, this seems very promising

[Wiseass]

I like the app, any ability to maybe sort the different columnds ascending/descending by say clicking the column title?

edit: nvm I see you can do it lol. It seems to lag behind when I click the column but it's there!

[big.phil]

yeah, the sorting is built in, but it will take it just a second to go through the cells and sort them. im not sure how much lag you have, but it shouldnt be too much. i have a similar app that i commonly display 2000+ records and sorting that much data takes it about 5 seconds. how many rows do you have?

[hdawg]

I know I'm getting greedy here ... but any chance you'll post a list of the sql queries for each dataset you're grabbing?

[big.phil]

Here is the code that fills the main datagridview

SELECT     TOP 100 PERCENT dbo.UserConfig.DisplayName, dbo.UserConfig.PIN, dbo.SyncDeviceMgmtSummary.PhoneNumber, 
                      dbo.SyncDeviceMgmtSummary.IMEI, dbo.SyncDeviceMgmtSummary.HomeNetwork, dbo.SyncDeviceMgmtSummary.AppsVer, 
                      dbo.SyncDeviceMgmtSummary.ModelName, 
                      CASE dbo.SyncDeviceMgmtSummary.PasswordEnabled WHEN 1 THEN 'True' WHEN 0 THEN 'False' END AS 'PasswordEnabled', 
                      CASE dbo.UserStats.Status WHEN 12 THEN 'Running' WHEN 10 THEN 'In cradle' WHEN 0 THEN 'Initializing' END AS 'Status', 
                      dbo.SyncDeviceMgmtSummary.ITPolicyName, dbo.UserStats.UserConfigId, dbo.UserStats.MsgsForwarded, dbo.UserStats.MsgsSent, 
                      dbo.UserStats.MsgsPending, dbo.UserStats.MsgsExpired, dbo.UserStats.MsgsFiltered, dbo.UserStats.MsgsFailed, dbo.UserConfig.CreationTime, 
                      dbo.UserConfig.ActivationTime, dbo.UserStats.LastFwdTime, dbo.UserStats.LastSentTime, 
                      CASE dbo.UserConfig.RedirectWhenInCradle WHEN 1 THEN 'True' WHEN 0 THEN 'False' END AS 'RedirectWhenInCradle', 
                      dbo.UserConfig.MailboxSMTPAddr, dbo.UserConfig.OverrideSMTPAddr, dbo.UserConfig.MailboxDN, dbo.UserConfig.ServerDN, 
                      dbo.GroupConfig.GroupName, dbo.GroupConfig.Description AS 'GroupDescription'
FROM         dbo.UserConfig FULL OUTER JOIN
                      dbo.GroupConfig ON dbo.UserConfig.GroupConfigId = dbo.GroupConfig.Id FULL OUTER JOIN
                      dbo.UserStats ON dbo.UserConfig.Id = dbo.UserStats.UserConfigId FULL OUTER JOIN
                      dbo.SyncDeviceMgmtSummary ON dbo.UserConfig.Id = dbo.SyncDeviceMgmtSummary.UserConfigId
ORDER BY dbo.UserConfig.DisplayName

here is the code that gets the server info displayed in the label.

SELECT     MachineName, BESVersion
FROM         ServerConfig

[kerseyr]

Is this link working ok to the .zip file?

I just tried to download and nothing happens.

When I right click and try save as all i get is to save a .gif???

Can everyone else get to it ok?

[SEP]

no its a .gif

[gmm1tb]

Originally Posted by kerseyr

Is this link working ok to the .zip file?

I just tried to download and nothing happens.

When I right click and try save as all i get is to save a .gif???

Can everyone else get to it ok?

Had the same issue with IE7. Worked fine with Firefox.

[jibi]

Following the server crash, attachments for BBF were unfortunately lost.

[kerseyr]

Can anyone repost???

I would really like to see this?

thanks

[Frank Castle]

Repost

[ELBeast]

I'm getting an Error:
Invalid object name 'dbo.GroupConfig'.

[jbfb99]

Thanks much! Any chance you can add BES name for each account? I have up to 4 servers connecting to a database.

[big.phil]

sorry for the delay all. i didnt know the forum crashed and lost all the attachments. i reposted build 1.0.0.3 to the first post.

[big.phil]

Originally Posted by ELBeast

I'm getting an Error:
Invalid object name 'dbo.GroupConfig'.

what version of BES are you running? and is it for MSFT Exchange server?