The table below lists queries and the columns from each query available for use in the Detailed 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.
|
Detailed Risk Report | |
|
Query/Columns |
Description |
|
ControlsAttachments |
This query groups columns that display information on one or more files attached to controls, either by the analyst or through survey rules. |
|
ControlName |
Displays the name of the control to which the file was attached. |
|
Description |
Displays the description provided by the analyst, interviewee, or reviewer when attaching the file. |
|
FileName |
Displays the name of the file attached (for example, file.txt). |
|
Url |
Displays the access URL for the file attached to the control. |
|
ControlsByRiskLevel |
This query groups columns that display information on the non-implemented controls included in the scope of a report. |
|
AssetComponentName |
Displays the name of an asset component. |
|
ControlID |
Displays the alphanumeric identification code for a control used internally by the system. |
|
ControlName |
Displays the name of a control. |
|
GroupIndex |
Displays a sequential number for each control grouping, starting from 0001. This number is concatenated with the section number for the report for organizational purposes. |
|
GroupName |
Displays the name of a grouping to which a control belongs. |
|
Probability |
Displays the numeric probability for a control on a scale of 1 (Very Low) to 5 (Very High). |
|
ProbabilityName |
Displays the name of a probability level for a control (Very Low - Very High). |
|
PSR |
Displays the PSR score for a control from a questionnaire, as specified by an analyst. |
|
PSRLevel |
Displays the numeric PSR level for a control on a scale of 1 (Very Low) to 5 (Very High). |
|
PSRLevelName |
Displays the name of a PSR level for a control on a scale of Very Low (1) to Very High (5). |
|
Relevance |
Displays the numeric relevance for a control on a scale of 1 (Very Low) to 5 (Very High). |
|
RelevanceName |
Displays the name of a relevance level for a control (Very Low - Very High). |
|
Severity |
Displays the numeric severity for a control on a scale of 1 (Very Low) to 5 (Very High). |
|
SeverityName |
Displays the name of a severity level for a control (Very Low - Very High). |
|
ControlsImageAttachments |
This query groups columns that display information on one or more images attached to controls, either by the analyst or through survey rules. |
|
ControlName |
Displays the name of the control to which an image was attached. |
|
FileName |
Displays the name of the file attached to the control (for example, image.jpeg). |
|
ImageData |
Displays the image attached to the control. |
|
ImageDescription |
Displays the description provided by the analyst, interviewee, or reviewer when attaching the image. |
|
Url |
Displays the access URL for the image attached to the control. |
|
NotImplementedControls |
This query groups columns that display information on the non-implemented controls identified in the scope of a report. |
|
AssetCount |
Displays the number of asset components related to the non-implemented controls. |
|
Comments |
Displays any comments entered by analysts when answering a control. |
|
ControlAttachments |
This query groups columns that display information on a file attached to a control, either by the analyst or through interview rules. It contains the following columns: ControlName: Displays the name of the control to which the file was attached. Description: Displays the description provided by the analyst, interviewee, or reviewer when attaching the file. FileName: Displays the name of the file attached to the control (for example, file.txt). Url: Displays the access URL for the file attached to the control. |
|
ControlImageAttachments |
This query groups columns that display information on an image attached to a control. It contains the following columns: ControlName: Displays the name of the control to which the image was attached. FileName: Displays the name of the file attached to the control (for example, image.jpeg). ImageData: Displays the image attached to the control. ImageDescription: Displays the description provided by the analyst, interviewee, or reviewer when attaching the image. Url: Displays the access URL for the image attached to the control. |
|
ControlID |
Displays the alphanumeric identification code for a control used internally by the system. |
|
ControlName |
Displays the name of a control. |
|
GroupIndex |
Displays a sequential number for each control grouping, starting from 0001. This number is concatenated with the section number for the report for organizational purposes. |
|
GroupName |
Displays the name of a grouping to which a control belongs. |
|
Justification |
Displays the justification of a control, listing the benefits that implementing the control may bring or losses that may occur if not implemented. |
|
KnowledgeBaseName |
Displays the name of the knowledge base a control is listed in. |
|
Recommendations |
Displays the recommendations that provide orientation on how to implement a control. |
|
References |
Displays the references that cite where additional information on a control and its implementation can be found. |
|
TotalPSR |
Displays the total PSR score for a control, considering the number of times the control was found to be not implemented in asset components included in the scope of a report and using the final PSR score specified by the analyst when answering the questionnaire. |
|
ImplementedControls |
This query groups columns that display information on the implemented controls identified in the scope of a report. |
|
ImplementedControlAttachments |
This query groups columns that display information on a file attached to an implemented control, either by the analyst or through interview rules. It contains the following columns: •ControlName: Displays the name of the control to which the file was attached. •Description: Displays the description provided by the analyst, interviewee, or reviewer when attaching the file. •FileName: Displays the name of the file attached to the control (for example, file.txt). •Url: Displays the access URL for the file attached to the control. |
|
ImplementedControlImageAttachments |
This query groups columns that display information on an image attached to an implemented control. It contains the following columns: •ControlName: Displays the name of the control to which the image was attached. •FileName: Displays the name of the file attached to the control (for example, image.jpeg). •ImageData: Displays the image attached to the control. •ImageDescription: Displays the description provided by the analyst, interviewee, or reviewer when attaching the image. •Url: Displays the access URL for the image attached to the control. |
|
AssetCount |
Displays the number of asset components related to the implemented controls. |
|
Comments |
Displays any comments entered by analysts when answering a control. |
|
ControlID |
Displays the alphanumeric identification code for a control used internally by the system. |
|
ControlName |
Displays the name of a control. |
|
GroupIndex |
Displays a sequential number for each control grouping, starting from 0001. This number is concatenated with the section number for the report for organizational purposes. |
|
GroupName |
Displays the name of a grouping to which a control belongs. |
|
Justification |
Displays the justification of a control, listing the benefits that implementing the control may bring or losses that may occur if not implemented. |
|
KnowledgeBaseName |
Displays the name of the knowledge base a control is listed in. |
|
Recommendations |
Displays the recommendations that provide orientation on how to implement a control. |
|
References |
Displays the references that cite where additional information on a control and its implementation can be found. |
|
TotalPSR |
Displays the total PSR score for a control, considering the number of times the control was identified as implemented in asset components included in the scope of a report and using the final PSR score specified by the analyst when answering the questionnaire. |
|
ImplementedControlsAttachments |
This query groups columns that display information on one or more files attached to implemented controls, either by the analyst or through survey rules. |
|
ControlName |
Displays the name of the control to which the file was attached. |
|
Description |
Displays the description provided by the analyst, interviewee, or reviewer when attaching the file. |
|
FileName |
Displays the name of the file attached (for example, file.txt). |
|
Url |
Displays the access URL for the file attached to the control. |
|
ImplementedControlsImageAttachments |
This query groups columns that display information on one or more images attached to implemented controls, either by the analyst or through survey rules. |
|
ControlName |
Displays the name of the control to which an image was attached. |
|
FileName |
Displays the name of the file attached to the control (for example, image.jpeg). |
|
ImageData |
Displays the image attached to the control. |
|
ImageDescription |
Displays the description provided by the analyst, interviewee, or reviewer when attaching the image. |
|
Url |
Displays the access URL for the image attached to the control. |
|
Project |
This query groups columns with 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 considering the final PSR score specified by the analyst when answering the questionnaire. |
|
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 on which a report was generated. |
|
ReportName |
Displays the name of a report (Operational Risk Report). |