IBM Tivoli Composite Application Manager for Microsoft® Applications: Microsoft

IBM Software Group |
IBM Tivoli Composite Application Manager
for Microsoft® Applications: Microsoft
SQL Server Agent vNext
Disclaimer:
"References in content to IBM products, software, programs, services or associated
technologies do not imply that they will be available in all countries in which IBM
operates. Content, including any plans contained in content, may change at any time
at IBM's sole discretion, based on market opportunities or other factors, and is not
intended to be a commitment to future content, including product or feature availability,
in any way. Statements regarding IBM's future direction or intent are subject to change
or withdrawal without notice and represent goals and objectives only. Please refer to
the developerWorks terms of use for more information. "
2
Microsoft SQL Server Agent vNext
Beta 1
Beta 2
1. Developed 'KoqCtlEditUtility' utility which can edit koqcoll.ctl and
koqtrac.ctl files, users can easily change any settings for
troubleshooting purpose.
1. Added new attributes Cache Hit Ratio and Page Splits / Sec
2. Bundled 'koqclusterUtility' in ITCAMMA installer along with some
new fixes, users can use this for configuring MS SQL Agent in
Cluster.
2. Enhanced option for Monitoring or skipping selected databases so
that user get more flexibility for monitoring desired databases.
3. Following new attribute groups added for the new feature Custom
query monitoring.
1. MS SQL Customized SQL Queries Details
2. MS SQL Customized SQL Result
3. Changed the filegroup space related calculations to support
Aggregate space and Mounted drives for related attributes in
Filegroup.
4. Enhanced the Log free space related attributes in database detail
to support Aggregate space, Mounted drives and Autogrowth.
4. Deprecate the old attributes DataFreeSpace Percent and
promote existing new attribute Aggregate database freespace Pct
attributes in default workspace-database details
5. Added New attributes for monitoring Process Block duration.
6. Added new Attribute Group SQL Audits
7. Added New attributes Device status and Filegroup Status
3
Microsoft SQL Server Agent vNext (Beta 1)
The following features are added for SQL Server Agent vNext release :
1. Developed 'KoqCtlEditUtility' utility which can edit koqcoll.ctl and koqtrac.ctl
files; using this utility users can easily change any settings for troubleshooting
purpose:(Koqtrac tab)
Bundled in ITCAMMA
4
Microsoft SQL Server Agent vNext (Beta 1)
1. Developed 'KoqCtlEditUtility' utility which can edit koqcoll.ctl and koqtrac.ctl
files; using this utility users can easily change any settings for troubleshooting
purpose:(Koqcoll tab)
5
Microsoft SQL Server Agent vNext (Beta 1)
2. Bundled 'koqclusterUtility' in ITCAMMA installer along with some new fixes;
users can use this for configuring MS SQL Agent in Cluster:
Bundled in ITCAMMA
6
Microsoft SQL Server Agent vNext (Beta 1)
3. Following new attribute groups added for the new feature Custom query
monitoring :

MS SQL Customized SQL Queries Details
New navigator item added to
monitor Customized SQL
Queries
7
New workspace “Customized SQL Queries”
which gives summarized information of
Customized SQL queries written in properties file
Microsoft SQL Server Agent vNext (Beta 1)
3. Following new attribute groups added for the new feature Custom query
monitoring :

MS SQL Customized SQL Result
Cross Link from Customized
SQL Queries view to new
linkable workspace
Customized SQL Query
Result
8
Microsoft SQL Server Agent vNext (Beta 1)
4. Enhanced the Log free space related attributes in database detail to
support Aggregate space, Mounted drives and Autogrowth :
9
Microsoft SQL Server Agent vNext (Beta 2)
1.New attributes Plan Cache Hit Ratio and Page Splits / Sec :
10
Microsoft SQL Server Agent vNext (Beta 2)
2. Monitoring or skipping selected databases
11
Microsoft SQL Server Agent vNext (Beta 2)
3. Changing the calculations to support Aggregate space and Mounted drives
for related attributes in Filegroup attribute group
12
Microsoft SQL Server Agent vNext (Beta 2)
4. Deprecate the old attributes DataFreeSpace Percent and promote existing
new attribute Aggregate database freespace Pct
13
Microsoft SQL Server Agent vNext (Beta 2)
5. New attributes for monitoring Process Block duration
Blocking Process Duration(Mins) , Blocking Resource
Type and Blocking Resource Duration(Mins)
14
Microsoft SQL Server Agent vNext (Beta 2)
6. Adding new Attribute Group SQL Audits, so that I can get monitor SQL Audits.
15
Microsoft SQL Server Agent vNext (Beta 2)
7. New attributes Device status and Filegroup Status ,so that user can monitor
offline devices
Device Status
added to provide
the status of a
device.
Filegroup
Status added
to provide the
status of a
Filegroup.
16
IBM Software Group |
IBM Tivoli Composite Application Manager
for Microsoft® Applications: Active Directory
Agent vNext
Microsoft Active Directory Agent vNext


18
New attribute Exhausted RID Percentage added in RID Pool Information
attribute group
New situation

RID_Consumption_crit

RID_Consumption_warn

DC_Response_Time_Crit

New functionality to monitor the Domain controller response time

New functionality to monitor the deleted objects in Domain controller

New functionality to monitor offline domain join functionality

Features under discussion

PIng enable\disable

Active Directory Based activation Monitoring

Dynamic access control events monitoring

Federation service role monitoring
 RID Pool Information attribute group
This attribute group monitors the availability of RID ( Relative identifier) in the
domain which will help user to know the percentage RID exhausted.
New circular gauge is
added for Exhausted RID
Percentage attribute
19
 Domain Controller Response Time Attribute
This will provide the turnaround time to bind and unbind the domain controller.
New attribute Domain
Controller Response
Time is added in Root
Directory Server attribute
group
20
 New situation to monitor Domain Controller Response Time
This will provide an alert if the turnaround time is more than 4000 ms so that
user can troubleshoot the availability of domain.
New situation
DC_Response_Time_Crit is
added to monitor Domain
Controller Response Time.
21
 New history workspace for Domain Controller Response Time
This will provide the trend of availability of domain controller over a period of
last seven days.
New Domain Controller
Response Time History
workspace.
22
 Direct Access Server attribute group
This attribute group monitors the offline domain join functionality of windows
2012.
New view for Direct
Access Server attribute
group.
23
 Modified Replication Directory Partition attribute to support long
domain names
RPL Directory Partition
attribute is updated to
support long domain
names
24
 Added new Warning and Critical situation to monitor RID consumed
percentage
New situation
RID_Consumption_Warn is
added to monitor RID
consumed percentage
25
IBM Software Group |
IBM Tivoli Composite Application Manager
for Microsoft® Applications: Exchange Server
Agent vNext
Microsoft Exchange Server Agent vNext


27
Following new attribute groups are added to enhance the monitoring of
Exchange Server 2013.
.
–
MS Exchange AD Access Forest Discovery
–
MS Exchange Authentication
–
MS Exchange Submission DSN
–
MS Exchange Delivery DSN
–
MS Exchange Submission
–
MS Exchange IS HA Active Database
–
MS Exchange Search Mailbox Operators
–
MS Exchange Search Mailbox Session Cache
–
MS Exchange Workloads
–
MS Exchange Workload Management Policies
Microsoft Exchange Server Agent vNext
–
New features to determine the server performance from the message tracking
logs on Exchange server 2007/2010/2013
–
–
28
MS Exchange Email Statistics
MS Exchange Non Delivery Report
–
Added support for Exchange server 2010 SP3 monitoring
–
Features under discussion (Exchange Server 2013)
–
Site Mailbox monitoring
–
Public Folder Mailbox

MS Exchange AD Access Forest Discovery
This attribute group monitors the activities to discover Active Directory forests on the
Exchange Server.
 MS Exchange Authentication
This attribute group monitors the authentication activities on the Exchange Server such
as authentication of mail users, Outlook Web Access (OWA) users etc.
29
 MS Exchange Submission DSN
This attribute group monitors the delivery status notifications (DSNs) for messages that
are sent to the mailbox transport submission service on the Exchange Server.
 MS Exchange Delivery DSN
This attribute group monitors the delivery status notifications (DSNs) for messages
that are sent to the mailbox transport delivery service on the Exchange Server.
30
 MS Exchange Submission
This attribute group monitors the submission of messages from the Mailbox Server to
the Hub Transport server.
 MS Exchange IS HA Active Database
This attribute group monitors the availability of active mailbox databases on the
Exchange Server.
31
 MS Exchange Search Mailbox Operators
This attribute group monitors the interactions between the Content Transformation
service and the mailboxes on the Exchange Server.
 MS Exchange Search Mailbox Session Cache
This attribute group monitors the cache activities that occur when you search contents
on the Exchange Mailbox Server.
32
 MS Exchange Workloads
This attribute group monitors the Exchange Workloads that are currently defined on
the Exchange Server.
33
 MS Exchange Workload Management Policies
This attribute group monitors the Workload Management Policies that are
currently applied to the Exchange Servers in the organization.
34
 MS Exchange Email Statistics
This attribute group monitors monitor total email sent and received and total
bytes sent and received.
35
 MS Exchange Non Delivery Report
This attribute group monitors the monitors the mailboxes which are full and due
to this mail delivery is failed to those mailboxes.
36
IBM Software Group |
IBM Tivoli Composite Application Manager
for Microsoft® Applications: Microsoft .Net
Framework Agent vNext
Microsoft .NET Framework Agent vNext
Enhanced .NET Framework Agent VvNext to fully support .NET
Framework v 4.5
Provided support to monitor MVC Applications via the existing
ASP.NET Applications navigator item
 All the (applicable) attribute groups under ASP.NET Applications
navigator item can now monitor MVC Applications built on top of
ASP.NET Framework.
38
Microsoft .NET Framework Agent vNext
Enhanced .NET Framework Agent VvNext to fully support .NET
Framework v 4.5
Added a new Attribute Group to facilitate monitoring of WebSockets
feature of .NET Fr 4.5
 This attribute group provides information about 32-bit & 64-bit ASP.NET
Application instances that use WebSocket protocol for communication.
Added a new workspace to show WebSocket related data
 This workspace provides information about the requests that are made
to the ASP.NET applications by using the WebSocket protocol.
 This workspace contains 2 views, one report and one bar-chart view.
39
Microsoft .NET Framework Agent vNext – under
discussion features
Features planned to be added in Sprint-6
 Monitoring of Windows NT services that are built using .NET Fr
40
IBM Software Group |
IBM Tivoli Composite Application Manager
for Microsoft® Applications: Microsoft Hyper-V
Agent vNext
Microsoft Hyper-V Agent vNext

New attribute groups added to monitor VM Replication feature of
Windows Server 2012:
– Hyper_V_Replica_VM
– Hyper_V_Replication_Statistics

New situations added to alert user about replication health of VM:
– VM_Replication_Health_Crit
– VM_Replication_Health_Warn

New workspace added to show VM Replication related data:
– VM Replication

New attribute group added to monitor VM Storage Migration
feature of Windows Server 2012:
– VM_Storage_Migration
42
Microsoft Hyper-V Agent vNext

New situation added to alert user about successful storage
migration of VM:
– HV_StorageMigrate_Info

New workspace added to show VM Storage Migration related data:
– VM Storage Migration

New attribute group added to monitor Hyper-V Server Disk:
– Hyper_V_Server_Disk

New attribute group added to monitor Hyper-V Server Network
Interface:
– Hyper_V_Server_Network_Interface
43
Microsoft Hyper-V Agent vNext
 New views added to Hypervisor workspace to show data related to
Hyper-V Server Disk and Hyper-V Server Network Interface:
–Hyper-V Server Disk
–Hyper-V Server Network Interface
 Modified Hyper_V_Dynamic_Memory_VM attribute group to
enhance monitoring of Dynamic Memory feature.

New services added in Hyper-V Agent to monitor new Hyper-V
Services added in Windows Server 2012.
44
Microsoft Hyper-V Agent vNext
 New attribute group added to monitor migration of VMs in nonclustered environment:
–VM_Mig_WO_Cluster
 New view added to VM Modification workpace to show data related
to migration of VMs in non-clustered environment:
–VM Migration without Cluster

New situation added to alert user about successful migration of
VM in non-clustered environment:
–HV_VMMig_WO_Cluster_Info
45
IBM Software Group |
IBM Tivoli Composite Application Manager
for Microsoft® Applications: IIS Agent vNext
Microsoft IIS Agent vNext (Beta 2)
 Provided MSMQ Outgoing HTTP Session attribute groups to monitor
 Designed 2 new workspaces to show details of below features of IIS.
– HTTP Service
– Error response
–
Virtual domain
– Centralized certificate
47
MSMQ HTTP Traffic Statistics Workspace
48
Virtual Domain and Centralized Certificate Setting Workspace
49
HTTP Request Queue and Error Response Statistics Workspace
50
Microsoft IIS Agent vNext (Beta 1)
 Provided new attribute groups to monitor:
– Failed Request Tracing
– HTTP Error Response
– HTTP Service Request Queues
51
 New Workspaces
– Failed Request Tracing Statistics
52
Features under discussion
• Modification of some event based situation description to support IIS 8.
53
IBM Software Group |
IBM Tivoli Composite Application Manager
for Microsoft® Applications: HIS Agent vNext
HIS Agent vNext
• Addition of 4 new attribute groups in order to monitor Distributed Link
Services, Configured users, Local and remote APPC LUs.
 SNA_LU_AppcLocal
 Link_Service_Distributed
 SNA_LU_AppcRemote
 SNA_Configured_Users
• Addition of new view in Link Service Statistics workspace: Link Service
Distributed Status.
• Addition of new view in Status and Configuration workspace: SNA Configured
Users.
•
Addition of new Workspace in Status and Configuration Navigator item: SNA LU
APPC Local and Remote.
55
HIS Agent vNext
•
New situation is added in order to monitor SNA Server status.
 KQH_SNA_Server_Unreachable
•
Addition of new link service in Availability attribute group.
 Distributed link service
56
IBM Software Group |
IBM Tivoli Composite Application Manager
for Microsoft® Applications: BizTalk Agent vNext
BizTalk Agent vNext (Beta 1)
1. Addition of 2 new attribute groups in order to monitor SFTP adapter introduced in
BizTalk Server 2013.


SFTP Receive Adapter
SFTP Send Adapter
2. New workspace added in Adapter navigator item: SFTP Receive Adapter
58
BizTalk Agent vNext (Beta 1)
3. New workspace added in Adapter navigator item: SFTP Send Adapter.
59
BizTalk Agent vNext (Beta 2)
4. Addition of a new attribute group in order to monitor receive ports of BizTalk Server.
 Receive Ports: It consists of following attributes:
1) Receive Port Name:
2) Primary Receive Location
3) Is Two Way
4) Route Failed Message
60
BizTalk Agent vNext (Beta 2)
5. New view added Server to the „Current Status‟ workspace to monitor receive ports of
BizTalk Server: Receive Ports
61
BizTalk Agent vNext (Beta 2)
6. Added following new take actions, so that BizTalk Server artifacts can be controlled by
BizTalk Server Administrator.
1)
2)
3)
4)
5)
6)
7)
8)
Enlist Send Port: Enlists the send port selected by the user.
Unenlist Send Port: Unenlists the send port selected by the user.
Enlist Send Port Group: Enlists the send port group selected by the user.
Unenlist Send Port Group: Unenlists the send port group selected by the user.
Enlist Orchestration: Enlists the Orchestration selected by the user.
Unenlist Orchestration: Unenlists the Orchestration selected by the user.
Stop Orchestration: Stops the orchestration that is selected by the user.
Disable Receive Location: Disables the receive location that is selected by the user.
1.
2.
3.
1.
2.
Enlist Orchestration
Unenlist Orchestration
Stop Orchestration
Enlist Send Port
Unenlist Send Port
1.
62
1.
2.
Disable Receive
Location
Enlist Send Port Group
Unenlist Send Port Group
IBM Software Group |
IBM Tivoli Composite Application Manager
for Microsoft® Applications: Microsoft Lync
Server Agent vNext
Microsoft Lync Server Agent vNext
Added the workspace to consume performance monitoring data related to
Response Group Service.
 Response Group Service contains 2 modules as follows •
Call hosting Summary (hosting framework) – handle the incoming call and create a
new instance of a workflow
•
Workflow Summary – determines the actions that are taken when the Response
Group receives a phone call.
 This service create and manage response group(s) to route and queue
incoming call to agents (or any Sip Uri)
64
Microsoft Lync Server Agent vNext
Monitoring an Autodiscover Service Attribute Group to support Lync Server 2010
and Lync Server 2013.
 This provides information about the Autodiscover Service module of Lync
Server which is used to support Lync mobile applications on mobile devices.
Added 2 new Availability situations to support Lync Server 2013
 Lync Server Centralized Logging Service Agent
 Lync Server XMPP Translating Gateway
Added 4 new take action commands to support Lync Server 2013
 Start/Stop Lync Server Centralized Logging Service Agent
 Start/Stop Lync Server XMPP Translating Gateway
65
Microsoft Lync Server Agent vNext
Features under discussion:Adding a workspace to consume performance monitoring data related to User
Services database store.
 Monitoring User service component that are related with database access
component and local registrar of Lync Server Registrar Module
66
•
User Services DBstore
•
User Services Registrar DBStore
IBM Software Group |
IBM Tivoli Composite Application Manager
for Microsoft® Applications: Microsoft Cluster
Server Agent vNext
Microsoft Cluster Server Agent vNext
Added new attribute group CAU Current Run.
 CAU Current Run Status provides the information of current update run executing on the cluster. It
includes information such as current owner of the update run, no of installed updates, canceled updates,
failed updates on node.
Added following situations to monitor ‘Cluster Aware Updating Run’
 KQ5_CAU_Offline
 KQ5_CAU_Failed
Added following situations to monitor important Cluster events
 KQ5_CLUSTER_BACKUP_ABORTED
 KQ5_SHARED_DISK_MISSING
 KQ5_CLSTR_SERVICE_SHUTTING
 KQ5_CSV_ACCESS_ERROR
 KQ5_CLUSTER_DISK_CORRUPT
68
Microsoft Cluster Server Agent vNext
Added new attribute group CAU Configuration.
 This attribute group provides information about Cluster Aware Configuration. CAU Configuration provides
details that are used by CAU for performing update run. It includes information such as resource group
name of CAU, owner node, type of updates, update parameters, node order in which update will be
installed, CAU update run frequency etc.
Added new attribute group CAU Last Run.
 CAU Last Run provides the information of last update run executed on cluster nodes. It contains
information such as Node name on which update installed, update name, time taken for update, Update
description, Status of the update.
APAR fixes.
 APAR IV4260 : Issue is fixed when quorum data is not fetched for unformatted quorum disk.
69
Microsoft Cluster Server Agent vNext
Features Under discussion:
Virtual machine application monitoring in hyper-V cluster.
OSLC support for agent.
70
IBM Software Group |
IBM Tivoli Composite Application Manager
for Microsoft® Applications: Microsoft
SharePoint Agent vNext
Microsoft SharePoint Agent vNext
Modified SharePoint Roles Attribute Group to support SharePoint 2013.
 This attribute group provides information about roles configured in the
SharePoint Server.
Modified Active Crawls Attribute Group to support SharePoint 2013.
 This attribute group provides information about the Active Crawls of the
SharePoint Server
Modified Last Crawls Attribute Group to support SharePoint 2013.
 This attribute group provides information about the Last Crawls of the
SharePoint Server
Modified Crawl History Attribute Group to support SharePoint 2013.
 This attribute group provides information about the History of Crawls
completed.
72
Microsoft SharePoint Agent vNext
Modified following Situations to support SharePoint 2013:
 KQP_BLOB_Cache_High
 KQP_Crawl_Error_High
 KQP_DB_Connection_Lost
 KQP_ECS_Active_Sessions
 KQP_Health_Analyzer_Error
 KQP_WSS_Tracing_Service_Down
 KQP_Service_Application_Err
 KQP_SP_Doc_Delayed_Retry
 KQP_SP_Publish_CacheHitRatio
 KQP_SP_RTB_SystemIOTraffic
73
Microsoft SharePoint Agent vNext
Added following Situations to monitor SharePoint 2013 :
 KQP_SP_Timer_Service_Down
 KQP_SP_Admin_Service_Down
 KQP_OSearch_Service_Down
74
Microsoft SharePoint Agent vNext
Added following Attribute Groups to monitor Education Services of
SharePoint 2013 :
 Education Services :Data Access Layer
This attribute group provides information about Data Access Requests for
Education Services
 Education Services :Data Access Application Layer
This attribute group provides information about Application Access Requests
for Education Services Applications.
 Education Services :Copy Operations
This attribute group provides information about Education Services Entity's
Copy Operation statistics (i.e. Copy Failures, Copy duration etc.).
75
Microsoft SharePoint Agent vNext
Added following Attribute Groups to monitor Education Services of
SharePoint 2013 :
 Education Services :Education Data Service
This attribute group provides information about Sessions accessing
Education Services.
 Education Services :Sites
This attribute group provides information about Sites provisioned for
Education Services (i.e. No. of sites provisioned, site provision failures).
 Education Services :User Data Cache
This attribute group provides information about User Data Cache for
Education Services.
76
Microsoft SharePoint Agent vNext
Features Under Discussion:
 SharePoint Agent configuration parameters validation.
77
IBM Software Group |
IBM Tivoli Composite Application Manager
for Microsoft® Applications vNext :
.NET Data Collector vNext
ITCAMMA vNext - .NET Data Collector vNext
 Beta-2
– Config UI Tool
– ASP.NET MVC
– Support for WCF services
created using
netTcpBinding
– Support for displaying
Failed Transactions
– Support for transactions
involving
Server.TransferRequest
method
79
 Beta-1
– Support for methods
which are internally using
multiple return statements
e.g. LDAP Async API
Failed Transactions (Beta-2)
80
ASP.NET MVC (Beta-1)
SQL SERVER
Database
MVC app
deployed in IIS
Web Service
81
LDAP Async API (Beta-1)
Internal call for
authentication
App with multiple
return statement
deployed in IIS
Active
Directory
82
IBM Software Group |
IBM Tivoli Composite Application Manager
for Microsoft® Applications vNext : Tivoli
Common Reporting (Cognos)
Beta 2 Demo
Features List
– vNext compliant data models for MSCS, BizTalk, .NET, HIS and SP agents
– Introduced prerequisite scanner reports in all 11 agents
– Added 24 new cognos reports
vNext Compliant Data Model : We have planned vNext compliant datamodels for all 11 agents in this release. Till now we have modified models for MSCS,
BizTalk, .NET, HIS and SP agents. These data-models are enhanced for the new
attribute groups and attributes introduced in agents in the current release.
Modified for the
new attribute
groups/attribute
s added in the
current release
NOTE: Development for the vNext compliant data-models for the remaining 6 agents is in
progress.
New Predefined Cognos Reports in vNext: Introduced couple of
new reports in BizTalk, HIS, .NET, MSCS and SP agents. Here is the list :
 BizTalk Agent
– BizTalk Adapters Performance – Messages Sent report
– BizTalk Adapters Performance – Messages Received report
– BizTalk Receive Adapters Message Activity report
– BizTalk Send Adapter Message Activity report
 HIS Agent
– Commit and Rollback Details report
– Response Unit (RU) Transfer Stats on TN3270 Server report
– Managed Application Integration Calls and Errors Rate report
– Data on SNA Connection and Logical Unit Sessions report
– Session Integrator Server PLUs Detail report
 .NET Agent
– Top .NET Applications by Performance for Multiple Resources report
– Request Status Summary by Server Name report
– Connection Cycle Details report
– Security Calls Details report
– Resource Utilization Comparisons for .NET Applications report
New Predefined Cognos Reports in vNext(Continued…)
 SharePoint Agent
– Shared Service Provider Performance report
– InfoPath Forms Memory Usage report
– SharePoint Publishing Cache Utilization report
– Document Conversion Status Details report
– Excel Services Performance Trend report
 MSCS Agent
– Network Interface Activity for Single Cluster Node report
– Resource Utilization Comparison for All Nodes on Single Cluster report
– Cluster Nodes Utilization Summary report
– Cluster Resource Availability report
– Message/Byte Sent/Received on Cluster Server Network report
NOTE: Development of New reports for the remaining 6 agents is in progress.
Security Calls Details report: Displays the unauthorized and
unauthenticated failed security calls for the three types of service models: Service,
Operation and Endpoint, across the servers.
Request Status Summary by Server Name report: Displays
the overall request performance by different ASP .NET applications.
Top .NET Applications by Performance for Multiple Resources report:
Displays the time spent by all applications in garbage collection, the number of
exceptions thrown, and the runtime code access security checks on different servers..
Prerequisite Scanner reports: We have introduced prerequisite
scanner reports for all 11 agents in vNext release. The reports are –
– IIS Agent Reports Prerequisites Scanner
– MSCS Agent Reports Prerequisites Scanner
– HV Agent Reports Prerequisites Scanner
– BizTalk Agent Reports Prerequisites Scanner
– Lync Server Agent Reports Prerequisites Scanner
– Active Directory Agent Reports Prerequisites Scanner
– .NET Agent Reports Prerequisites Scanner
– HIS Agent Reports Prerequisites Scanner
– SP Agent Reports Prerequisites Scanner
– SQL Agent Reports Prerequisites Scanner
– Exchange Agent Reports Prerequisites Scanner
NOTE: The prerequisite scanner reports are updated for the new predefined reports introduced
in vNext release for MSCS, BizTalk, .NET, HIS and SP agents. The scanner reports for the
remaining agents will be updated once new predefined reports are ready for these agents.
Prerequisite Scanner
 Provides a prerequisite scanner that checks if the list of all tables/views needed to
run the predefined reports are available in the Tivoli Data Warehouse.
 Points you to appropriate documentation which can be helpful in enabling historical
collection and summarization and pruning, creating IBM_TRAM schema, Time
Dimension and other shared dimensions and populating Time dimension.
Consider a few use cases like :
 How will a user find out if his warehouse has all the tables/views needed to run a
report?
 While running a predefined report, user encounter an error like :
"RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions‘
status='-201'. UDA-SQL-0196 The table or view "ITMUSER.KQFSERMSER_DV" was not found
in the dictionary. "
In such cases, user will use this Prerequisite Scanner report. This report will run against
DB2/Oracle/SQL database to check if all the prerequisite tables/views are available in the
TDW.
in spite of having all the prerequisite tables/views in the TDW, user may not be able to run
the reports due to insufficient data in the warehouse. For instance, this may happen if
he/she does not have adequate timestamps generated for the Time Dimension. The
documentation provided will help him in running the appropriate database scripts to
populate the tables.
Prerequisite Scanner (Continued…)
1. Database Type can be as DB2 OR Oracle OR SQL
2. Report Type as Show falling sections
only (reports for which no table or view exists in
TDW) OR Show all sections ( for all reports)
3. Summarization Type as Hourly, Daily,
Weekly and so on OR All
Prerequisites for TCR Shared
dimensions like
WEEKDAY_LOOKUP,
MONTH_LOOKUP etc.
Legend
information
Prerequisite Scanner (Continued…)
Lists all the prerequisite tables/views and shows a status against each of them.
Report-wise
prerequisite
information
modified for the
new reports
introduced in
upcoming release
Thank You !!!
95