Your business is about managing people’s IT infrastructure and providing amazing services, but we all know the last systems to get attention are our own. The problem of poor performance and outages can cost you and your client. Today, monitoring, managing, and being connected to the endpoint is more vital than ever. We’re back with updated content for the newest version of Automate, and we’ll give you our exclusive tour under the hood with new tips and updated methods for keeping Automate at its best. (download the presentation)
The below queries are provided as informational. If you use these, you agree to use them at your own risk.
SELECT VARIABLE_NAME, VARIABLE_VALUE FROM information_schema.GLOBAL_STATUS WHERE VARIABLE_NAME = 'MAX_USED_CONNECTIONS' UNION SELECT VARIABLE_NAME, VARIABLE_VALUE FROM information_schema.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'MAX_CONNECTIONS’;
SELECT * FROM information_schema.processlist WHERE command <> ‘Sleep’;
SELECT table_name AS `Table`, ROUND(((data_length + index_length) / 1024 / 1024), 2) `Size (MB)` FROM information_schema.TABLES WHERE table_schema = 'labtech’;
TRUNCATE [TABLE] tbl_name
CREATE TABLE tmp_table1 LIKE table1;
INSERT INTO tmp_table1 SELECT * FROM table1 WHERE table1.conditions=good;
DROP TABLE table1;
RENAME TABLE tmp_table1 TO table1;
SELECT GROUP_CONCAT(AgentName) FROM v_internalmonitors WHERE v_internalmonitors.lastscan > NOW();
SELECT COUNT(*) FROM runningscripts WHERE running=0 AND computerid IN (SELECT computerid FROM computers WHERE lastcontact>DATE_SUB(NOW(), INTERVAL 6 MINUTE));
SELECT COUNT(*) FROM computers c JOIN computerconfig cc USING (ComputerID) LEFT JOIN heartbeatcomputers hc USING (ComputerID) WHERE (c.LastContact > (NOW() - INTERVAL 7 MINUTE) OR hc.LastHeartbeatTime > (NOW() - INTERVAL 60 SECOND)) AND (hc.LastHeartbeatTime IS NULL OR ABS(c.LastContact - hc.LastHeartbeatTime) > 500);
Stack Advisors was working as a remote team long before the world suddenly changed. Today almost everyone has been forced to learn how to work remotely and stay connected. The first few weeks usually are not too bad, but long-term remote work is a new experience for most people. We’ll discuss some of the lessons we’ve learned after working remotely for over eight years. We will include tools used, and more importantly, the process we apply to stay connected and communicating. Join us to hear about hiring remotely, gauging employee satisfaction, adjusting to isolation, addressing the disconnects, and overall, how to stay aligned as a company.