SELECT  cd.Name AS ComponentName
	,cd.[Key] AS ComponentSetting_Name
	,REPLACE(REPLACE(REPLACE(cd.[Value], CHAR(10), ' '), CHAR(13), ' '), CHAR(9), ' ') AS ComponentSetting_Value
	,a.Name AS ApplicationTemplate
	,n.Caption AS ServerName
	,s1.ComponentDisabled
FROM APM_ComponentDetails cd
	LEFT OUTER JOIN APM_Applications a ON cd.ApplicationID = a.ID
	LEFT OUTER JOIN Nodes n ON a.NodeID = n.NodeID
	JOIN (SELECT cd2.ID
			,cd2.[Key]
			,cd2.[Value] AS ComponentDisabled
		FROM APM_ComponentDetails cd2
		WHERE cd2.[Key] = '__Disabled'
	) s1 ON cd.ID = s1.ID
WHERE cd.[Key] IN ('SqlQuery','InitialCatalog','SqlServerInstance','Counter','Instance','Category','Url','EntrySource', 'LogName', 'EntryID')
	AND n.AppAdmin = 'Recruiter'
	AND n.CloudPartner = 'Amazon Web Services'
	AND s1.ComponentDisabled <> 'True'
GROUP BY n.Caption, a.Name, cd.Name, cd.[Key], cd.[Value], s1.ComponentDisabled
ORDER BY n.Caption, a.Name, cd.Name