Submit a ticketCall us

Quickly Address Software Vulnerabilities
Patch Manager is an intuitive patch management software which extends the capabilities of WSUS and SCCM to not only patch Windows® servers and workstations, and Microsoft® applications, but also other 3rd-party applications which are commonly exploited by hackers. Learn more about our patch management solution.

 

Home > Success Center > Archive > 2017June05 - IPAM > SolarWinds Orion Core Components > Example report

Example report

Table of contents
No headers
Created by Nanette.Neal, last modified by Nanette.Neal on Jul 25, 2016

Views: 7 Votes: 0 Revisions: 2

The following procedure generates an example report of network device availability information over the previous week. The final report is sorted so that the worst errors are viewed first. Down nodes that are still down are at the top with all devices listed in order of increasing availability.

Note: At any point during the creation of a report (or perhaps at many points), you may save what you have done by clicking File  > Save. The first time you save you must give your report a filename or accept the default, which will be the report title that you assign in the following procedure.

To generates an example report of network device availability information:

1. Click File  > New Report.

2. The example calls for a report on availability over the past week, so select Historical Availability Details, and then click OK.

3. Type My Reports in the Report Group field.

4. Enter Last Week's Availability as the Report Title.

5. Select Portrait for the paper orientation.

6. Click Select Fields.

7. Click the ellipsis, and then select Add a new field.

8. Click the Field asterisk, and then select Network Nodes  > Node Details  > Node Name.

9. Click the ellipsis, and then select Add a new field.

10. Click the Field asterisk, and then select Network Nodes  > Node Status  > Status.

11. Click the ellipsis, and then select Add a new field.

12. Click the Field asterisk, and then select Network Nodes  > Node Status > Status Icon.

Note: While this field makes a distinct visual difference for a report viewed in color, it will make little or no difference if printed in black and white.

13. Click Execute SQL Query to view the report data in the preview window.

14. If you want to see the status icon before the status description, click Status Icon to move Browse  to the Status Icon line, and select Move Current Field Backward.

15. Click Execute SQL Query.

Note: The report should show information about both current and historical status. Current status entries must be relabeled to avoid confusion.

16. Click Field Formatting.

17. Select Status from the field list.

18. Change the Column Header entry to Current Status.

19. Select Status_Icon from the field list.

20. Change the Column Header entry to Current Status.

21. Click Execute SQL Query.

Note: Column widths are adjustable. To change a column width, place your cursor on the column divider and drag it to a different position.

22. Click Select Fields.

23. Click the sort asterisk on the Status field line, and then select descending.

24. Click Execute SQL Query to confirm your choice.

25. Click the ellipsis, and then select Add a new field.

26. Click the Field asterisk, and then select Historical Response Time and Availability  > Availability.

27. Click the sort asterisk on the new line, and then select ascending.

28. Click Execute SQL Query to view the report.

29. Click Time Frame.

30. Select Relative Time Frame, type 7 in the text field, and then select Days from the list.

31. If you want to break down the report day-by-day, click Summarization and specify your choices.

32. If you want to filter your report, click Filter Results and specify filter rules.

33. Click File  > Save to save your work.

Last modified
15:22, 25 Jul 2016

Tags

Classifications

Public