Cleanup NTA applications/ports?

JustinY

I have a ton of applications/ports that don't really mean anything and I would love to remove them from NTA.  All these ports have a description of "Port #".  So is there a way to remove all these so they don't get analyzed in bulk(in the database)?

Port 10214	Monitored	10214	All	Any	Any	Disable Delete Edit
Port 10215	Monitored	10215	All	Any	Any	Disable Delete Edit
Port 10216	Monitored	10216	All	Any	Any	Disable Delete Edit
Port 10217	Monitored	10217	All	Any	Any	Disable Delete Edit
Port 10218	Monitored	10218	All	Any	Any	Disable Delete Edit
Port 10219	Monitored	10219	All	Any	Any	Disable Delete Edit
Port 1022	Monitored	1022	All	Any	Any	Disable Delete Edit

JustinY

This identifies all the applications I want to remove.

SELECT * FROM [NetPerfMon].[dbo].[NetFlowApps] WHERE [NetPerfMon].[dbo].[NetFlowApps].AppName LIKE 'Port %' AND AppID != '146160'

I can find all the ports related to these applications with this query.

SELECT * FROM [NetPerfMon].[dbo].[NetFlowAppPorts]INNER JOIN [NetPerfMon].[dbo].[NetFlowApps]ON [NetPerfMon].[dbo].[NetFlowApps].AppID = [NetPerfMon].[dbo].[NetFlowAppPorts].AppIDWHERE EXISTS (SELECT * FROM [NetPerfMon].[dbo].[NetFlowApps] WHERE AppID=[NetPerfMon].[dbo].[NetFlowAppPorts].AppID AND AppName LIKE 'Port %' AND AppID != '146160')

Is deleting them directly OK?