Welcome to Port3101.org : Your BES Connection Mark forums read | View Forum Leaders
Port3101.org : Your BES Connection



Reply
LinkBack Thread Tools Display Modes
KB19251 - How to run an audit of administrative actions within BAS
 
  #1 (permalink)  
Old 08-17-2009, 06:10 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default KB19251 - How to run an audit of administrative actions within BAS

KB19251 - How to run an audit of administrative actions within BlackBerry Administration Service


Environment

  • BlackBerry® Enterprise Server version 5.0



Overview

An organization may have a need to report on administrative actions taken within the BlackBerry Administration Service in BlackBerry Enterprise Server version 5.0. An SQL script has been created to fulfill this requirement.
In order to perform an audit on the administrative actions, download the attached script. Anyone with appropriate SQL permissions will be allowed to execute these queries. If required, there are five optional variables that can be modified to further narrow down the query results. To modify these variables, open up the script and look for the following variables:
  • startDate - The date you want the search results to start from
  • endDate - The date you want the search results to end at
  • userId - The ID of the user you want to report on. To find the UserID, open the BASUsers table and match the UserID column to the row of the desired user
  • typeName - The BlackBerry Administration Service plug-in identifier
  • plugInId - The number associated with that BlackBerry Administration Service plug-in identifier
To set the variable to a desired value, simply remove the "--" and insert your desired value. For example, if you want to find all actions for UserID=5 change the script from:
--SET @userId = 10
to
SET @userId = 5
Attached Files
File Type: zip BAS_Audit_SQL_Script.zip (2.2 KB, 78 views)
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
Sponsored Links
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Audit User Additions amagness Port 3101: The BES Admin Bar & Grill 0 07-27-2010 05:47 PM
KB16307 - Actions that the BlackBerry smartphone performs during a BlackBerry wipe hdawg Featured BlackBerry KB Articles 0 09-16-2009 10:20 PM
KB17893 - How to audit the administration functions of the BES hdawg Featured BlackBerry KB Articles 0 07-20-2009 08:09 PM
KB17649 - What are the web addresses for the administrative consoles in BES 5.0 hdawg Featured BlackBerry KB Articles 0 05-26-2009 09:43 AM


All times are GMT -4. The time now is 01:34 AM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2