nkalapodis

Works well but needs some tweaks for the updated CWA since this monitor was originally created. See the Comments.

I had to make a few changes to this monitor for the current version of CWA 2022.5 (Patch 5) 1: The Additional Condition statement, you need to replace the 1 in (MAX(computerid),1) so if your Automate Server's Agent ID is 1234 you would put (MAX(computerid),1234) 2: Default the monitor user 90 free licenses as the default trigger and doesn't care what you put in the Result field for number of free licenses. In my testing I put 87 but the alert always said 90. That is happening because of this query in the Identify Field (SELECT 10*CEILING((MAX(DynamicClients)-COUNT(*))/10) FROM computers JOIN config) It always selects 90. so I updated it to (SELECT CEILING((MAX(DynamicClients)-(5450))) FROM computers JOIN config) That 5450 is our total count of agents (5500) minus the number of licenses I want it to alert against, so I want it to alert when we get to less than 50 do 5500-50 = 5450. Now my ticket shows the proper data.