Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > User Device Tracker (UDT) > UDT Administrator Guide > Creating and Viewing Reports > Example device availability report

Example device availability report

Table of contents
No headers
Created by Steven Bansil_ret, last modified by Steven Bansil_ret on Jan 31, 2017

Views: 73 Votes: 0 Revisions: 3

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.

  1. Click Start > All Programs > SolarWinds > Alerting, Reporting, and Mapping > Report Writer..
  2. Click File > New Report.
  3. The example calls for a report on availability over the past week, so select Historical Availability Details, and then click OK.


  4. Type My Reports in the Report Group field, and then enter Last Week's Availability as the Report Title.


  5. Select Portrait for the paper orientation, and then confirm that Make this Report available from the Orion website is checked.


  6. Click Select Fields.


  7. Click Browse (...), and then select Add a new field.


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


  9. Click Browse (...), and then select Add a new field.


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

    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.


  11. Click Browse (...), and then select Add a new field.
  12. Click the Field asterisk, and then select Network Nodes > Node Status > Status.


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

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


  14. Click Field Formatting.


  15. Click Status in the Select a Field list, and then change the Column Header entry to Current Status.


  16. Click Status_Icon in the Select a Field list, and then change the Column Header entry to Current Status.
  17. Click Execute SQL Query.

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

  18. Click Select Fields.
  19. Click the sort asterisk on the Status field line, and then select descending.


  20. Click Execute SQL Query to confirm your choice.
  21. Click Browse (...), and then select Add a new field.
  22. Click the Field asterisk, and then select Historical Response Time and Availability > Availability.


  23. Click the sort asterisk on the new line, and then select ascending.
  24. Click Execute SQL Query to view the report.
  25. Click Time Frame.


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


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



  28. If you want to filter your report, click Filter Results and specify filter rules, as on the Select Fields tab.


  29. Click File > Save to save your work.
Last modified
23:42, 30 Jan 2017