Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

Home > Success Center > User Device Tracker (UDT) > UDT Administrator Guide > Alert and Report > View and Edit Reports

View and Edit Reports

Created by Steven Bansil_ret, last modified by Steven Bansil_ret on Jan 23, 2017

Views: 19 Votes: 0 Revisions: 3

Before you can use Report Writer, you must have collected at least a few minutes worth of data in a database that is populated with the devices that you want to monitor.

As an example, the following procedures use the Connected MAC and IP Addresses report:

View a predefined UDT Report

  1. Click Start > All Programs > SolarWinds > Alerting, Reporting, and Mapping > Report Writer.
  2. Click File > Open.
  3. Select Connected MAC and IP Addresses in the list.
  4. Click Execute SQL.
  5. Click Preview.
  6. Click Print if you want a printed copy of the report with the current snapshot of data.

Edit a predefined UDT Report

  1. Click Start > All Programs > SolarWinds > Alerting, Reporting, and Mapping > Report Writer.
  2. Click File > New Report.
  3. The example calls for a report MAC and IP addresses, so select UDT Connected MAC and IP Addresses, and then click OK.

    File:Success_Center/Reusable_content_-_InfoDev/UDT_AdminGuide_reuse/0A0/050/03000005_263x196.png

  4. By default, the Connected MAC and IP Addresses report appears in the UDT Connected Devices Report Group.

    You can modify the group as needed. For example, you define a group called My Reports that runs a variation on this predefined report.

    File:Success_Center/Reusable_content_-_InfoDev/UDT_AdminGuide_reuse/0A0/050/03000006_431x196.png

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

    File:Success_Center/Reusable_content_-_InfoDev/UDT_AdminGuide_reuse/0A0/050/03000007_431x196.png

  6. Click Select Fields.

    File:Success_Center/Reusable_content_-_InfoDev/UDT_AdminGuide_reuse/0A0/050/03000008_431x148.png

  7. Review the current Field selections.
  8. To change the order of defined Field values, right-click the relevant Field value and click Move current field forward (to reposition one slot down in the list) or Move current field backwards (to reposition one slot up in the list).
  9. Click Execute SQL Query to view the reordered report data in the preview window.

    File:Success_Center/Reusable_content_-_InfoDev/UDT_AdminGuide_reuse/0A0/050/03000009_430x127.png

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

  10. Click Select Fields.
  11. For any Field item click the sort asterisk and select the desired sort type (none, ascending, or descending) to affect the sort order for the report.
  12. Click Execute SQL Query to view the report in the resorted form.
  13. Click Time Frame.
  14. Adjust the time frame as needed.(for example, switch to a Relative Time Frame, with the past 7 Days as the data range).

    File:Success_Center/Reusable_content_-_InfoDev/UDT_AdminGuide_reuse/0A0/050/0300000a_432x165.png

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

    File:Success_Center/Reusable_content_-_InfoDev/UDT_AdminGuide_reuse/0A0/050/0300000b_432x64.png

    File:Success_Center/Reusable_content_-_InfoDev/UDT_AdminGuide_reuse/0A0/050/0300000c_432x148.png

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

    File:Success_Center/Reusable_content_-_InfoDev/UDT_AdminGuide_reuse/0A0/050/0300000d_432x63.png

  17. Click File > Save to save your work.
 
Last modified
20:00, 22 Jan 2017

Tags

Classifications

Public