This documentation supports the 18.08 version of Remedy IT Service Management Suite.

To view the latest version, select the version from the Product version menu.

Report details

The Report Details button, found on an active report's menu bar, allows you to view a useful collection of information on the report.

Report Details

When you click on the Report Details button you will be presented with a window consisting of three tabs, the first of which is the Report Details tab. On this tab you will be presented with the following:


Report Details 
NameName of the report, supplied by the report writer.
DescriptionDescription of the report, supplied by the report writer.
CategoryThe category the report is currently stored in.
Sub CategoryThe sub category the report is currently stored in.
ExpertIf the sub category requires approval, provides the assigned user or group.
Update TypeEdit Existing Report
Report TemplateDisplay option of the report, Eg. Table, Table and Chart, etc.
Max Rows ReturnedMax number of rows to be returned in the report. Set at the source connection and confirmed on the report data page. Eg. 10000
Source SystemThe source connection the report is based on.
Created ByMethod of report builder used. Eg. Drag and Drop Builder
View NameThe view the report is based on.
View DescriptionDescription of the view the report is based on. Provided by the view builder.
Report URLURL generated for the report.
Report Stats 
Run CountNumber of times the report has been run.
Average Run TimeAverage length of time the report takes to run.
Last RunThe length of time the report took to run last.
ModifiedLast modified date and time.
Access Rights 
Level of AccessAccess setting applied to the report sub category.

Column Definitions

The second tab in the Report Details window contains information on the fields used in the report.


Each field will have the following information listed:

PropertyDescription
FieldName of the field, defined at the view level.
GroupName of the category the field is attached to in the view.
TypeType of field (Metric or Dimension)
Data TypeField type defined in the source database
DescriptionDescription of the field, defined at the view level.

SQL Statement

The third tab in the Report Details window contains the SQL generated by BMC Remedy Smart Reporting for the report. This tab can be restricted through Role Permissions so that only advanced users can view it if necessary. This tab also contains an Export SQLbutton, allowing you to export the query to a .sql file.


Was this page helpful? Yes No Submitting... Thank you

Comments