--find ContainerID--
SELECT * FROM [SolarwindsOrion].[dbo].[Containers] WITH (NOLOCK)
--run the below with BEGIN TRAN--
BEGIN TRAN
UPDATE n
SET n.Unmanaged=1
FROM [SolarwindsOrion].[dbo].[ContainerMemberSnapshots] AS cms WITH (NOLOCK)
INNER JOIN [SolarwindsOrion].[dbo].[Containers] AS c WITH (NOLOCK) ON cms.ContainerID = c.ContainerID
INNER JOIN [SolarwindsOrion].[dbo].[StatusCalculators] AS sc WITH (NOLOCK) ON c.StatusCalculatorID = sc.StatusCalculatorID
INNER JOIN [SolarwindsOrion].[dbo].[StatusInfo] AS si WITH (NOLOCK) ON c.Status = si.StatusId
INNER JOIN [SolarwindsOrion].[dbo].[StatusInfo] AS msi WITH (NOLOCK) ON cms.Status = msi.StatusId
INNER JOIN [SolarwindsOrion].[dbo].[Nodes] AS n WITH (NOLOCK) ON n.NodeID=cms.EntityID
WHERE (c.Owner = 'Core')
AND c.ContainerID = <ID> --substitue the value from SELECT statement above
--if you like the count of servers in that group, uncomment and execute COMMIT TRAN--
--ROLLBACK TRAN;
--COMMIT TRAN;
Thanks.
Mahidhar Vattem
