-
The Clarity Health portlet provides a quick glance into the health of key components and critical jobs in the Clarity environment. The following metrics are monitored: Process Engine Heartbeat should refresh itself every 10 minutes. Process Engine is responsible for the triggering of processes. Green <= 10 Minutes, Yellow 11-15 Minutes, Red > 15 Minutes Time Slices Time Slices are required for accurate reporting. Best practice is for the Time Slicing job to run every minute. Please note there are some jobs that will cause the time slicing to delay so a momentary delay is normal. Green <= 10 Minutes, Yellow 11-15 Minutes, Red > 15 Minutes Datamart Extraction Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours Datamart Rollup Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours Rate Matrix - Full Best practice is to run a full rate matrix nightly Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours Rate Matrix - Incremental Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours Load Data Warehouse - Full Load Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours Load Data Warehouse - Incremental Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours Load Data Warehouse Access Rights Green <= 24 Hours, Yellow 24-48 hours, Red > 48 hours -
This Tech Trick allows the ability to link anywhere within the larity environment from a custom portlet link, even if it is not a standard OOTB link option. For example, you could link to a Departments page or directly to a timesheet even though these are not standard OOTB links to choose from when creating custom portlets. This trick works in Clarity versions 12, 13 , 14 and 15 for both SQL and Oracle environments. -
This document provides an overview of how hierarchical portlets can be exported to MS Excel. The code of a sample hierarchical portlet is explained. The included sample portlet shows a list of projects and the tasks under each project along with actual and assignment hours. The portlet can also be filtered by project and project manager. -
This document provides an overview of how hierarchical portlets can be exported to MS Excel. The code of a sample hierarchical portlet is explained. The included sample portlet shows a list of projects and the tasks under each project along with actual and assignment hours. The portlet can also be filtered by project and project manager. -
The Reset Admin Password technical trick provides the queries necessary to reset the administrator's password via the database. Passwords are forgotten, overwritten and misplaced often; using this technical trick, the support team will always have a back-up plan to gaining back access to the system. -
In many instances, having excess information stored within the database can cause poor performance or slowness when retrieving data. Administrators are always seeking out ways to clean and remove unused information. This technical trick on role removal provides the steps necessary to remove roles that would otherwise be unused and eliminating unwanted information. The Role Removal Technical Trick provides the information for the creation of the following tables and columns which are necessary to perform the role removal:- Role – mapping table
- Tables / Columns that need to be updated with Resource ID fields
- Tables / Columns that need to be updated with Role Code fields
- Tables that will need to be deleted
- PRTEAM table should be checked
-
The Custom Attributes in System portlet displays all of the custom attributes present in the system and the lookup (if applicable) associated with each. This portlet is useful finding a custom attribute on an object, auditing, or for documentation purposes. The user may narrow the results by object, data type, and last updated date. -
The Current Proxies portlet provides a user with an overview of all the resources in the system currently using a proxy. This portlet is helpful to determine a proxy if a user is currently out of the office. The portlet provides several pieces of information related to the resource including: resource names, proxy, start date, end date, days remaining, total days, and if the proxy is active. The user may filter by resource name, proxy name, proxy status (defaults to Yes), and start/end dates (defaults to the current date). -
The Current Proxies portlet provides a user with an overview of all the resources in the system currently using a proxy. This portlet is helpful to determine a proxy if a user is currently out of the office. The portlet provides several pieces of information related to the resource including: resource names, proxy, start date, end date, days remaining, total days, and if the proxy is active. The user may filter by resource name, proxy name, proxy status (defaults to Yes), and start/end dates (defaults to the current date).

