SQL query to get #BlackBerry User information

So following on from my last post (http://blog.flaphead.com/2013/04/23/using-powershell-to-run-a-sql-command/) I use this SQL query to dump BlackBerry User information in to a #Powershell array so I can export it out.

SELECT [ServerConfig]. [ServiceName]
      , [UserConfig]. [DisplayName]
      , [UserConfig]. [UserName]
      , [userconfig]. [MailboxSMTPAddr] as [SMTPAddress]
      , [SyncDeviceMgmtSummary]. [ModelName]
      , [SyncDeviceMgmtSummary]. [PhoneNumber]
      , [SyncDeviceMgmtSummary]. [PlatformVer]
      , [SyncDeviceMgmtSummary]. [IMEI]
      , [SyncDeviceMgmtSummary]. [HomeNetwork]
      , [SyncDeviceMgmtSummary]. [AppsVer]
      , [UserConfig]. [PIN]
      , [ITPolicy2]. [PolicyName]
      , [UserConfig]. [MailboxSMTPAddr]
      , [UserConfig]. [MailboxDN]
      , [UserConfig]. [ServerDN] as [ExchangeServer]
      , [UserConfig]. [AgentId]
      , [UserConfig]. [RoutingInfo]
      , [UserStats]. [MsgsPending]
      , [UserStats]. [LastFwdTime]
      , [UserStats]. [LastSentTime]
      , CASE [UserStats] . [Status]
            WHEN 13 THEN ‘Stopped’
            WHEN 12 THEN ‘Running’
            WHEN 9  THEN ‘Redirection disabled’
            WHEN 0  THEN ‘Initializing’
            ELSE ‘Unknown [‘ + CONVERT (varchar , [UserStats]. [Status] ) + ‘]’
        END AS UserStatus
  FROM [dbo] . [UserConfig]
   LEFT OUTER JOIN [dbo] .[UserStats]
    ON [UserConfig]. [Id] =[UserStats] . [UserConfigId]
   LEFT OUTER JOIN [dbo] .[ITPolicy2]
    ON [UserConfig]. [ITPolicy2Id] =[ITPolicy2] . [Id]
   LEFT OUTER JOIN [dbo] .[ServerConfig]
    ON [UserConfig]. [ServerConfigId] =[ServerConfig] . [Id]
   LEFT OUTER JOIN [dbo] .[SyncDeviceMgmtSummary]
    ON [UserConfig]. [Id] =[SyncDeviceMgmtSummary] . [UserConfigId]

So setting the above at $SqlQuery and then running

$SqlServer = “BlackBerry SQL Server”
$SqlDb = “BlackBerry Database Name”
RunSqlQuery  $SqlServer $SqlDb $SqlQuery

 

BlackBerry Enterprise Server Interim Security Update for February 12,2013

Saw this today ..

Fixed issues

Vulnerabilities existed in how the BlackBerry MDS Connection Service, BlackBerry Collaboration Service, and the BlackBerry Messaging Agent processed TIFF images for rendering on BlackBerry devices. These vulnerabilities could have allowed a potentially malicious user to execute arbitrary code using the privileges of the BlackBerry Enterprise Server login account. (DT 5468999, DT 5542642, DT 5890761, and DT 6098370)

These issues are resolved by this interim security software update. The update replaces the image.dll file that the affected components use with an image.dll file that is not affected by the vulnerabilities. For more information, visit www.blackberry.com/btsc to read KB33425.

#Powershell Service Uptime

So i wanted to see how long a couple of BlackBerry servers had been up, but I wanted to know how long the services has been running.  So i knocked this up.  Its dead simple to change for other services!

$Servers = "BES01", "BES02"
$Matrix = @()
ForEach($Server in $Servers){
  Write-Host $Server -Foregroundcolor Green
  $SVC = Get-Service -ComputerName $Server | Where {$_.Name -like "Black*"}
  Foreach($item in $SVC){
    $tmpMatrix="" | Select Server, Service, State, Uptime
    Write-Host "-" $Item.Name
    $tmpMatrix.Server = $Server
    $tmpMatrix.Service = $item.Name
    $s = gwmi win32_service -ComputerName $Server -filter "name = ‘$($item.Name)’"
    $tmpMatrix.State = $s.State
    If ($s.State -eq "Running"){
      $tmpUpTime = "{0}" -f ((get-date) – ([wmi]”).ConvertToDateTime((gwmi Win32_Process  -ComputerName $Server -filter "ProcessID = ‘$($s.ProcessId)’").CreationDate))
      $tmpMatrix.Uptime = $tmpUpTime
    }
    $Matrix += $tmpMatrix
  }
}
  $Matrix

#BlackBerry March 2012 Daylight Savings Time Information

the March 2012 Daylight Savings Time Update will be made public shortly. It includes the following updates:

New Time Zones:

 

Country

Time Zone

DST Start

DST End

Russia

Kaliningrad (GMT +3)*

No Daylight Savings Time

Novosibirsk (GMT +7)*

Samoa

Apia (GMT +13)

Saturday, September 29 at 3:00AM

Sunday, April 1 at 4:00AM

Updated Time Zones:

 

Country

Time Zone

DST Start

DST End

Israel

Jerusalem

Friday, March 30, 2012 at 2:00AM

Sunday, September 23, 2012 at 2:00AM

Chile

Santiago

Midnight between Saturday, September 1 and Sunday, September 2, 2012

Midnight between Saturday, April 28 and Sunday, April 29, 2012

Jordan

Amman (GMT +2)

Midnight between Thursday, March 29 and Friday, March 30, 2012 local standard time

Friday, October 26, 2012 at 1:00 AM

Iran

Tehran (GMT +3:30)

Midnight between Tuesday, March 20 and Wednesday, March 21, 2012

Midnight between Thursday, September 20 and Friday, September 21, 2012

Brazil

Ciuaba (GMT -4)*

Midnight between Saturday, October 20 and Sunday, October 21, 2012

Midnight between Saturday, February 25 and Sunday, Feburary 26, 2012

Fiji

Fiji (GMT +12)*

Sunday, October 21, 2012 at 2:00AM

Sunday, January 22, 2012 at 3:00AM

Belarus

Minsk (GMT +3)

DST has been removed and the GMT offset has been set to +3

Russia

Yerevan

DST has been removed

Note: Ciuaba (GMT -4) has been renamed from Manaus (GMT -4)

#BlackBerry Enterprise Transporter helps make user migration a breeze

Interesting read if you didn’t know

http://www.blackberry.com/newsletters/technicalsupport/solve/2012_03/2012_03_a01.shtml?version=premier&RMID=B2B_201203_Solve_Newsletter&RRID=4B8E2731E77565B2E10000000A50143D

The new BlackBerry® Enterprise Transporter is designed to make BlackBerry smartphone user migration easier, and is an integral part of BlackBerry® Enterprise Server software version 5.0. This article tells you more about the benefits of the BlackBerry Enterprise Transporter and how this enhanced migration tool works.

As your organization grows, BlackBerry smartphone users may be spread across multiple locations. In turn, administration can become a little more challenging. The BlackBerry Enterprise Transporter may help by allowing you to transfer multiple BlackBerry smartphone user accounts from one BlackBerry® Domain to another with little to no impact on, or action required by, your BlackBerry smartphone users – all through one, centralized console.

When to use it

The BlackBerry Enterprise Transporter is designed to allow organizations to migrate BlackBerry smartphone users to the new BlackBerry Enterprise Server v5.0, rather than updating their live environment. This user migration tool can be accessed using either Windows® Explorer or the command prompt window.

You will find the BlackBerry Enterprise Transporter useful when you are migrating BlackBerry smartphone users from:

1 An earlier BlackBerry Enterprise Server software version to BlackBerry Enterprise Server v5.0

2 A production BlackBerry Domain to a test domain and then back again

3 A BlackBerry Enterprise Server v4.x to an empty BlackBerry Enterprise Server v4.x with a new BlackBerry Configuration Database.

Note: The BlackBerry Enterprise Transporter is not recommended for moving BlackBerry smartphone users from a production instance of BlackBerry Enterprise Server v4.x to another production instance of BlackBerry Enterprise Server v4.x Note: Before running the BlackBerry Enterprise Transporter, you must install the BlackBerry User Administration Service.

Using the BlackBerry Enterprise Transporter

There are two methods of migration using the BlackBerry Enterprise Transporter: Live Mode and Bulk Mode. Live Mode is designed to allow you to move BlackBerry smartphone users between two active BlackBerry Enterprise Server instances. Bulk Mode requires the source BlackBerry Enterprise Server instance to be shut down. Generally, administrators prefer to use Live Mode so that they can try to minimize downtime for their BlackBerry smartphone users.

The following steps describe using the Live Mode migration method – the more commonly used method to move one or more BlackBerry smartphone users from an instance of BlackBerry Enterprise Server v4.1.x to a separate BlackBerry Enterprise Server v5.0 instance.

Moving BlackBerry smartphone users to a separate BlackBerry Enterprise Server v5.0

1) Find the UserMigrationTool.exe From the command prompt window, navigate to UserMigrationTool.exe or double-click the UserMigrationTool.exe file to open the BlackBerry Enterprise Transporter.

2) Create a manifest file Under the Configuration tab click the "New" button to create a manifest file. (You can also create your own manifest file using an XML editor)

3) Save the manifest file Click "Save" after you select the name for your manifest file. The manifest file contains information about the BlackBerry Domain instances, default settings, and email addresses that the BlackBerry Enterprise Transporter requires to run the migration process.

4) Configure source database and test connection In the BlackBerry Enterprise Transporter, under the Configuration tab, click "Configuration" under Source Domain. The information you enter here is added to the manifest file created earlier. Click "Test Connection" to validate the connection with the Microsoft® SQL Server® you entered, and then click "Ok".

5) Configure destination database In the BlackBerry Enterprise Transporter, under the Configuration tab, click "Configuration" under Destination Domain. The information you enter here is added to the manifest file created earlier. Click "Test Connection" to validate the connection with the Microsoft SQL Server you entered, and then click "Ok".

6) Configure User Manifest In the BlackBerry Enterprise Transporter, under the Configuration tab, click "Details". Select the destination BlackBerry Enterprise Server name, group name, IT policy, and software configuration. Once you have selected all your options, click the "Find Users" button.

7) Options for Finding BlackBerry smartphone users Select one of three options to search for the BlackBerry smartphone users you want to migrate. Search for BlackBerry smartphone users at the BlackBerry Domain, BlackBerry Enterprise Server, or Enterprise group level. Select the search option you want to use, click "Find". BlackBerry smartphone users are listed under the Users list. Select the BlackBerry smartphone users you want to add, and click the "Add" button. The BlackBerry smartphone users you select appear in the Select Users column. Click "Done" when you have selected all of the BlackBerry smartphone users.

8) View the BlackBerry smartphone users you’ve selected The BlackBerry smartphone users you selected are listed in the User Manifest Configuration screen. Click "Done".

9) View migration information Click the Preview button to view your migration information so far. When a migration preview is successful, you will see a green check mark. If a migration preview fails, you will see a red X.

10) Almost Done! Begin migrating BlackBerry smartphone users Click "Migrate". The Console tab shows you a step-by-step log file that details what the BlackBerry Enterprise Transporter is doing. This information is also written to the log file that is created in the same location as the UserMigrationTool.exe.

There are three configuration options available:

• Turbo Mode – Skips confirmation of IT administration commands

• Trigger Slow Synchronization (SlowSync) – Starts the wireless synchronization of organizer data when the migration process is complete

• Ignore Warnings – Skips validation warnings

11) You’re done! When the migration is complete, you will see a Migration window and a confirmation message.

#BlackBerry Enterprise Server

humm .. BES 5.0.3 MR7 and BES 5.0.4 coming soon?

BlackBerry February 2012 – Daylight Savings Time Update

#BlackBerry

http://www.blackberry.com/btsc/KB29833

The February 2012 Daylight Savings Time (DST) update is cumulative and includes updates to the following Time Zones:

Country Time Zone DST Start DST END
Russia Kaliningrad (GMT +3)

No Daylight Savings Time

Novosibirsk (GMT +4)

Updated Time Zones:

Country Time Zone DST Start DST End
Fiji Fiji (GMT +12) Sunday, October 21, 2012 at 2:00am Sunday, January 22, 2012 at 3:00AM
Brazil Ciuaba (GMT -4) Midnight between October 20 and 21, 2012 Midnight between February 25 and 26, 2012
*Note: Ciuaba (GMT -4) has been renamed from Manaus (GMT -4)

 


Details for Brazil are listed for both Microsoft (Exchange) and IBM (Domino) below:-

Microsoft OS/Exchange Platform

Domino Platform