query for list of application names active in insights
Hi @mohamed.yasin.kader - The below will give you the application names which are active in the last hour by default. You can change the query to identify applications that were running over different time periods by adding SINCE and UNTIL.
SELECT uniques(appName) FROM Transactions
could you please givethe query for last six month time period and heap size along with that