Application Template to Group - What table stores this info?

natetech

I am in the middle for a SolarWinds bare metal migration.

I have around 700 application templates to assign to the same number of Dynamic groups.

I know that there is no way to create a link via SWIS SDK.

I tried to Group some of the dynamic groups, but applications would not assign.

Does anyone know where the App Template to Group assignments is located in SWIS or SQL?

I am hoping I can do something with a direct DB update.

natetech

I figured it out...TemplateGroupAssignment

I was able to insert TemplateID and Destination Group ID, along with the other table entries, successfully.

I group names SM plue the Application Template name, and used this query 

Select C.ContainerID As GroupID, T1.TempID As TemplateID, -3 as AgentWmiCredentialsID, -4 as SnmpIcmpCredentialsID, 'True' as AutoAssign,
'True' as AutoDelete, 'True' as ServersOnly, '2021-04-26 20:57:53.87' as CreationTime
From (
Select A.ID as TempID, Concat('SM ',A.Name) as TemplateName
From [dbo].[APM_ApplicationTemplate] A
Where A.Name not like 'SolarWinds%'
and Concat('SM ',A.Name) in
(Select Name from [dbo].[Containers])
) T1
Inner Join [dbo].[Containers] C on T1.TemplateName = C.Name

Instead of creating an insert statement, I just pasted the output into the TemplateGroupAssignment table using SSMS