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 > 2018Jan03 - Deletes > Missing group members after upgrading to Orion Core 2015.1.2

Missing group members after upgrading to Orion Core 2015.1.2

Created by Erica Gill, last modified by Kevin.Swinson on Jan 04, 2018

Views: 948 Votes: 0 Revisions: 4

Overview

Members are deleted from groups after any Orion product upgrade that includes Orion Core 2015.1.2.

Environment

Any upgrade involving Orion Core 2015.1.2

Cause 

Orion Core 2015.1.2 includes a change in datatypes used in tables related to groups that affects group members.

Resolution

Use the Events table to track the affected groups at the time of the upgrade by executing the following SQL query:

SELECT TOP 2000 * FROM Events WHERE NetObjectType LIKE '%C%' AND EventTime >= '<Date_and_time_of_Upgrade>'

for example 

SELECT TOP 2000 * FROM Events WHERE NetObjectType LIKE '%C%' AND EventTime >= '06/06/2015 12:00:00 AM'

 

The query will show entries where members were removed from a group and not re-added. The normal behavior in the 2015.1.2 upgrade should be for group members to be removed and re-added. 

 

 

Last modified

Tags

Classifications

Public