Accessing predefined reports
The ability to report on data in BMC Remedyforce is a key tool for management. BMC Remedyforce provides a variety of predefined reports to give you quick access to information. You can use the Reports tab to view, create, edit, and export these reports. If the predefined reports return more information than you need, you can manage the scope of the report by customizing it.
To access predefined reports
- Click the Remedyforce Administration tab.
- On the Home page, click the Create Dashboards and Reports tile, and from the menu select Reports & Dashboards (Salesforce).
- From the Folders list, select BMC Remedyforce.
In the Report Name column, click the required report to view the report.
The following table describes the predefined reports that are available.Report Name Description Remedyforce Configuration Data Integrity Lists active template, suggested owner, service level agreement (SLA), and request definition records that reference data in other objects that has been deleted, modified, or marked as inactive. The report groups these impacted records by the Scan ID field. The report displays impacted records that are found in the current and last scans.
For information about how the data in this report is generated, see Verifying configuration data integrity.
Incident Management reports Incidents by Priority Displays a Vertical Column Chart of all the incidents categorized based on priority. The report also displays the incident urgency and impact.
Incident Resolution Average Time Displays a Vertical Column Chart that lists all the incident types based on the average resolution time.
If you want to generate a report to display the average number of incidents closed daily by a staff member on a defined date range, perform the following:
Open the Incident Resolution Average Time report and click Customize.
From the Drag and drop to add fields to the report section of the Incident Resolution Average Time page:
Drag the Closed Date field to the Drop a field here to create a grouping section.
Drag the Staff field to the Drop a field here to create a grouping section.
On the top of the Incident Resolution Average Time page:
From the Date Field drop-down menu, select Closed Date.
From the Range drop-down menu, select the required date range option.
Click Save.
Click Run Report.
Incidents by SLA Status Displays a Pie Chart that lists the number and percentage of all the incidents based on their SLA status (whether SLA has been met or missed) and groups those by the Configuration Items (CIs). Incidents with a First Call Resolution Displays a Pie Chart that lists the number and percentage of all the incidents that are resolved with a first call made to the Service Desk staff.
To generate this report, you must select the First Call Resolution field for incidents that are resolved and closed on the first call.Note: The First Call Resolution field is not available on the New Incident page by default. You must add the First Call Resolution field to the appropriate field set. For more information, see Customizing forms for the Remedyforce Console tab.
Closed Incidents by Queue Displays a Pie Chart that lists all the closed incidents and their percentage based on the owner field. Incidents Assigned More than Twice Displays a Vertical Column Chart of all the incidents and their percentage which have been assigned more than twice. Priority 1 and 2 Incidents by Status Displays a Pie Chart that lists all the priority 1 and priority 2 incidents and groups those by the status field. Open Incidents by Owner Displays a Vertical Column Chart of all the open incidents based on the owner field. Incidents with Incorrect Assignment Displays a Pie Chart that lists the number and percentage of all the incidents with incorrect assignment.
To generate this report, you must select the Incorrect owner check box for incidents that are incorrectly assigned.Note: The Incorrect owner check box is not available on the New Incident page by default. You must add the Incorrect owner check box to the appropriate field set.
Incidents with Incorrect Category Displays a Pie Chart that lists the number and percentage of all the incidents with incorrect category field.
To generate this report, you must select the Incorrect category check box for incidents with incorrect category field.Note: The Incorrect category check box is not available on the New Incident page by default. You must add the Incorrect category check box to the appropriate field set.
Incidents Resolved Remotely Displays a Pie Chart that lists the number and percentage of all the incidents resolved remotely, without the need for site visit.
To generate this report, for incidents resolved remotely and without the need for site visit, select Resolved remotely, without the need for site visit from the Closure Category drop-down menu of the Close Incident window.Incidents per Category Displays a Pie Chart of the categories that are in use by open incidents and the usage percentage of these categories. The pie chart lists the number of incidents that were created for each category. The report also lists all open incidents that were created for each category and groups them by the Category field. Clients 2.0 Displays a Vertical Column Chart of the number of open incidents for each client. The report also lists the number of open incidents that were created for each client.
Note: The 2.0 version supports users, contacts, and leads as clients.
Priority 1 Incidents Lists all open incidents that have a priority of 1. Incidents Closed Before Due Date Lists all closed incidents and describes whether each incident was closed before the Due Date.
Note: This report supports users, contacts, and leads as clients.
Tasks by Staff 2.0 Lists all open tasks that are assigned to each staff member.
Note: The 2.0 version supports users, contacts, and leads as clients.
Total Time Spent Per Incident 2.0 Lists all closed incidents with the total amount of time taken to resolve each incident. The closed incidents and the total amount of time spent in resolving these incidents are listed for each account. The total amount of time taken to resolve each incident is calculated from the Total Duration field in the Supporting Information section of the Incident form.
Note: The 2.0 version supports users, contacts, and leads as clients.
Incident Feedback Survey Report Displays a Pie Chart or Tabular chart of the feedback of the closed incidents. Lists all incidents that were closed by a particular date and groups them by the Feedback field.
Change Management reports Changes by Category Lists all open change requests that were created for each category and groups them by the Category field. Changes by CI Class Lists all open change requests that were created for each class in the data model and groups them by the Class Name field. The report also lists the configuration items linked to each change request. Problem Management reports Problems by Category Lists all open problems that were created for each category and groups them by the Category field. Problems by CI Class Lists all open problems that were created for each class in the data model and groups them by the Class Name field. The report also lists the configuration items linked to each problem. Problems by Client 2.0 Lists all open problems that were created for each client and groups them by the Incident: Client Name field.
Note: The 2.0 version supports users, contacts, and leads as clients.
Service Level Management reports SLA Attainment % by Service--Changes Lists all business services, their agreements, service target transactions that are met and missed for change request records, and groups them by the Business Service Name field. The report also lists the percentage of service target transactions that are met and missed for each agreement. SLA Attainment % by Service--Incidents Lists all business services, their agreements, service target transactions that are met and missed for incident records, and groups them by the Business Service Name field. The report also lists the percentage of service target transactions that are met and missed for each agreement. List of Business Services Lists all business services and the following details about each business service:
- Service Name
- Description
- Parent Service
- Service Owner: Full Name
- Start Date
- End Date
- Service Review Date
- Inactive
- Service hours: Business Hours Name
If you are using CMDB 1.0, use this report. This report is not valid for CMDB 2.0. If you are using CMDB 2.0, use the List of Business Services 2.0 report. If you have upgraded to CMDB 2.0, BMC recommends that you rename this report (such as List of Business Services (Deprecated)) so that users do not get confused between the List of Business Services and List of Business Services 2.0 reports.
List of Business Services 2.0 Lists all business services and the following details about each business service:
- Service Name
- Description
- Parent Service
- Service Owner: Full Name
- Start Date
- End Date
- Service Review Date
- Inactive
- Service hours: Business Hours Name
If you are using BMC Remedyforce 20.14.01 or later or you have upgraded to CMDB 2.0, use this report. If you are using CMDB 1.0, use the List of Business Services report. To configure the columns or field values that you want to see in the report, configure those fields in the Business Service field set in the
Base Element
object.No. of Clients for each Service Displays a Pie Chart of the total number of clients for each business service. The pie chart lists the number of clients of each business service. The report also lists all the clients of each business service and groups them by the Business Service Name field. Outage Hours based on Business Hours Displays a Bar Chart of the number of incidents for each business service. The report also lists the number of incidents for each business service with outage data, calculates the outage hours, and groups the incidents by the Business Service Name field The outage hours are calculated by using the business hours that are configured for the service that is linked to an incident. If you delete the values in the Outage Start and Outage End fields in an incident record, the report does not display the incident record.
The report displays the following information about each incident of the business service:
- Incident #
- Outage Start
- Outage End
- Actual Outage Time (Min)
- Actual Outage Time (Hours)
- Total Outage Hours
Services by Account Displays a Pie Chart of the total number of business services for each account. The pie chart lists the number of business services of each account. The report also lists all the business services of each account, the clients of each account and their linked business services, and groups them by the Account field. SLA Milestone History-Changes Lists all milestones and actions that were performed when the milestone occurs for change request records and groups them by each change request. The report also lists the actions, actions created date, milestone conditions, milestone status, and whether an error occurred while performing the action. SLA Milestone History-Incidents Lists all milestones and actions that were performed when the milestone occurs for incident records and groups them by each incident. The report also lists the actions, actions created date, milestone conditions, milestone status, and whether an error occurred while performing the action. Service Request Management reports Services Associated with a Vendor Lists all services that are associated with a vendor and groups them by the Vendor field.
Use this report if you are using CMDB 1.0. This report is not valid for CMDB 2.0. If you are using CMDB 2.0, use the Services Associated with a Vendor 2.0 report. If you have upgraded to CMDB 2.0, BMC recommends that you rename this report (such as Services Associated with a Vendor (Deprecated)) so that users do not get confused between the Services Associated with a Vendor and Services Associated with a Vendor 2.0 reports.
Services Associated with a Vendor 2.0 Lists all services that are associated with a vendor and groups them by the Vendor field.
If you are using BMC Remedyforce 20.14.01 or later or you have upgraded to CMDB 2.0, use this report. If you are using CMDB 1.0, use the Services Associated with a Vendor report. To configure the columns or field values that you want to see in the report, configure those fields in the Business Service field set in the
Base Element
object.Service Catalog Lists all services and their service request definitions and groups them by the Service field. Service Request Input Details Lists all service requests, their service request definitions, input questions, and the values entered in the input questions. Service Request Fulfillment Report Lists all service requests and describes whether each service request was closed before the Due Date. It groups them according to whether the service requests were compliant and the percentage of service requests that were compliant. Service requests are compliant if they are fulfilled before the Due Date. Service Request Cost Reporting Lists all closed service requests, their service request definitions, requested quantity, cost, and price. It also calculates and displays the total delivery cost and total customer price for each service request depending on the requested quantity. It also displays the grand total of the cost and price of all service requests. Knowledge articles reports Incidents Closed by Knowledge Articles Lists the incident details that could be closed using a knowledge article. Knowledge Article Rating by Client Lists the number of times each rating is given to knowledge articles by Client users of Self Service. Knowledge Article Rating by Staff Lists the number of times each rating is given to knowledge articles by Staff members. Knowledge Articles by Status Displays a Pie chart of the total number of knowledge articles for each status. The report displays the knowledge articles for each status of knowledge article grouped by status. Knowledge Articles by Type Displays the number of knowledge articles for each type of knowledge article. The report displays the knowledge articles for each knowledge article type grouped by knowledge article type. Most Used Knowledge Articles by Client Lists the number of times a knowledge article is used by Clients of Self Service. Most Used Knowledge Articles by Staff Lists the number of times a knowledge article is used by Staff members.
Note: In BMC Remedyforce 20.14.02, the Used by Staff members # column in this report has been replaced with the Used by Staff # column.
The Used by Staff members # column provided information about the number of times staff members linked a knowledge article only to incident records. The Used by Staff # column now provides information about the number of times staff members link a knowledge article to incident, change, and problem records.Knowledge Articles Feedback Displays the feedback received for knowledge articles from staff members and clients of Self Service. For more information, see Overview of the Knowledge Articles Feedback report. Knowledge Articles Usage Lists the number of times a knowledge article is used by staff members and clients of Self Service. For more information, see Overview of the Knowledge Articles Usage report. CMDB 2.0 List of Computer Systems Lists the computer systems configuration items. To configure the columns or field values that you want to see in the report, configure those fields in the Computer System field set in the Base Element
object.Configuration Items with Relationships Lists the configuration items (CIs) that have relationships or the CIs that do not have relationships. By default, the CIs with relationships are displayed.
To see the list of relationships for a CI, in the Relationship Details column, click Details. On the Base Relationships page, when you click a value in the Relationship Name column, the relationship list is displayed in the Instance Editor. Also, if you click a value in the Source or Destination columns, the CI details are displayed in the Instance Editor. On the Base Relationships page, you can search for values in the Relationship Name column only.
To see the configuration items that do not have relationships, in the filter area, click Edit in front of Filtered By, then in front of Relationship Count greater than "0", click Edit, and set Relationship Count less than or equal to 0. For the configuration items without relationship results, you can remove the Relationship Details and Relationships Count columns.
Remedyforce Chat Chat sessions by Account and Category Lists the life cycle events related to each instance of Remedyforce Chat based on client account and category. The report displays when a chat was initiated, to which staff member the chat was assigned to, when the chat ended, the wait time for client before the chat started, and chat duration. Configuration Items-related reports in the CMDB Dashboard
Note: By default, all the following reports show top five records. To show more records, see To view more than five records in a report.
Top 5 CIs by Incidents Top five configuration items (CIs) for which the greatest number of incidents are raised. Configuration Items by Class The number of CIs created for each class. Top 5 CIs by Problems Top five CIs for which the greatest number of problems are raised. Top 5 Services by Incidents Top five services for which the greatest number of incidents are raised. Top 5 Services in Service Requests Top five services for which the greatest number of service requests are raised. Top 5 Offerings by Incidents Top five service offerings for which the greatest number of incidents are raised. Top 5 Services by Clients The number of CI-client relationships that exist for a service. Top 5 Primary Clients by Services Top five primary clients associated with the greatest number of business services. Top 5 CIs by Change Requests Top five CIs for which the greatest number of change requests are created. Top 5 Business Services in SRDs Top five business services for which the greatest number of request definitions are created. Top 5 Business Services in SLAs Top five business services for which the greatest number of service-level agreements are created. Computer System per User The number of computers that are associated with a primary client. Recently Added CIs Count The number of recently added CIs. This report is shown in a tabular format on the CMDB Dashboard. Recently Updated CIs Count The number of CIs that were recently updated. This report is shown in a tabular format on the CMDB Dashboard. Computer/Server per site The number of computers or software servers that are located on a site. Software-Computer relation per User The number of software applications that are assigned to a computer and a primary client. Asset Management reports in the BMC Remedyforce Asset Management Dashboard Asset Count By Class Name – Status Lists all assets, and groups them first by the Asset Class field and then by the Asset Status field. Asset Count By Status – Class Name Lists all assets, and groups them first by the Asset Status field and then by the Asset Class field. Asset Data Quality Lists all assets in which the Location, Asset #, Serial #, Asset Status, and Primary Client fields contain NULL or None values. The report groups all assets by the Asset Class field. Asset Warranty Expiration - 30 days Lists assets whose warranty is due to expire in the next 30 days, and groups them by the Asset Class field. Hardware Asset Age By Class Lists hardware assets based on their age, and groups them by the Asset Class field.
The age of an asset is the difference between the asset birthdate and the current date. For information about configuring the Asset Birthdate attribute of asset records, see Configuring general BMC Remedyforce CMDB 2.0 settings.
Highest Number of Incidents Lists all incidents that are linked to assets, and groups them by the models that are selected in those assets. Highest Priority Incidents By Model Lists the Priority 1 incidents that are linked to assets, and groups them by the models that are selected in those assets. Normalization Exception Trending Lists the exceptions that are generated during the normalization process, and groups them first by the Object Name field and then by the Exception Time Range field. For more information about using and configuring reports, see Salesforce Help.
To view more than five records in the CMDB Dashboard reports
By default, out-of-the-box CI-related report in the BMC Remedyforce CMDB dashboard show top five records. Based on your requirements, you can customize the reports to displays more than five records.
- On the BMC Remedyforce CMDB Dashboard, click Edit.
- For the report for which you want to add more records, click .
- In the Maximum Values Displayed field, enter the number of records that you want to view in the report.
- Click OK.
- On the BMC Remedyforce CMDB Dashboard, click Save.
Overview of the Knowledge Articles Feedback report
As a system administrator, you can use the Knowledge Articles Feedback report to identify all the knowledge articles that have received feedback, and review the comments to update them. The following table describes the columns that are available in the Knowledge Articles Feedback report, and the fields that are used to display the values in each column.
Column name | Column description | Field used to display values in the column |
---|---|---|
Comments | Contains the comments received from staff members and Self Service users. | Comments (Feedback__c) |
Rating | Displays the rating given by Self Service users or staff members while submitting feedback on the knowledge article. For example, Not Helpful. | Rating (Rating__c) |
Is Client Feedback | Provides information about whether the feedback is received from Self Service users. | Is Client Feedback (isClientFeedBack__c) |
Used by Staff # | Displays the total number of times staff members link a knowledge article to any record (incident, change, and problem). | Used by Staff # (Used_by_Staff__c) The count for this field is a total of the count for the following fields:
This field provides information about the number of times staff members link a knowledge article to link any problem record. |
Used in Self Service # | Displays the total number of times the knowledge article has met the needs of Self Service users. | Used in Self Service #(Used_Count_c) The count for this field is updated _only if the value of the following fields is TRUE:
|
Total Usage # | Displays the total count for the following:
| Total Usage # (Formula field in the report) The count for this field is a total of the count for the following fields:
|
Overview of the Knowledge Articles Usage report
As a system administrator, you can use the Knowledge Articles Usage report to review the usage trends of the knowledge articles. You can analyze which knowledge articles are most used by staff members and Self Service users. You can define the high, medium, and low ranges for the Usage by Staff and Usage in Self Service columns in the Knowledge Article Usage report. The following table lists the default values for each range.
Column | Ranges | Default values for ranges |
---|---|---|
Usage by Staff | The ranges (High, Medium, and Low) for this column are based on the total number of times staff members link a knowledge article to any record (incident, change, and problem). | Low: 0 to 10 Medium: 11 to 50 High: Greater than 50 |
Usage in Self Service | The ranges (High, Medium, and Low) for this column are based on the total number of times the knowledge article has met the needs of Self Service users. |
You can update the range by using the defined bucket fields in the report. For more information, see Salesforce Help
The following table describes the columns that are available in the Knowledge Articles Usage report, and the fields that are used to display the values in each column.
Column name | Column description | Field used to display values in the column |
---|---|---|
Knowledge Article: Article ID | Displays the knowledge article ID. | Article # (Article_Number__c) |
Article Type | Displays the type of the knowledge article. For example, FAQ. | Article Type (Article_Type__c) |
Title | Displays the title of the knowledge article. | Title (Title__c) |
Category | Displays the category of the knowledge article. For example, Hardware. | Category (FKCategory__c) |
Usage by Staff | Displays the usage range (High, Medium, or Low) for the knowledge article, based on the total number of times staff members link a knowledge article to any record (incident, change, and problem). | Usage by Staff (Bucket field in the report) |
Used by Staff # | Displays the total number of times staff members link a knowledge article to any record (incident, change, and problem). | Used by Staff # (Used_by_Staff__c) The count for this field is a total of the count for the following fields:
This field provides information about the number of times staff members link a knowledge article to link any problem record. |
Usage in Self Service | Displays the usage range (High, Medium, or Low) for the knowledge article, based on the total number of times the knowledge article has met the needs of Self Service users. | Usage by Self Service (Bucket field in the report) |
Used in Self Service # | Displays the total number of times the knowledge article has met the needs of Self Service users | Used in Self Service # (Used_Count_c) The count for this field is updated only if the value of the following fields is TRUE:
This field provides information about whether the feedback is from Self Service users. |
Viewed in Self Service # | Number of times the knowledge article is viewed in Self Service. | Viewed in Self Service # (View_Count__c) |
Comments
Log in or register to comment.