Risk 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 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.

AssetsType

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

Description

Displays the description for an asset type.

Name

Displays the name of an asset type.

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).

ConsideredKnowledgeBases

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

ApplicablePSR

Displays the applicable PSR score for a knowledge base.

ControlCount

Displays the number of controls in a knowledge base.

IdentifiedPSR

Displays the identified PSR score (PSR score of non-implemented controls) for a knowledge base.

KnowledgeBaseCount

Displays the number of times a single knowledge base was analyzed - for example, if there are two asset components in the scope of the project associated with the same knowledge base.

KnowledgeBaseName

Displays the name of a knowledge base.

RelativeRiskIndex

Displays the identified PSR score for a knowledge base divided by the total applicable PSR score for all the knowledge bases included in the scope of a report, quantifying its contribution to the total Risk Index.

RiskIndex

Displays the Risk Index for a knowledge base.

ConsideredPerimeters

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

Name

Displays the name of a perimeter.

ParentName

Displays the name of the parent perimeter for a perimeter, blank if none.

ResponsibleName

Displays the name of the person responsible for a perimeter.

ConsideredThreatSource

This query groups columns that display any threat sources associated with controls included in the scope of a report.

Name

Displays the name of a threat source.

ControlsIndices

This query groups columns that display 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 created.

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 was generated.

PrintDate

Displays the date and time a report was generated.

ReportName

Displays the name of a report (Risk 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 fisrt 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.

RisksGroupedByAssetType

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

ApplicableCount

Displays the number of applicable controls related to an asset type.

ApplicableRisk

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

AvoidedCount

Displays the number of implemented controls related to an asset type.

AvoidedRisk

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

ControlIndex

Displays the Control Index for an asset type.

GapIndex

Displays the Gap Index for an asset type.

IdentifiedCount

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

IdentifiedRisk

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

Name

Displays the name of an asset type.

QuantityOfAssets

Displays the number of assets of an asset type.

RelativeControlIndex

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

RelativeGapIndex

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

RelativeIdentifiedRisk

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

RelativeQuantityOfAssets

Displays the number of assets of a certain asset type divided by the total number of assets.

RelativeRiskIndex

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

RelativeSecurityIndex

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

RiskIndex

Displays the Risk Index for an asset type.

SecurityIndex

Displays the Security Index for an asset type.

RisksGroupedByAssetTypeFirstLine

This query groups columns that display risk analysis information on an asset type 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 type appearing in the first line of a query.

ApplicableRisk

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

AvoidedCount

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

AvoidedRisk

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

ControlIndex

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

GapIndex

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

IdentifiedCount

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

IdentifiedRisk

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

Name

Displays the name of an asset type included in the scope of a report that appears in the first line of a query.

QuantityOfAssets

Displays the number of assets of a certain type included in the scope of a report that appear in the first line of a query.

RelativeControlIndex

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

RelativeGapIndex

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

RelativeIdentifiedRisk

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

RelativeQuantityOfAssets

Displays the number of assets of a certain asset type appearing in the first line of a querydivided by the total number of assets.

RelativeRiskIndex

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

RelativeSecurityIndex

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

RiskIndex

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

SecurityIndex

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

RisksGroupedByPerimeter

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

ControlIndex

Displays the Control Index for a perimeter.

GapIndex

Displays the Gap Index for a perimeter.

Name

Displays the name of a perimeter.

PSRAvoided

Displays the PSR score of all the implemented controls related to a perimeter.

PSRIdentified

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

QuantityOfAvoided

Displays the number of implemented controls related to a perimeter.

QuantityOfIdentified

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

RelativeControlIndex

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

RelativeGapIndex

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

RelativeRiskIndex

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

RelativeSecurityIndex

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

RiskIndex

Displays the Risk Index for a perimeter.

SecurityIndex

Displays the Security Index for a perimeter.

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.

RisksGroupedByThreatSource

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

ApplicableCount

Displays the number of applicable controls related to a threat source.

ApplicableRisk

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

AvoidedCount

Displays the number of implemented controls related to a threat source.

AvoidedRisk

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

ControlIndex

Displays the Control Index for a threat source.

GapIndex

Displays the Gap Index for a threat source.

IdentifiedCount

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

IdentifiedRisk

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

Name

Displays the name of a threat source.

RelativeControlIndex

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

RelativeGapIndex

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

RelativeIdentifiedRisk

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

RelativeRiskIndex

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

RelativeSecurityIndex

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

RiskIndex

Displays the Risk Index for a threat source.

SecurityIndex

Displays the Security Index for a threat source.

RisksGroupedByThreatSourceFirstLine

This query groups columns that display risk analysis information on one or more threat sources appearing in the first line of a query included in the scope of a report.

ApplicableCount

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

ApplicableRisk

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

AvoidedCount

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

AvoidedRisk

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

ControlIndex

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

GapIndex

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

IdentifiedCount

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

IdentifiedRisk

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

Name

Displays the name of a threat source included in the first line of a query.

RelativeControlIndex

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

RelativeGapIndex

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

RelativeIdentifiedRisk

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

RelativeRiskIndex

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

RelativeSecurityIndex

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

RiskIndex

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

SecurityIndex

Displays the Security Index for a threat source 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 for the implemented contols 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 for 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.

RiskIndex

Displays the Risk Index of an asset.

SummaryRisksGroupedByAssetType

This query groups columns with summarized risk analysis information for the asset types included in the scope of a report with the highest risk indices.

AvoidedCount

Displays the number of implemented controls related to an asset type.

AvoidedRisk

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

Count

Displays the number of asset types with the highest risk indices.

GapIndex

Displays the Gap Index of an asset type.

IdentifiedCount

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

IdentifiedRisk

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

QuantityOfAssets

Displays the number of assets of an asset type with the highest risk indices.

RelativeQuantityOfAssets

Displays the number of assets of an asset type with the highest risk indices divided by the total number of assets, quantifying an asset type's contribution to the total risk.

RiskIndex

Displays the Risk Index of an asset type.

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.

SummaryRisksGroupedByThreatSource

This query groups columns with summarized risk analysis information for the threat sources 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 source.

AvoidedRisk

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

Count

Displays the number of threat sources with the highest risk indices.

GapIndex

Displays the Gap Index of a threat source.

IdentifiedCount

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

IdentifiedRisk

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

RiskIndex

Displays the Risk Index of a threat source.

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.

ApplicableRisk

Displays the PSR of the applicable controls related to an asset.

ConsolidatedRiskIndex

Displays the Risk Index of an asset.

ConsolidatedSecurityIndex

Displays the Security Index of an asset.

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.