PMO Reports: Customizations Overview

The Customizations Overview report lists content that is not included out-of-the-box with Clarity PPM so we can quickly identify custom content added to Clarity PPM. The report contains database objects such as tables, views, functions, etc. that are not included out-of-the-box with the Clarity PPM schema. The report also contains other types of custom content created in Clarity PPM, such as Studio objects and attributes, NSQL queries, GEL scripts, reports, and jobs. The report is grouped by 'Database Objects' or 'Clarity PPM,' and sub-grouped by the content item type. The following image shows the Customizations Overview report.
The following image shows the Customization Overview report displaying a list of custom database objects
Image displaying the Financial Capitalization by Investment report displaying capital and operating amounts for each investment.
The following image shows the Customization Overview report displaying a list of custom Clarity content.
Image displaying the Financial Capitalization by Investment report displaying capital and operating amounts for each investment.
Report Prerequisites:
There are no prerequisites for this report.
Report Properties:
The following values list the report properties:
  • Name: Customizations Overview
  • Resource ID: CSK_ADM_Customizations
  • Description: Administration (PMO Accelerator)
  • Folder: CA PPM/Reports/Administration/Customizations Overview
  • Path: /ca_ppm/reports/administration/CSK_ADM_Customizations
  • Data Source: CA PPM Bean Data Source
Report Parameter Options
The following table lists the report parameter options
Prompt Text
Parameter Name
           
Type
Input Control Name
Input Control Resource ID
Mandatory
Default Value
Content Type
contentType
Multiple-select
List of Values
Content Type
contentType
No
Content Item
contentItem
Single Value
Text
Content Item
contentItem
No
[Null]
Content Item ID
contentItemID
Single Value
Text
Content Item ID
contentItemID
No
[Null]
Include SQL Query
includeSQLQuer
Boolean
Include SQL Query
investmentManagerKey_1
No
Unchecked
Include Script Text
includeScriptText
Boolean
Include Script Text
includeScriptText
No
Unchecked
UI Theme
ppmUserUITheme
Hidden
Not Applicable
Yes
Passed through Clarity PPM
Language
ppmUserLanguage
Hidden
Not Applicable
Yes
Passed through Clarity PPM
User ID
ppmUser
Hidden
Not Applicable
Yes
Passed through Clarity PPM
Database Vendor
ppmDBVendor
Hidden
Database:
Clarity PPM
Yes
Passed through Clarity PPM
Parameter Lookup Values
The following values list the lookup values:
Content-Type: Attribute, Custom Script, Object, Query, Report, Job, Function, Index, Package, Package Body, Stored Procedure, Table, Trigger, View
Parameter Explanations
The following list describes the parameters:
  • The Content-Type parameter allows you to select which type of custom content or database object to include in the report. The following options are available:
    • Attribute
      –The report includes a list of custom attributes created in Studio Objects in Clarity PPM.
    • Custom Script
      –The report includes a list of custom GEL scripts available in processes.
    • Object
      –The report includes a list of custom Studio objects created in Clarity PPM.
    • Query
      –The report includes a list of custom NSQL queries created in Clarity PPM.
    • Report
      –The report includes a list of custom report definitions created in Clarity PPM.
    • Job
      –The report includes a list of custom job definitions created in Clarity PPM.
    • Function
      –The report includes a list of functions created in the Clarity PPM schema.
    • Index
      –The report includes a list of indexes created in the Clarity PPM schema.
    • Package
      –The report includes a list of packages created in the Clarity PPM schema.
    • Package Body
      –The report includes a list of package body definitions created in the Clarity PPM schema.
    • Stored Procedure
      – The report includes a list of stored procedures created in the Clarity PPM schema.
    • Table
      – The report includes a list of tables created in the Clarity PPM schema.
    • Trigger
      – The report includes a list of triggers created in the Clarity PPM schema.
    • View  –
      The report includes a list of views created in the Clarity PPM schema.
  • The Content Item parameter allows you to select any content item which name matches exactly or partially the name provided. For example, a content item named 'Business Case' is listed if you provide 'Business Case,' 'Business,' 'case,' 'BUS,' etc. as a filter. The Content Item parameter is not case sensitive, and you do not need to use wild card filters.
  • The Content Item ID parameter allows you to select any content item which id matches exactly or partially the id provided. For example, a content item identified as 'business_case' is listed if you provide 'business_case', 'Business', 'case', 'BUS', etc. as a filter. The Content Item ID parameter is not case sensitive, and you do not need to use wild card filters.
  • The Include SQL Query parameter controls whether the code of the NSQL query displays in the report. If the parameter is checked, then the SQL code of any custom NSQL query included in the report displays in the SQL Query/Script Text column. If the parameter is not checked, the SQL code does not display.
  • The Include Script Text parameter controls whether the code of a GEL script displays in the report. If the parameter is checked, then the GEL script code of any custom process included in the report displays in the SQL Query/Script Text column. If the parameter is not checked, the GEL script code does not display.
Report Fields and Calculations
The report displays the content item name and the content item id. If the Include SQL Query parameter is selected, the report displays the code of the corresponding NSQL query in the SQL Query/Script column. If the Include Script Text parameter is selected, the report displays the code of the corresponding GEL script in the SQL Query/Script column. It is recommended to combine other filter options and control the results yelled by the report when selecting these options as they can generate a huge output. The report is grouped by 'Database Objects,' which includes functions, indexes, packages, package bodies, stored procedures, tables, triggers, and views; or by 'Clarity PPM,' which includes Studio objects and attributes, NSQL queries, GEL scripts, reports, and jobs.
Database objects that are registered in the CMN_DB_HISTORY_TABLE during installations and upgrades are not listed by the report. The report excludes NSQL queries that belong to the following add-ins:  Agile Addin, Application Portfolio Management, and Accelerator: Program Management Office;  and NSQL queries used by the Administration Health Report, Log Analysis, and Jobs Monitor portlets.  Studio objects and attributes that belong to the following add-ins: Agile Addin, Application Portfolio Management, and Accelerator: Program Management Office are not listed by the report. Attributes that are marked as System and not marked as custom attributes or have an extended type as 'obs' or 'obs_entity' are not listed by the report. Custom scripts that are Gel Scripts (include 'gel:setDataSource' as part of their code) and are used in processes are listed by the report. When custom scripts are listed, the process name, process code, step name, and step code are provided. Only custom jobs that have SQL Stored Procedure as executable type are listed by the report. Reports and jobs that belong to the following add-ins: Application Portfolio Management and Accelerator: Program Management Office are not listed by the report.
Report Security:
There is no security check in the report query.