> In theory you should be able to use [Strapi.IO](https://Strapi.IO) as your API/DB(MySQL) engine and then you would just have to build out your SQL Queries for Grafana. > \- [/u/SW_G40](https://www.reddit.com/r/msp/comments/f0b6bd/connectwise_manage_dashboards/igtkx79/) > Our Grafana pulls data from 2 x MySQL DBs (one of which is labtech), and three sets of data in InfluxDB from different sources. The graph that shows the load on our backup servers (from Telegraf via InfluxDB) with markers for backup start & stop created from a MySQL view of the labtech eventlogs table is one of my favourites for exploring any possible load issue on those servers. > \- [alexheylin](https://discord.com/channels/801971115013963818/1001999840575754350/1004090661974315039) (MSPGeek Discord) # Monitoring ConnectWise Manage > Ok Guys. I finally figured it out with the help of [this document](https://developer.connectwise.com/Products/Manage/Developer_Guide/Authentication). > > Even though it says that the CompanyID+PublicKey:PrivateKey must be encoded in base64, I did not pre-encode. Under Authorization, I chose Basic. I entered in the username: CompanyID+Public Key and for password, I entered the private key. Under the Headers tab, I created a new key named clientID and for the value entered in my client id. > > After this, I was finally able to authenticate with the CW server and pull the API data. Thank you both for your assistance with this. I am not sure why this was racking my head but I am glad we finally figured it out. > \- [/u/Bigsease30](https://www.reddit.com/r/ConnectWise/comments/w67cgh/hosted_cw_manage_and_grafana/ihkm1tj/) # Monitoring Scripts 1. ### Jobey:APP _—_ Yesterday at 8:25 PM Does anyone run any internal monitors looking at scripts that run more than X amount of time? I've discovered a few that seem to have hung and Automate thinks they are still running (showing up in the data view), but they aren't showing on the agents as "running". I'd like to monitor for this type of issue and kill them (if they are still running - possibly a runaway script) or clear the "Running Scripts Data Summary" if they aren't. (edited) 2.  ### wesleynz:APP _—_ Yesterday at 11:44 PM no but i do have 2 grafana dashes that relate .. the first one is running scripts: `SELECT runningscripts.ScriptID, lt_scripts.scriptname as 'Script Name', COUNT(runningscripts.scriptid) as Count FROM runningscripts, lt_scripts WHERE runningscripts.scriptid = lt_scripts.scriptid GROUP BY scriptid ORDER BY COUNT(*) DESC;` 3. _[_11:45 PM_]_ the other one is called most scripts ran today: ``SELECT lts.`Scriptname` AS `Script`, COUNT(*) AS `cnt` FROM `lt_scripts` lts JOIN h_scripts hs USING (ScriptID) WHERE hs.`HistoryDate` >=CURDATE() AND scriptstatus != 2 GROUP BY `Script` ORDER BY `cnt` DESC;``