Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

My Information

  • Agent Count
    Less than 100

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I have an internal monitor using RAWSQL that is returning results under the Query Results tab but for the life of me I can't get it to return results under the Status tab. Hoping someone here can assist possibly. Here is my condition: SELECT IFNULL((SELECT SUM(hfcd.NotAttemptedCount) FROM hotfixcompliancedata hfcd WHERE(hfcd.ComputerID = c.ComputerID)),0) as TestValue, c.computerid as IdentityField, c.ComputerID as ComputerID, acd.NoAlerts, acd.UpTimeStart, acd.UpTimeEnd FROM computers AS c LEFT JOIN AgentComputerData AS acd ON (c.computerid = acd.computerid) WHER
  2. Just an update here. Learned that patch compliance is a misleading metric. If a patch supersedes an older patch then it is not included in the patch compliance metric. So basically from my understanding with the new Windows 10 Cumulative update schedule if we are missing the latest patch then it could potentially cause a 0 score. This is what we are seeing on many systems.
  3. We've been struggling with 0% patch compliance scores for quite some time, and support is not helping anymore so turning to the community to see if anyone else has overcome this issue. The agents are not showing the complete list of approved updates, so when the patch compliance calculation score is done if the agent is only showing say 1 update and that update is missing then the compliance score is showing 0%. When we investigate we typically only see one missing patch. Even when we do a resend of the patch inventory this doesn't seem to help. So we are wasting a lot of help-desk tim
  4. This is great, thanks for sharing. I removed the following portion from the RAWSQL, because the negative values are opposite (Control not running with Automate checking in). I think I'll setup a separate monitor for the negative values to deal with Control not working properly. (TIMESTAMPDIFF(MINUTE,c.LastContact, IFNULL(LastHeartbeatTime, "0000-00-00 00:00:00")) < -6 Is there a way to hide the Control password from the script logs? We have co-it, and the password is shown in the script logs on the endpoint. I'd like to hide this if possible
  5. I had the issue after the fix was published, needed to run the command once to get it down and then after was OK.
  6. Thanks for the tip @Jacobsa I'll test that out. @MGreen you are making me anxious with your reply, why the lol?
  7. The Manage plugin will sync the Company ID over to Automate, and display that in the tree in the Control Center. Problem is, we use an obscured short naming convention and finding the right client on the Automate side can be a pain. Breaking client sync, renaming the Client Name field in Automate, then remapping the client in the Manage plugin seems to work as a temporary workaround. But everytime there is an update to the plugin it reverts back to the Manage Company ID. Support says that's the way it is and to rename the company ID in Manage. Renaming the company ID in manage is goi
  8. Is anyone aware of a users plugin for LabTech? Looking for something similar to RDS Manager, so I could see if there were any active users logged onto the agent. What their idle time was, etc.
  9. Hi all, I've been spending a lot of time working on patch remediation. I believe I have a great handle on it (especially on servers), however I am missing the bigger picture still. I'm trying to get figures on all locations that start with a specific name (we name the locations the name of the contract, i.e. 24x7). A perfect thing for me would be a single report that lists all locations with a percentage of workstations patched in one column, servers in another, and a total. Something we can look at each week. Not even sure where to begin. I'm sure the data is there in the datab
  10. Recently I've been dividing my server agents into groups. All groups have auto-join searches. First, I created a group for HP servers, then grouped them into generation (from G5-Gen9), finally by model (DL 360, ML350, etc...). With this granular approach, I'm hoping to create monitors and scripts to constantly keep the various HP software, firmware, and drivers up to date. I mustered up a link list to their FTP, based on what update is to be applied. Noticed that the most recent updates are always kept in the FTP folder. For example, the IML update is kept in the following path: ft
  • Create New...