Recursive Rules Vault

[Home] Welcome to The Recursive Rules Vault

login:
password:

Latest News
Virtual Administrator 2 has been released!

About
You are not logged in. The Recursive Rules Vault is designed to be a place where users can share the analysis rules and statistics they have created.

If you log in, you can search through the Analysis Rules and statistics, as well as download them. To recieve a log in, you must be a VA2 trial member or supported customer.

The list below is a non downloadable list of of availible Anlysis Rules and Statistics.

Component Reached Max Tasks: Alert if any component in the Enterprise has reached maximum tasks. Must set the Enterprise Name for it to function.
------------------------------------
Transaction Backlog: Sends Alert if there is a Transaction Backlog. For SQL Server.
------------------------------------
DB Size - SiebelDB -SQL Server: Returns the Database size in MB for SQL Server for the Siebel Database. Must use a DB Administator role.
------------------------------------
DB Size - Vadmin21 -SQL Server : Returns the Database size in MB for the Vadmin21 DB. Must use a Administator DB User.
------------------------------------
Number of DB Users - SQL Server: Number of DB Users at any one time. Strips out SADMIN and sa Users. Returns number of users for all Databases. Needs DB Administrator user to execute.
------------------------------------
Number of Records in S_DCK_TXN_LOG. : An incrementing number indicates a problem in routing transactions for mobile clients.
------------------------------------
S_ESCL_REQ Backlog - SQL Server: Returns the number of Workflow rule records that are waiting to be executed. An increasing or steadily high number indicates that there is a problem with Workflow execution. Uses MSSQL time function.
------------------------------------
Number of Expired Workflow Rules - SQL Server: Returns the number of expired Workflow Rules. Expired rules will cease to function in Siebel.
------------------------------------
Number of Contacts: Returns number of Contacts
------------------------------------
Number of Accounts: Number of Accounts
------------------------------------
Number of Activities: Returns number of Activities. Number of Activities is a standard sizing measurement for Siebel as Activities are used in so many objects.
------------------------------------
Number of Opportunities: Returns total from S_OPTY
------------------------------------
Transaction Router Check: Determine whether the Transaction Router component is either Online or Running.
------------------------------------
Transaction Processor Check: Determine whether the Transaction Processor component is either Online or Running.
------------------------------------
Transaction Merger Check: Determine whether the Transaction Merger component is either Online or Running. Must change Enterprise Name.
------------------------------------
eChannel Object Manager: Determine whether the eChannel Object Manager component is either Online or Running. Must change Enterprise Name.
------------------------------------
eSalesObject Manager Check: Determine whether the eSalesObject Manager component is either Online or Running. Must change Enterprise Name.
------------------------------------
Workflow Action Agent Check: Determine whether the Workflow Action Agent component is either Online or Running. Must change Enterprise Name.
------------------------------------
Workflow Processor Check: Determine whether the Workflow Processor component is either Online or Running. Must change Enterprise Name.
------------------------------------
Workflow Monitor Check: Determine whether the Workflow Monitor Agent component is either Online or Running. Must change Enterprise Name.
------------------------------------
Disk Use Alarm: Generates event if the percentage of any disk on the specified host has less than 10% space availible. Must set the $Machine name parameter. Can adjust the 10% to any desired percent.
------------------------------------
Sql Timer - S_ASSET count: This rule returns the number of seconds it takes to execute a count(*) on the S_ASSET table.
------------------------------------
Is Workflow Mon Task running: Determines whether a particular task is running in the enterprise. Checking for a Task that is running is more appropriate for Workflow Monitor Agent than checking component availblity. This rule can be modified to check for any task. Must set the $enterprise parameter.
------------------------------------
Is Transaction Router Task running: Determines whether a particular task is running in the enterprise. Checking for a Task that is running is more appropriate for Transaction Router than checking component availblity. This rule can be modified to check for any task. Must set the $enterprise parameter. Set the $compname parameter to customize the rule to a different task.
------------------------------------
Is Transaction Router Task running: Determines whether a particular task is running in the enterprise. Checking for a Task that is running is more appropriate for Transaction Merger than checking component availblity. This rule can be modified to check for any task. Must set the $enterprise parameter. Set the $compname parameter to customize the rule to a different task.
------------------------------------
Is Transaction Processor Task running: Determines whether a particular task is running in the enterprise. Checking for a Task that is running is more appropriate for Transaction Processor than checking component availblity. This rule can be modified to check for any task. Must set the $enterprise parameter. Set the $compname parameter to customize the rule to a different task.
------------------------------------
Number of Days until XMAS: Returns number of days until XMAS 2002
------------------------------------
Memory Use: Graphs the memory use of the $host specified - as seen in Windows Task Manager. Uses WMI. Remember that the Central Service must have administrative rights to the $host to collect WMI info.
------------------------------------
Expired Workflow Rules: Finds records in S_ESCL_REQ that have expired workflow rules, meaning they will never be processesed. Has a time function that can be set for Oracle or SQL server.
------------------------------------
S_ESCL_REQ backlog per policy by date - Oracle: This Analysis rule checks for a particular policy id for backlogs. Must set the $rulid variable. It also gives a one day lag time, so only looks for records that are more than a day old for policy X. Made for you really business critical workflow policies, where there should be no backlog. Created by Anil Talekar.
------------------------------------
Siebel Component CPU tracker: Tracks the CPU use over time by a Siebel component. Can graph kernel, user, or total CPU time of Siebel processes
------------------------------------
Siebel Componenent Memory tracker: Tracks memory use of Siebel component specified. Must set the Enterprise and Component alias.
------------------------------------
Siebel Application server memory use: Tracks memory of all processes and coponents associated with a Siebel appserver.
------------------------------------
Used Disk Space: Statistic for tracking the amount of Disk space in Gigs on C drive. Need to change the $Machine variable. Need to have WMI service enabled on the host.
------------------------------------