IBM Tivoli TrainingNetcool/Proviso 4.4.3 IBM Tivoli Training Netcool/Proviso 4.4.3 Exporting collected data This IBM Education Assistant module will examine the steps needed to Export Collected Data from reports generated by IBM Tivoli Netcool® Proviso® 4.4.3. Objectives Objectives Upon completion of this module, you should be able to: Use the Export CSV function of Netcool/Proviso reports Identify where that functionality is contained in Reporters Describe the tool used to generate e-mailed reports Identify the third party software required to create PDF report files Upon completion of this module, you should be able to: Use the Export comma separated values functions of Netcool/Proviso reports Identify where that functionality is contained in Reporters Describe the tool used to generate e-mailed reports Identify the third party software required to create PDF report files Assumptions Assumptions You have Netcool/Proviso 4.4.3 installed and running You know your installation’s topology You know SilverStream administrator passwords You have reports populated with data It is assumed that: You have Netcool/Proviso 4.4.3 installed and running You know your installation’s topology You know SilverStream administrator passwords and that You have reports populated with data The export CSV hot spot The export CSV hot spot The example shown is part of the Network Overview Report. It has numerous report segments contained in it. The segments may include a link that will export the data to a Comma Separated Values (CSV) file. The exported data can be used as input into another tool; for example, a spreadsheet. The Network Overview Report is part of the Mib2 Application Pack distribution. It includes a number of individual report segments which have Export CSV hot spots. This is a function of the report defined in the reporter. The underlying data can be exported to a comma separated values (CSV) file. That exported file can be used as input into another tool; for example, a spreadsheet. The reporter viewed from DVNavigator The reporter viewed from DVNavigator SilverStream DVNavigator can be used to view the Network Overview reporter. Network Overview is part of the Mib2 Application Pack. There are a number of other reporters shown under Availability. Customized reporters are often based on existing reporters. The Network Overview report used in the example is part of the Mib2 Application Pack and the reporter can be viewed using the DVNavigator tool. Using DVNavigator the Network Overview report can be found in the Availability folder of the AP Mib2 Pack. While the Network Overview report is a default report it can be used as the basis for customized reports in your Proviso installation. Customizing existing reports is a quick means of deploying new reports needed by Proviso users. Reporter components Reporter components This is the Network Overview reporter. It includes many components. The report example was the first Resource Distribution chart from the Network Overview Report. The chart style for ResDestrib1Chart is known as a Stack Bar Horizontal. The ResDistrib1CSV is the hot spot found on the Network Overview report segment for Resource Distribution. Reporters include a number of components. For every item shown on a report there are underlying reporter sets and style sheets that determine exactly what is to be shown. The graphic shows the relationship of the reporter attributes to the information displayed in the report. The first Resource Distribution chart is the example shown from the Network Overview report. The chart style is contained in the ResDistrib1Chart segment of the Network Overview reporter. The ResDistrib1CSV displays the text for the CSV hot spot. Click to export data Click to export data Click Export CSV from a browser on a Windows® workstation will produce a File Download window. The user can immediately display the data, in the default application for CSV files, or they can save the data for further use. When you click Export CSV from the browser on a Windows workstation, a dialog window is displayed. The exported file can be displayed using the default application for the CSV file format. The user can select to display or save the CSV report depending on their requirements. The CSV file The CSV file The underlying fields and data of the distribution chart contained on the Network Overview report can now be found in the CSV file. The underlying data, displayed as a graphic in the original report, can now be seen. The CSV file contains the data and attributes used to create the original report. From this, a user may select to reuse the data in any manner. If the hot spot for CSV export is on the report segment it can be exported from the browser. It can then be saved to a user selected location. Scheduled report distribution Scheduled report distribution Reports can be delivered to users using e-mail or FTP. Authorized users can schedule reports. There is an icon labeled, Schedule This Report. Reports can be scheduled for delivery using e-mail or FTP. Authorized users can schedule reports for delivery. The authorized users have an additional pair of icons on their DataView reports, labeled Schedule This Report and Manage Reports. These can be used to invoke scheduling tools. When either icon is selected an additional page will be displayed that provides access to the tools. DataView scheduler page DataView scheduler page The DataView Scheduler – Report Layout View is used to manage delivered reports. There are multiple tabs that detail configuration of the delivered reports. Use of this tool is covered in advanced Proviso training and in Proviso documentation. The DataView Scheduler – Report Layout View is used to manage delivered reports and contains a number of options. Presentation details of the reports scheduled for delivery can be customized using the DataView Scheduler tools. These options are contained within the multiple tabs displayed on the DataView Scheduler page. It is beyond the scope of this IEA to detail the use of the scheduler functionality. Use of the DataView Scheduler is covered in advanced Proviso training and in Proviso documentation. Exporting portable document format files Exporting portable document format files Exporting Portable Document Format (PDF) reports requires that an independent software vendor’s PDF server be installed and configured. The product is Corda Highwire Server. For additional information visit the Corda Web site at http://www.corda.com or contact Netcool/Proviso support for assistance. In addition to exporting data in CSV files, files can be exported using the Portable Document Format (PDF) standard. This, however, requires that an independent software vendor’s PDF server be installed and configured. The product that is compatible with SilverStream is Corda Highwire Server. For additional information visit the Corda Web site or, as always, contact Netcool/Proviso support for assistance. Training roadmap for Netcool/Proviso Training roadmap for Netcool/Proviso http://www.ibm.com/software/tivoli/education/edu_prd.html Copy and paste the link provided into the browser of your choice to explore the training roadmap for Netcool/Proviso. Summary Summary You should now be able to: Use the Export CSV functions of Netcool/Proviso reports Identify where that functionality is contained in Reporters Describe the tool used to generate e-mailed reports Identify the third party software required to create PDF report files You should now be able to: Use the Export CSV functions of Netcool/Proviso reports, Identify where that functionality is contained in Reporters, Describe the tool used to generate e-mailed reports, and identify the third party software required to create PDF report files. Feedback Feedback Your feedback is valuable You can help improve the quality of IBM Education Assistant content to better meet your needs by providing feedback. Did you find this module useful? Did it help you solve a problem or answer a question? Do you have suggestions for improvements? Click to send e-mail feedback: mailto:iea@us.ibm.com?subject=Feedback_about_export_coll_data.ppt This module is also available in PDF format at: ../export_coll_data.pdf You can help improve the quality of IBM Education Assistant content by providing feedback. Trademarks