Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

My Information

  • Agent Count
    Less than 100
  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) WHERE IFNULL((SELECT SUM(hfcd.NotAttemptedCount) FROM hotfixcompliancedata hfcd WHERE(hfcd.ComputerID = c.ComputerID)),0) > 100
  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 time with this. We have about 50 rotating agents in the 1600 we manage that seem to keep having this problem, and when we send reports that show compliance score we obviously have to deal with the "aren't you patching these computers?" questions from our clients which is really becoming frustrating. To make things simple to manage we only use the one approval policy and group for workstations in patch manager. Patch history on the agents appears OK, I can open patch manager and view the history of the agent.
  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 going to be a big hassle for us. Anyone have any workarounds for this?
  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 database, I just need to pull it out. Thanks for any help
  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: ftp://ftp.hp.com/pub/softlib2/software1/sc-windows/p2010791246/v112694/cp######.exe (where ### changes based on version). HP be dammed with their site restrictions and 'support requirements'! (please note: we always recommend to our customers to purchase care packs, but hate the requirements on the site for downloads) Anyways, I'm working towards scripting each and every download, from drivers and firmware to software. Then hopefully I can take this a step further and automate it, so it can be scheduled and rolled out quite simply. Wondering if anyone has headed down this path before, and perhaps has done a bit more legwork than I? Also, any feedback is appreciated (I am really new with LabTech still).
  • Create New...