Hi guys. Know about the old problem, when you can't just gather multiple rows and put it in alert body in easy way, but dunno how to solve it.
So I have this simple query:
SELECT TOP 10 *
INNER JOIN (SELECT ID as CID FROM APM_Component
WHERE ComponentOrder=1 and ApplicationID = 728) CID
ON ComponentID = CID
ORDER BY TimeGeneratedUtc DESC
Output is also nice:
But if I use this query in a mail body, I get top string only.
Please help to find a workaround which will allow me to get top 10 rows.