Network Management

Ad-hoc Reporting is missing in UDT 3.1 and later releases

Ad-hoc reporting is deprecated with UDT version 3.1. If you are performing a clean install of UDT 3.1, Ad-hoc reporting will not be available. If you are upgrading to UDT 3.1 from an earlier release, Ad-hoc reporting will be available. This knowledge base article provides instructions for adding AD-hoc reporting to UDT 3.1 and instructions for removing it.

First published date

11/29/2018 10:53 PM

Last published date

4/24/2019 3:29 PM

Overview

Ad-hoc reporting is deprecated with UDT version 3.1 and later. If you are performing a clean install of UDT 3.1, Ad-hoc reporting will not be available. If you are upgrading to UDT 3.1 from an earlier release, Ad-hoc reporting will be available. This knowledge base article provides instructions for adding AD-hoc reporting to UDT 3.1 and instructions for removing it. 

Product section

User Device Tracker

Resolution

To enable Ad-hoc reporting: 

  1. Login to SQL Server Management Studio, select your UDT database and perform the following:
  2. Click New Query, enter [UDT Database Name].[dbo].[swsp_UDTEnableAdhocReporting] in the query window and click Execute.
  3. Refresh the web console.


To disable Ad-hoc reporting: 

  1. Login to SQL Server Management Studio, select your UDT database and perform the following:
  2. Click New Query, enter [UDT Database Name].[dbo].[swsp_UDTDisableAdhocReporting] in the query window and click Execute.
  3. Refresh the web console.


Note: [UDT Database Name]should be replaced by the database name.