08-17-2009, 06:10 PM
|
 |
Proprietor
|
|
Join Date: Nov 2008
Posts: 2,238
|
|
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
__________________
http://blog.port3101.org/hdawg/
The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.
|
Linear Mode
