Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


WesleyNZ last won the day on January 6 2018

WesleyNZ had the most liked content!

Community Reputation

3 Neutral

My Information

  • Location
  • Agent Count
    3000 - 4000 Agents

Recent Profile Visitors

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

  1. Not effective for locations that have just a single 1 machine. You will want the location monitor triggered for those cases.
  2. This monitor we use only sends an alert to the pager if the machine is offline for 20mins PLUS there still are other computes at the same location that _have_ checked in within the last 5 mins. This stops your 20-30 alerts scenario you describe as it singles out a machine. If everything is offline this monitor is silent (so you need a second monitor for Location offline) The text on the query page reads: Create Temporary Table Tcomp (INDEX (Computerid)) SELECT SubGroupwchildren.computerid,SubGroupwchildren.GroupID,Mastergroups.Priority FROM SubGroupwchildren JOIN Mastergroups USING(groupid) WHERE FIND_IN_SET(SubGroupwchildren.groupid,'1095,1111') AND SubGroupwchildren.ComputerID NOT IN (Select ComputerID from AgentIgnore Where AgentID=17846);Select DISTINCT 'C',computers.computerid,computers.Name as ComputerName,Convert(CONCAT(clients.name,' ',locations.name) Using utf8) As Location, computers.`LastContact` as TestValue,computers.name FROM (computers LEFT JOIN Locations ON Locations.LocationID=computers.Locationid) LEFT JOIN Clients ON Clients.ClientID=Computers.clientid JOIN AgentComputerData on Computers.ComputerID=AgentComputerData.ComputerID WHERE computers.`LastContact` < date_add(now(),interval -20 minute) AND ((Select Count(*) from Computers Where Computers.locationid=locations.locationid AND Computers.LastContact>Date_Add(Now(),Interval -5 minute))>0) AND Computers.ComputerID IN (Select Distinct ComputerID From Tcomp); Drop TEMPORARY Table Tcomp; Hope this helps
  3. 1) VARIABLE SET - in the submenu select SQL Query. Now your SQL answer will go into the variable. Then you just need to put your variable in the email body where you want it. 2) Any variable named differently to any other variable will be a separate variable. I'm confused about your question. Can you post a screenshot of what you got sofar and what it is you're trying to do?
  4. WesleyNZ

    BgInfo Script Doesn't work

    Just try SHELL .. it should work
  5. WesleyNZ

    Patch Management

    I've been gathering notes too; this can get you started perhaps. Theres lots more to learn than these links i'm afraid. https://docs.connectwise.com/ConnectWise_Automate/ConnectWise_Automate_Documentation/070/195 - probly start here http://patchmanagement.org/ - sign up mailing list https://www.askwoody.com/ https://www.ghacks.net/2018/07/23/microsoft-windows-kb2952664-kb2976978/ - this site also has lotsa patching goodies, not just this URL https://www.labtechgeek.com/topic/2028-how-i-got-to-95-patch-efficacy-in-eight-easy-steps/ - bit dated but likely still full of good tips - you can follow a link to https://www.labtechgeek.com/topic/3433-windows-update-delivery-primer-v2017/ from within. I haven't played with this yet but intend to: https://gallery.technet.microsoft.com/scriptcenter/2d191bcd-3308-4edd-9de2-88dff796b0bc same with this: https://docs.microsoft.com/en-us/windows/deployment/upgrade/setupdiag good luck
  6. WesleyNZ

    Automate Agent Licenses Available

    This is a fantastic monitor. A must-have if you are near the license limit.
  7. Dashboard - config - integration - ignite - group monitor management. Is that it per chance?
  8. We use the following to do something similar but for Chocolatey "%WINDIR%\System32\WindowsPowerShell\v1.0\powershell.exe" -nologo -noprofile -Command "$Path='Registry::HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\Chocolatey'; $null=New-Item -Path $Path -Force -EA 0; (@{v='InstallLocation'; t='String'; d=$env:ChocolateyInstall},@{v='NoModify'; t='DWord'; d='1'},@{v='NoRepair'; t='DWord'; d='1'},@{v='SystemComponent'; t='DWord'; d='0'},@{v='NoRemove'; t='DWord'; d='1'},@{v='DisplayName'; t='String'; d='Chocolatey'},@{v='Publisher'; t='String'; d='Chocolatey'}, @{v='Comments'; t='String'; d='Like apt-get, but for Windows.'},@{v='DisplayVersion';t='String';d=choco --version}) | foreach-object {$null=New-ItemProperty -Path $Path -Name $($_.v) -PropertyType $($_.t) -Value $($_.d) -Force -EA 0}"
  9. Is this a virus? How does this question relate to CWA?
  10. WesleyNZ

    IF software Installed on current user

    You could detect the presence (or absence) of a filename instead?
  11. meh haters gonna hate just script the removal .. automation is what Labtech is good at
  12. We didnt move, we now deploy both applications in some places. What i dislike about the cloud interface for MBAM is that policies are tied into groups, not into agents themselves. That means that if you wish to apply a different policy (temporarily or permanently) to a machine in a group, you'll need to create a new group. If you separate your groups by company you're going to have a bad time with having to create many groups PER company. So we're gonna have to put all machines of the same type into the same group - such as "every workstation" kinda thing. But that will have us scratching our heads which company "reception1" will belong to as the MBAM portal won't give it away soo easily. The current suggestion is to do MAC address searches in Labtech/hopefully doesnt happen frequently - joy. MBAM needs to make their portal more friendly for MSPs, other than that, the installation and removal of their product is easy and the MSI and EXE behave well for most OS's.
  13. I found the exclude box to be fairly useless as that will only take effect after a group refresh. (20mins) Admittedly im in the old/previous plugin still. I use this command, which tells the monitor itself to shutup for 15mins (just change the ID to your own internal monitor that deploys it - its called "Webroot - Not Installed"). This 15mins is long enough for offboarding to complete and CWA agent to be uninstalled. UPDATE agents SET LastScan=DATE_ADD(`LastScan`,INTERVAL 15 MINUTE) WHERE AgentID = 187698; *edit: this is a global-pause on the monitor and it will stack if you offboard a pile of machines at once. Just keep that in mind.
  14. WesleyNZ

    Problems changing checkbox in EDF

    all the V_ tables are automatically generated every X minutes. So don't modify those directly. I'm not entirely sure what X is but it's less than 20 minutes. you'll need to figure out from extrafield what you wish to modify in extrafielddata I suspect you will resolve the other questions once you do that (I'd use 1/0 and not true/false)