Columns from the Executive Analysis Report Template

The table below lists queries and the columns from each query available for use in the Executive Risk Report template. The query name is in bold with the available columns listed directly below it, and a description is provided on the right for each entry.

 

Executive Analysis Report

Query/Columns

Description

AllControlsPSRGroupedByRisk

This query groups columns that display information on the PSR scores for all controls included in the scope of a report.

PercentHighRisk

Displays the PSR score for all controls in the High range divided by the total PSR score of all the controls in all ranges, expressed as a percentage.

PercentLowRisk

Displays the PSR score for all controls in the Low range divided by the total PSR score of all the controls in all ranges, expressed as a percentage.

PercentMediumRisk

Displays the PSR score for all controls in the Medium range divided by the total PSR score of all the controls in all ranges, expressed as a percentage.

PercentTotal

Displays the PSR score for all controls divided by the total PSR score of all the controls. This is used to ensure that totals appearing in queries have been calculated correctly.

PercentVeryHighRisk

Displays the PSR score for all controls in the Very High range divided by the total PSR score of all the controls in all ranges, expressed as a percentage.

PercentVeryLowRisk

Displays the PSR score for all controls in the Very Low range divided by the total PSR score of all the controls in all ranges, expressed as a percentage.

PSRHighRisk

Displays the PSR score for all controls in the High range.

PSRLowRisk

Displays the PSR score for all controls in the Low range.

PSRMediumRisk

Displays the PSR score for all controls in the Medium range.

PSRTotal

Displays the PSR score for all controls.

PSRVeryHighRisk

Displays the PSR score for all controls in the Very High range.

PSRVeryLowRisk

Displays the PSR score for all controls in the Very Low range.

AllControlsQuantityGroupedByRisk

This query groups columns that display information on all the controls included in the scope of a report.

PercentualOfHighRisk

Displays the number of controls with PSR scores in the High range divided by the total number of controls, expressed as a percentage.

PercentualOfLowRisk

Displays the number of controls with PSR scores in the Low range divided by the total number of controls, expressed as a percentage.

PercentualOfMediumRisk

Displays the number of controls with PSR scores in the Medium range divided by the total number of controls, expressed as a percentage.

PercentualOfVeryHighRisk

Displays the number of controls with PSR scores in the Very High range divided by the total number of controls, expressed as a percentage.

PercentualOfVeryLowRisk

Displays the number of controls with PSR scores in the Very Low range divided by the total number of controls, expressed as a percentage.

QuantityOfHighRisk

Displays the number of controls with PSR scores in the High range.

QuantityOfLowRisk

Displays the number of controls with PSR scores in the Low range.

QuantityOfMediumRisk

Displays the number of controls with PSR scores in the Medium range.

QuantityOfVeryHighRisk

Displays the number of controls with PSR scores in the Very High range.

QuantityOfVeryLowRisk

Displays the number of controls with PSR scores in the Very Low range.

TotalPercentual

Displays the total percentage of controls. This is used to ensure that totals appearing in queries have been calculated correctly.

TotalQuantity

Displays the total number of controls included in the scope of a report.

ApplicableControlsPSRGroupedByRisk

This query groups columns that display information on the PSR scores for all applicable controls included in the scope of a report.

PercentHighRisk

Displays the PSR score for all applicable controls in the High range divided by the total PSR score of all applicable controls in all ranges, expressed as a percentage.

PercentLowRisk

Displays the PSR score for all applicable controls in the Low range divided by the total PSR score of all applicable controls in all ranges, expressed as a percentage.

PercentMediumRisk

Displays the PSR score for all applicable controls in the Medium range divided by the total PSR score of all applicable controls in all ranges, expressed as a percentage.

PercentTotal

Displays the PSR score for all applicable controls divided by the total PSR score of all applicable controls, expressed as a percentage. This is used to ensure that totals appearing in queries have been calculated correctly..

PercentVeryHighRisk

Displays the PSR score for all applicable controls in the Very High range divided by the total PSR score of all applicable controls in all ranges, expressed as a percentage.

PercentVeryLowRisk

Displays the PSR score for all applicable controls in the Very Low range divided by the total PSR score of all applicable controls in all ranges, expressed as a percentage.

PSRHighRisk

Displays the PSR score for all applicable controls in the High range.

PSRLowRisk

Displays the PSR score for all applicable controls in the Low range.

PSRMediumRisk

Displays the PSR score for all applicable controls in the Medium range.

PSRTotal

Displays the total PSR score for all applicable controls.

PSRVeryHighRisk

Displays the PSR score for all applicable controls in the Very High range.

PSRVeryLowRisk

Displays the PSR score for all applicable controls in the Very Low range.

ApplicableControlsQuantityGroupedByRisk

This query groups columns that display information on all the applicable controls included in the scope of a report.

PercentualOfHighRisk

Displays the number of applicable controls with PSR scores in the High range divided by the total number of applicable controls, expressed as a percentage.

PercentualOfLowRisk

Displays the number of applicable controls with PSR scores in the Low range divided by the total number of applicable controls, expressed as a percentage.

PercentualOfMediumRisk

Displays the number of applicable controls with PSR scores in the Medium range divided by the total number of applicable controls, expressed as a percentage.

PercentualOfVeryHighRisk

Displays the number of applicable controls with PSR scores in the Very High range divided by the total number of applicable controls, expressed as a percentage.

PercentualOfVeryLowRisk

Displays the number of applicable controls with PSR scores in the Very Low range divided by the total number of applicable controls, expressed as a percentage.

QuantityOfHighRisk

Displays the number of applicable controls with PSR scores in the High range.

QuantityOfLowRisk

Displays the number of applicable controls with PSR scores in the Low range.

QuantityOfMediumRisk

Displays the number of applicable controls with PSR scores in the Medium range.

QuantityOfVeryHighRisk

Displays the number of applicable controls with PSR scores in the Very High range.

QuantityOfVeryLowRisk

Displays the number of applicable controls with PSR scores in the Very Low range.

TotalPercentual

Displays the number of all applicable controls divided by the total number of all applicable controls, expressed as a percentage. This is used to ensure that totals appearing in queries have been calculated correctly.

TotalQuantity

Displays the total number of applicable controls included in the scope of a report.

AvoidedControlsPSRGroupedByRisk

This query groups columns that display information on the PSR scores for all implemented controls included in the scope of a report.

PercentHighRisk

Displays the PSR score for all implemented controls in the High range divided by the total PSR score of all implemented controls in all ranges, expressed as a percentage.

PercentLowRisk

Displays the PSR score for all implemented controls in the Low range divided by the total PSR score of all implemented controls in all ranges, expressed as a percentage.

PercentMediumRisk

Displays the PSR score for all implemented controls in the Medium range divided by the total PSR score of all implemented controls in all ranges, expressed as a percentage.

PercentTotal

Displays the PSR score for all implemented controls divided by the total PSR score of all implemented controls, expressed as a percentage. This is used to ensure that totals appearing in queries have been calculated correctly.

PercentVeryHighRisk

Displays the PSR score for all implemented controls in the Very High range divided by the total PSR score of all implemented controls in all ranges, expressed as a percentage.

PercentVeryLowRisk

Displays the PSR score for all implemented controls in the Very Low range divided by the total PSR score of all implemented controls in all ranges, expressed as a percentage.

PSRHighRisk

Displays the PSR score for all implemented controls in the High range.

PSRLowRisk

Displays the PSR score for all implemented controls in the Low range.

PSRMediumRisk

Displays the PSR score for all implemented controls in the Medium range.

PSRTotal

Displays the total PSR score for all implemented controls included in the scope of a report.

PSRVeryHighRisk

Displays the PSR score for all implemented controls in the Very High range.

PSRVeryLowRisk

Displays the PSR score for all implemented controls in the Very Low range.

AvoidedControlsQuantityGroupedbyRisk

This query groups columns that display information on the implemented controls included in the scope of a report.

PercentualOfHighRisk

Displays the number of implemented controls with PSR scores in the High range divided by the total number of implemented controls, expressed as a percentage.

PercentualOfLowRisk

Displays the number of implemented controls with PSR scores in the Low range divided by the total number of implemented controls, expressed as a percentage.

PercentualOfMediumRisk

Displays the number of implemented controls with PSR scores in the Medium range divided by the total number of implemented controls, expressed as a percentage.

PercentualOfVeryHighRisk

Displays the number of implemented controls with PSR scores in the Very High range divided by the total number of implemented controls, expressed as a percentage.

PercentualOfVeryLowRisk

Displays the number of implemented controls with PSR scores in the Very Low range divided by the total number of implemented controls, expressed as a percentage.

QuantityOfHighRisk

Displays the number of implemented controls with PSR scores in the High range.

QuantityOfLowRisk

Displays the number of implemented controls with PSR scores in the Low range.

QuantityOfMediumRisk

Displays the number of implemented controls with PSR scores in the Medium range.

QuantityOfVeryHighRisk

Displays the number of implemented controls with PSR scores in the Very High range.

QuantityOfVeryLowRisk

Displays the number of implemented controls with PSR scores in the Very Low range.

TotalPercentual

Displays the number of all implemented controls divided by the total number of all implemented controls, expressed as a percentage. This is used to ensure that totals appearing in queries have been calculated correctly.

TotalQuantity

Displays the total number of implemented controls included in the scope of a report.

BussinesComponentControlsGroupedByRisk

This query groups columns that display information on a strategic or tactical business component included in the scope of a report.

Index

Displays a sequential number for each business component, starting from 0001. This number is concatenated with the section number for the report for organizational purposes.

Name

Displays the name of a strategic or tactical business component.

PercentualOfPSROfHighRisk

Displays the PSR score for the non-implemented controls in the High range divided by the total PSR score of all the non-implemented controls, expressed as a percentage and displayed for a single business component.

PercentualOfPSROfLowRisk

Displays the PSR score for the non-implemented controls in the Low range divided by the total PSR score of all the non-implemented controls, expressed as a percentage and displayed for a single business component.

PercentualOfPSROfMediumRisk

Displays the PSR score for the non-implemented controls in the Medium range divided by the total PSR score of all the non-implemented controls, expressed as a percentage and displayed for a single business component.

PercentualOfPSROfVeryHighRisk

Displays the PSR score for the non-implemented controls in the Very High range divided by the total PSR score of all the non-implemented controls, expressed as a percentage and displayed for a single business component.

PercentualOfPSROfVeryLowRisk

Displays the PSR score for the non-implemented controls in the Very Low range divided by the total PSR score of all the non-implemented controls, expressed as a percentage and displayed for a single business component.

PercentualOfQuantityOfHighRisk

Displays the number of non-implemented controls with PSR scores in the High range divided by the total number of all the non-implemented controls, expressed as a percentage and displayed for a single business component.

PercentualOfQuantityOfLowRisk

Displays the number of non-implemented controls with PSR scores in the Low range divided by the total number of all the non-implemented controls, expressed as a percentage and displayed for a single business component.

PercentualOfQuantityOfMediumRisk

Displays the number of non-implemented controls with PSR scores in the Medium range divided by the total number of all the non-implemented controls, expressed as a percentage and displayed for a single business component.

PercentualOfQuantityOfVeryHighRisk

Displays the number of non-implemented controls with PSR scores in the Very High range divided by the total number of all the non-implemented controls, expressed as a percentage and displayed for a single business component.

PercentualOfQuantityOfVeryLowRisk

Displays the number of non-implemented controls with PSR scores in the Very Low range divided by the total number of all the non-implemented controls, expressed as a percentage and displayed for a single business component.

PSRHighRisk

Displays the PSR score for all non-implemented controls in the High range related to a business component.

PSRLowRisk

Displays the PSR score for all non-implemented controls in the Low range related to a business component.

PSRMediumRisk

Displays the PSR score for all non-implemented controls in the Medium range related to a business component.

PSRVeryHighRisk

Displays the PSR score for all non-implemented controls in the Very High range related to a business component.

PSRVeryLowRIsk

Displays the PSR score for all non-implemented controls in the Very Low range related to a business component.

QuantityOfHighRisk

Displays the number of non-implemented controls related to a business component with PSR scores in the High range.

QuantityOfLowRisk

Displays the number of non-implemented controls related to a business component with PSR scores in the Low range.

QuantityOfMediumRisk

Displays the number of non-implemented controls related to a business component with PSR scores in the Medium range.

QuantityOfVeryHighRisk

Displays the number of non-implemented controls related to a business component with PSR scores in the Very High range.

QuantityOfVeryLowRisk

Displays the number of non-implemented controls related to a business component with PSR scores in the Very Low range.

SumPercentualVeryHighandHigh

Displays the PSR score of the non-implemented controls in the Very High and High ranges related to a business component divided by the total number of non-implemented controls related to a business component.

SumQuantityVeryHighAndHigh

Displays the sum of non-implemented controls related to a business component with PSR scores in the Very High and High range.

TotalPercentualOfPSR

Displays the PSR score of all non-implemented controls related to a business component in all ranges divided by the total PSR score of all non-implemented controls in all ranges related to a business component, expressed as a percentage. This is used to ensure that totals appearing in queries have been calculated correctly.

TotalPercentualOfQuantity

Displays the number of non-implemented controls related to a business component in all ranges divided by the total number of non-implemented controls in all ranges related to a business component, expressed as a percentage. This is used to ensure that totals appearing in queries have been calculated correctly.

TotalPSR

Displays the total PSR score for all non-implemented controls related to a business component.

TotalQuantity

Displays the total number of non-implemented controls related to a business component.

ConsideredAssets

This query groups columns that display information on the assets included in the scope of a report.

AssetName

Displays the name of an asset.

AssetTypeName

Displays the name of an asset type.

Relevance

Displays the relevance of an asset (Very High to Very Low).

RelevanceName

Displays the relevance of an asset (1 to 5).

ControlsIndices

This query groups columns with information on the risk metrics identified for the scope of a report.

ControlIndex

Displays the Control Index for the scope of a report.

GapIndex

Displays the Gap Index for the scope of a report.

RiskIndex

Displays the Risk Index for the scope of a report.

SecurityIndex

Displays the Security Index for the scope of a report.

IdentifiedControlsPSRGroupedByRisk

This query groups columns that display information on the PSR scores for all non-implemented controls included in the scope of a report.

PercentHighRisk

Displays the PSR score for all non-implemented controls in the High range divided by the total PSR score of all non-implemented controls in all ranges, expressed as a percentage.

PercentLowRisk

Displays the PSR score for all non-implemented controls in the Low range divided by the total PSR score of all non-implemented controls in all ranges, expressed as a percentage.

PercentMediumRisk

Displays the PSR score for all non-implemented controls in the Medium range divided by the total PSR score of all non-implemented controls in all ranges, expressed as a percentage.

PercentTotal

Displays the PSR score for all non-implemented controls divided by the total PSR score of all non-implemented controls, expressed as a percentage. This is used to ensure that totals appearing in queries have been calculated correctly.

PercentVeryHighRisk

Displays the PSR score for all non-implemented controls in the Very High range divided by the total PSR score of all non-implemented controls in all ranges, expressed as a percentage.

PercentVeryLowRisk

Displays the PSR score for all non-implemented controls in the Very Low range divided by the total PSR score of all non-implemented controls in all ranges, expressed as a percentage.

PSRHighRisk

Displays the PSR score for all non-implemented controls in the High range.

PSRLowRisk

Displays the PSR score for all non-implemented controls in the Low range.

PSRMediumRisk

Displays the PSR score for all non-implemented controls in the Medium range.

PSRTotal

Displays the total PSR score for all non-implemented controls.

PSRVeryHighRisk

Displays the PSR score for all non-implemented controls in the Very High range.

PSRVeryLowRisk

Displays the PSR score for all non-implemented controls in the Very Low range.

IdentifiedControlsQuantityGroupedByRisk

This query groups columns that display information on all the non-implemented controls included in the scope of a report.

PercentualOfHighRisk

Displays the number of non-implemented controls with PSR scores in the High range divided by the total number of non-implemented controls, expressed as a percentage.

PercentualOfLowRisk

Displays the number of non-implemented controls with PSR scores in the Low range divided by the total number of non-implemented controls, expressed as a percentage.

PercentualOfMediumRisk

Displays the number of non-implemented controls with PSR scores in the Medium range divided by the total number of non-implemented controls, expressed as a percentage.

PercentualOfVeryHighRisk

Displays the number of non-implemented controls with PSR scores in the Very High range divided by the total number of non-implemented controls, expressed as a percentage.

PercentualOfVeryLowRisk

Displays the number of non-implemented controls with PSR scores in the Very Low range divided by the total number of non-implemented controls, expressed as a percentage.

QuantityOfHighRisk

Displays the number of non-implemented controls with PSR scores in the High range.

QuantityOfLowRisk

Displays the number of non-implemented controls with PSR scores in the Low range.

QuantityOfMediumRisk

Displays the number of non-implemented controls with PSR scores in the Medium range.

QuantityOfVeryHighRisk

Displays the number of non-implemented controls with PSR scores in the Very High range.

QuantityOfVeryLowRisk

Displays the number of non-implemented controls with PSR scores in the Low range.

TotalPercentual

Displays the number of all non-implemented controls divided by the total number of all non-implemented controls, expressed as a percentage. This is used to ensure that totals appearing in queries have been calculated correctly.

TotalQuantity

Displays the total number of non-implemented controls.

Project

This query groups columns that display information on a risk project for which a report will be generated.

AnalysisClosedOn

Displays the date an analysis phase of a project was closed.

AnalysisStartedOn

Displays the date an analysis phase of a project was started.

AnalystName

Displays the name of an analyst responsible for answering a questionnaire in a project.

AuthorName

Displays the name of the author of a project.

ClosedOn

Displays the date on which a project was closed.

Code

Displays the identification code for a project.

CreatedOn

Displays the date on which a project was closed.

LeaderName

Displays the name of a project leader.

Name

Displays the name of a project.

Status

Displays the status of a project.

SubstituteLeaderName

Displays the name of the substitute leader for a project.

TotalIndentifiedRisk

Displays the PSR score of the non-implemented controls for all asset components included in the scope of a report.

TotalNumberOfAssets

Displays the total number of assets included in the scope of a report.

ReportInfo

This query groups columns that display information on the report itself.

AuthorName

Displays the name of the author of a report.

Copyright

Displays copyright information for Modulo Security LLC.

ModuleName

Displays the name of a system module from which the data displayed in the report were generated.

PrintDate

Displays the date and time a report was generated.

ReportName

Displays the name of a report (Executive Analysis Report).

RisksAtOperationalLevel

This query groups columns that display information on the tactical business components included in the scope of a report.

ApplicableCount

Displays the number of applicable controls related to a tactical business component.

AvoidedCount

Displays the number of implemented controls related to a tactical business component.

ControlIndex

Displays the Control Index for a tactical business component.

GAPIndex

Displays the Gap Index for a tactical business component.

IdentifiedCount

Displays the number of non-implemented controls related to a tactical business component.

Name

Displays the name of a tactical business component.

PSRApplicable

Displays the total PSR score of all the applicable controls related to a tactical business component.

PSRAvoided

Displays the total PSR score of all the implemented controls related to a tactical business component.

PSRIdentified

Displays the total PSR score of all the non-implemented controls related to a tactical business component.

Relevance

Displays the relevance of a tactical business component (Very Low to Very High).

RiskIndex

Displays the Risk Index for a tactical business component.

SecurityIndex

Displays the Security Index for a tactical business component.

RisksAtStrategicalLevel

This query groups columns that display information on the strategic business components included in the scope of a report.

ApplicableCount

Displays the number of applicable controls related to a strategic business component.

AvoidedCount

Displays the number of implemented controls related to a strategic business component.

ControlIndex

Displays the Control Index for a strategic business component.

GAPIndex

Displays the Gap Index for a strategic business component.

IdentifiedCount

Displays the number of non-implemented controls related to a strategic business component.

Name

Displays the name of a strategic business component.

PSRApplicable

Displays the total PSR score of all the applicable controls related to a strategic business component.

PSRAvoided

Displays the total PSR score of all the implemented controls related to a strategic business component.

PSRIdentified

Displays the total PSR score of all the non-implemented controls related to a strategic business component.

Relevance

Displays the relevance of a strategic business component (Very Low to Very High).

RiskIndex

Displays the Risk Index for a strategic business component.

SecurityIndex

Displays the Security Index for a strategic business component.

RisksGroupedByAsset

This query groups columns that display risk analysis information for assets included in the scope of a report.

ApplicableCount

Displays the number of applicable controls related to an asset.

ApplicableRisk

Displays the PSR score for the applicable controls related to an asset.

AssetTypeName

Displays the name of an asset type.

AvoidedCount

Displays the number of implemented controls related to an asset.

AvoidedRisk

Displays the PSR score for the implemented controls related to an asset.

ControlIndex

Displays the Control Index for an asset.

GapIndex

Displays the Gap Index for an asset.

IdentifiedCount

Displays the number of non-implemented controls related to an asset.

IdentifiedRisk

Displays the PSR score for the non-implemented controls related to an asset.

Name

Displays the name of an asset.

QuantityOfHighRisk

Displays the number of non-implemented controls related to an asset with PSR scores in the High range.

QuantityOfLowRisk

Displays the number of non-implemented controls related to an asset with PSR scores in the Low range.

QuantityOfMediumRisk

Displays the number of non-implemented controls related to an asset with PSR scores in the Medium range.

QuantityOfVeryHighRisk

Displays the number of non-implemented controls related to an asset with PSR scores in the Very High range.

QuantityOfVeryLowRisk

Displays the number of non-implemented controls related to an asset with PSR scores in the Very Low range.

RelativeControlIndex

Displays the number of implemented controls for an asset divided by the total number of implemented controls for all the assets included in the scope of a report, quantifying an asset's contribution to the total Control Index.

RelativeGapIndex

Displays the number of non-implemented controls for an asset divided by the total number of applicable controls for all assets included in the scope of a report, quantifying an asset's contribution to the total Gap Index.

RelativeIdentifiedRisk

Displays the PSR scores of non-implemented controls for an asset divided by the total PSR score of non-implemented controls for all assets included in the scope of a report, quantifying an asset's contribution to the total risk.

RelativeRiskIndex

Displays the identified PSR score for an asset divided by the total applicable PSR score for all the assets included in the scope of a report, quantifying an asset's contribution to the total Risk Index.

RelativeSecurityIndex

Displays the controlled PSR score for an asset divided by the total applicable PSR score for all the assets included in the scope of a report, quantifying an asset's contribution to the total Security Index.

RiskIndex

Displays the Risk Index for an asset.

SecurityIndex

Displays the Security Index for an asset.

RisksGroupedByAssetFirstLine

This query groups columns that display risk analysis information on an asset included in the scope of a report, obtaining values only for the element in the first line of a query. Queries are presented in descending order of Risk Index, such that those with the highest Risk Index will appear in the first line.

ApplicableCount

Displays the number of applicable controls related to an asset appearing in the first line of a query.

ApplicableRisk

Displays the PSR score for the applicable controls related to an asset appearing in the first line of a query.

AssetTypeName

Displays the name of the type of an asset appearing in the first line of a query.

AvoidedCount

Displays the number of implemented controls related to an asset appearing in the first line of a query.

AvoidedRisk

Displays the PSR score for the implemented controls related to an asset appearing in the first line of a query.

ControlIndex

Displays the Control Index for an asset appearing in the first line of a query.

GapIndex

Displays the Gap Index for an asset appearing in the first line of a query.

IdentifiedCount

Displays the number of non-implemented controls related to an asset appearing in the first line of a query.

IdentifiedRisk

Displays the PSR score for the non-implemented controls related to an asset appearing in the first line of a query.

Name

Displays the name of an asset appearing in the first line of a query.

QuantityOfHighRisk

Displays the number of non-implemented controls related to an asset appearing in the first line of a query with PSR scores in the High range.

QuantityOfLowRisk

Displays the number of non-implemented controls related to an asset appearing in the first line of a query with PSR scores in the Low range.

QuantityOfMediumRisk

Displays the number of non-implemented controls related to an asset appearing in the first line of a query with PSR scores in the Medium range.

QuantityOfVeryHighRisk

Displays the number of non-implemented controls related to an asset appearing in the first line of a query with PSR scores in the Very High range.

QuantityOfVeryLowRisk

Displays the number of non-implemented controls related to an asset appearing in the first line of a query with PSR scores in the Very Low range.

RelativeControlIndex

Displays the number of implemented controls for an asset appearing in the first line of a query divided by the total number of implemented controls for all the assets included in the scope of a report, quantifying an asset's contribution to the total Control Index.

RelativeGapIndex

Displays the number of non-implemented controls for an asset appearing in the first line of a query divided by the total number of applicable controls for all assets included in the scope of a report, quantifying an asset's contribution to the total Gap Index.

RelativeIdentifiedRisk

Displays the PSR scores of non-implemented controls for an asset appearing in the first line of a query divided by the total PSR score of non-implemented controls for all assets included in the scope of a report, quantifying an asset's contribution to the total risk.

RelativeRiskIndex

Displays the identified PSR score for an asset appearing in the first line of a query divided by the total applicable PSR score for all the assets included in the scope of a report, quantifying an asset's contribution to the total Risk Index.

RelativeSecurityIndex

Displays the controlled PSR score for an asset appearing in the first line of a query divided by the total applicable PSR score for all the assets included in the scope of a report, quantifying an asset's contribution to the total Security Index.

RiskIndex

Displays the Risk Index for an asset appearing in the first line of a query.

SecurityIndex

Displays the Security Index for an asset appearing in the first line of a query.

RisksGroupedByThreats

This query groups columns that display risk analysis information on one or more threats included in the scope of a report.

ApplicableCount

Displays the number of applicable controls related to a threat.

ApplicableRisk

Displays the PSR score for the applicable controls related to a threat.

AvoidedCount

Displays the number of implemented controls related to a threat.

AvoidedRisk

Displays the PSR score for the implemented controls related to a threat.

ControlIndex

Displays the Control Index for a threat.

GapIndex

Displays the Gap Index for a threat.

IdentifiedCount

Displays the number of non-implemented controls related to a threat.

IdentifiedRisk

Displays the PSR score of the non-implemented controls related to a threat.

Name

Displays the name of a threat.

RelativeControlIndex

Displays the number of implemented controls for a threat divided by the total number of implemented controls for all threats included in the scope of a report, quantifying a threat's contribution to the total Control Index.

RelativeGapIndex

Displays the number of non-implemented controls for a threat divided by the total number of applicable controls for all threats included in the scope of a report, quantifying a threat's contribution to the total Gap Index.

RelativeIdentifiedRisk

Displays the PSR scores of non-implemented controls for a threat divided by the total PSR score of non-implemented controls for all threats included in the scope of a report, quantifying a threat's contribution to the total.

RelativeRiskIndex

Displays the identified PSR score for a threat divided by the total applicable PSR score for all threats included in the scope of a report, quantifying a threat's contribution to the total Risk Index.

RelativeSecurityIndex

Displays the controlled PSR score for a threat divided by the total applicable PSR score for all threats included in the scope of a report, quantifying a threat's contribution to the total Security Index.

RiskIndex

Displays the Risk Index for a threat.

SecurityIndex

Displays the Security Index for a threat.

RisksGroupedByThreatsFirstLine

This query groups columns that display risk analysis information on a threat included in the scope of a report, obtaining values only for the element in the first line of a query. Queries are presented in descending order of Risk Index, such that those with the highest Risk Index will appear in the first line.

ApplicableCount

Displays the number of applicable controls related to a threat appearing in the first line of a query.

ApplicableRisk

Displays the PSR score for the applicable controls related to a threat appearing in the first line of a query.

AvoidedCount

Displays the number of implemented controls related to a threat appearing in the first line of a query.

AvoidedRisk

Displays the PSR score for the implemented controls related to a threat appearing in the first line of a query.

ControlIndex

Displays the Control Index for a threat appearing in the first line of a query.

GapIndex

Displays the Gap Index for a threat appearing in the first line of a query.

IdentifiedCount

Displays the number of non-implemented controls related to a threat appearing in the first line of a query.

IdentifiedRisk

Displays the PSR score of the non-implemented controls related to a threat appearing in the first line of a query.

Name

Displays the name of a threat appearing in the first line of a query.

RelativeControlIndex

Displays the number of implemented controls for a threat appearing in the first line of a query divided by the total number of implemented controls for all threats included in the scope of a report, quantifying a threat's contribution to the total Control Index.

RelativeGapIndex

Displays the number of non-implemented controls for a threat appearing in the first line of a query divided by the total number of applicable controls for all threats included in the scope of a report, quantifying a threat's contribution to the total Gap Index.

RelativeIdentifiedRisk

Displays the PSR scores of non-implemented controls for a threat appearing in the first line of a query divided by the total PSR score of non-implemented controls for all threats included in the scope of a report, quantifying a threat's contribution to the total risk.

RelativeRiskIndex

Displays the identified PSR score for a threat appearing in the first line of a query divided by the total applicable PSR score for all threats included in the scope of a report, quantifying a threat's contribution to the total Risk Index.

RelativeSecurityIndex

Displays the controlled PSR score for a threat appearing in the first line of a query divided by the total applicable PSR score for all threats included in the scope of a report, quantifying a threat's contribution to the total Security Index.

RiskIndex

Displays the Risk Index for a threat appearing in the first line of a query.

SecurityIndex

Displays the Security Index for a threat appearing in the first line of a query.

RisksInAssets

This query groups columns with risk analysis information for assets included in the scope of a report.

AssetName

Displays the name of an asset.

AssetRelevance

Displays the relevance of an asset (Very High to Very Low).

AssetType

Displays an asset's type (person, technology, environment, etc.)

PSR

Displays the total PSR related to an asset.

PSRApplicable

Displays the applicable PSR score related to an asset.

PSRAvoided

Displays the PSR score of the implemented controls related to an asset.

PSRIdentified

Displays the PSR score of the non-implemented controls related to an asset.

RelativeRiskIndex

Displays the identified PSR score for an asset divided by the total applicable PSR score for all assets included in the scope of a report, quantifying an asset's contribution to the total Risk Index.

RiskIndex

Displays the Risk Index for an asset.

SecurityIndex

Displays the Security Index for an asset.

SummaryRiskAtOperationalLevel

This query groups columns with summarized risk analysis information for the tactical business components included in the scope of a report.

Count

Displays the number of tactical business components with the highest risk indices, showing a maximum of 10.

SummaryRiskAtStrategicalLevel

This query groups columns with summarized risk analysis information for the strategic business components included in the scope of a report.

Count

Displays the number of strategic business components with the highest risk indices, showing a maximum of 10.

SummaryRisksGroupedByAsset

This query groups columns with summarized risk analysis information for the assets included in the scope of a report with the highest risk indices, showing a maximum of 10.

AssetTypeName

Displays the name of an asset's type.

AvoidedCount

Displays the number of implemented controls related to an asset.

AvoidedRisk

Displays the total PSR of the implemented controls related to an asset.

Count

Displays the number of assets with the highest risk indices.

GapIndex

Displays the Gap Index of an asset.

IdentifiedCount

Displays the number of non-implemented controls related to an asset.

IdentifiedRisk

Displays the total PSR of the non-implemented controls related to an asset.

QuantityOfHighRisk

Displays the number of assets with High risk levels.

QuantityOfLowRisk

Displays the number of assets with Low risk levels.

QuantityOfMediumRisk

Displays the number of assets with Medium risk levels.

QuantityOfVeryHighRisk

Displays the number of assets with Very High risk levels.

QuantityOfVeryLowRisk

Displays the number of assets with Very Low risk levels.

SummaryRisksGroupedByThreats

This query groups columns with summarized risk analysis information for the threats included in the scope of a report with the highest risk indices, showing a maximum of 10.

AvoidedCount

Displays the number of implemented controls related to a threat.

AvoidedRisk

Displays the total PSR of the implemented controls related to a threat.

Count

Displays the number of threats with the highest risk indices.

GapIndex

Displays the Gap Index of a threat.

IdentifiedCount

Displays the number of non-implemented controls related to a threat.

IdentifiedRisk

Displays the total PSR of the non-implemented controls related to a threat.

RiskIndex

Displays the Risk Index of a threat.

SummaryRisksInAssets

This query groups columns with summarized risk analysis information for the assets included in the scope of a report with the highest risk indices, showing a maximum of 10.

Count

Displays the number of assets with the highest risk indices.

RelativeRiskIndex

Displays the identified PSR score for one of the 10 assets with the highest risk indices divided by the total applicable PSR score for all the assets included in the scope of a report, quantifying how much an asset with the highest risk indices contributed to the total Risk Index.