Skip Navigation
  1. BlackBerry Docs
  2. BlackBerry AtHoc
  3. BlackBerry AtHoc Integrations
  4. IIM Health Monitoring Installation and Configuration Guide
  5. Configure BlackBerry AtHoc IIM health indication

Configure BlackBerry AtHoc IIM health indication

Prerequisite
The IIM indexURL variable in the 
system_private.config
 file needs to have the <MAC address> extension.
Verify the following before you configure the IIM health monitor in the BlackBerry AtHoc management system:
  1. In the 
    Asset
     tab, check the asset ID and execute the query highlighted in the following image:
    The Asset tab
  2. In the 
    Activity
     tab, check for the asset ID and its activities by executing the highlighted query in the following image: 
    The Activity tab
  3. In 
    SQL Server Management Studio
    , check if the stored procedure [dbo.mtr_iim_poll] is available in 
    ngaddata
     > 
    Programmability
     > 
    Stored Procedure
    . 
    Stored Procedure
USE [ngaddata]
GO                
SET ANSI_NULLS ON
GO                    
SET QUOTED_IDENTIFIER ON
GO                    
IF EXISTS(SELECT 1 FROM sys.procedures where object_id = object_id('dbo.mtr_iim_poll'))<A>column</A>
BEGIN
DROP PROCEDURE dbo.mtr_iim_poll
END
GO                    
CREATE PROCEDURE [dbo].[MTR_IIM_POLL]
@assetId int,
@interval int = 5
as                    
select count (1)  pollcount from [ngaddata].[dbo].[AST_ACTIVITY_TAB] where ASSET_ID = @assetId and
ACTIVITY_NAME = 'CAPNODEPOLL' and 
ACTIVITY_TIME >=  DateAdd(MINUTE, -@interval, GETDATE())
end
go
  4. Right-click the 
    dbo.mtr_iim_poll
     stored procedure.
  5. Click 
    Execute stored procedure...
    .
  6. Specify the value for 
    @assetId
     and 
    @interval
    .
  7. Click 
    OK
    .