Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Archive > 2018Jan2 - Deletes > Reports are unable to work after Report Owner is disabled, removed, or now has limitation

Reports are unable to work after Report Owner is disabled, removed, or now has limitation

Created by James Fahey, last modified by Kevin.Swinson on Jan 02, 2018

Views: 777 Votes: 0 Revisions: 5

Overview

This article describes the issue when Reports are not working after Report Owner is disabled, removed, now has limitations, or has disable session time out enabled.

Environment

  • Orion Core version 2015.X
  • NPM version 11.5.X

Cause 

This issue occurs when the original report owner is disabled, deleted/removed, was implemented limitation or the account has the disable session time out enabled.

Resolution

  1. Reactivate the user account or change the ownership of the report:

    Warning: Changing the ownership may return different results due to various user limitations.

  2. Create a backup of the database.
  3. Click Start > All Programs > SolarWinds Orion > Advanced Features > Database Manager.
  4. Click Add Default Server and expand down to your SolarWinds database.
  5. Double-click the Report Definitions table.
  6. Delete the default query and replace with the following (Note this will change Owner for all Reports): 
    UPDATE ReportDefinitions
    SET Owner = '{new user}'
    WHERE Owner = '{old user}'
  7. Click Execute Query. 
    Notes:
    • For a list of accounts, check the Accounts table.
    • Pay attention to letter casing in account names.
  8. To change individual Report Owners, find selected report, click Enable Table Editing, click the Owner Field and change it to the desire Owner.
  9. After updating the DB, restart Orion Services.

 

Last modified

Tags

Classifications

Public