About saving and sharing reports
In the last section you learned the basics of searching in Splunk Enterprise, how to use a subsearch, and how to add field from lookup tables. This section takes you through saving searches and more search examples.
Save as a report
1. Select the time range Yesterday and run the following search. (This is the same search you ran in the previous topic "Use field lookups").
sourcetype=access_* status=200 action=purchase [search sourcetype=access_* status=200 action=purchase | top limit=1 clientip | table clientip] | stats count AS "Total Purchased", dc(productId) AS "Total Products", values(productName) AS "Product Names" by clientip | rename clientip AS "VIP Customer"
Note: If your search does not return results, increase the time range of the search. For example, you can run search over the time range Last week or All Time.
2. Click Save as above the search bar and select Report.
This opens the Save as Report dialog.
3. Enter a Title VIP Customer.
4. (Optional) Enter a Description Buttercup Games most frequent shopper.
5. Because the report is a table, for Visualization, click None.
6. To include a Time Range Picker, click Yes.
7. Click Save.
The Your report has been created dialog box opens.
There are other options in this window.
- Continue Editing lets you refine the search and report format.
- Add to dashboard lets you add the report to a new or existing dashboard.
- View lets you view the report.
8. Click View.
View and edit saved reports
You can view and edit the saved report from its report view.
1. In the report view for "VIP Customer", click Edit.
You can open the report in the search view and edit the saved search's description, permissions, schedule, and acceleration. You can also clone, embed, and delete the report from this menu.
2. Click More Info.
You can view and edit different properties of the report, including its schedule, acceleration, permissions, and embedding.
3. Look at the time range picker, located to the top left.
You saved this report with a time range picker. The time range picker lets you change the time period to run this search. For example, you can use this time range picker to run this search for the VIP Customer Week to date, Last 60 minutes, Last 24 hours just by selecting the Preset time range or defining a custom time range.
You can access your saved reports using the app navigation bar.
1. Click Reports to open the Reports listing page.
When you save a new report, its Permissions are set to Private. This means that only you can view and edit the report. You can allow other apps to view, or edit, or view and edit the reports by changing its Permissions.
1. Under Actions for the VIP Customer report, click Edit and select Edit Permissions.
This opens the Edit Permissions dialog box.
2. In the Edit Permissions dialog box, set Display For to App and check the box under Read for Everyone.
This action gives everyone who has access to this app the permission to view it.
3. Click Save.
Back at the Reports listing page, you see that the Sharing for VIP Customer now reads App.
About report acceleration
If your search has a large number of events and is slow to finish, you might be able to accelerate the resulting report so it finishes faster when you run it again. This option is available when the report produced by your search qualifies for acceleration. The "VIP Customer" report does not qualify for acceleration, because it is based on a transforming search.
The sample data used in this tutorial is limited in volume and the searches throughout are run against data for one day (Yesterday). Checking this box will not affect the speed of this search and all upcoming searches you save in this Tutorial.
Read more about report acceleration and the kinds of searches that enable reports to qualify for report acceleration in the "Accelerate Reports" topic in the Reporting manual.
Continue to run more search examples and save more reports.
Use field lookups
More searches and reports
This documentation applies to the following versions of Splunk® Enterprise: 6.2.0, 6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.2.6, 6.2.7, 6.2.8, 6.2.9, 6.2.10, 6.2.11, 6.2.12, 6.2.13