Jump to content
[[Template core/front/profile/profileHeader is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]]

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. ALL child folders? try with RD /S
  2. Create a top level group of type "Exclusions". Put in it, all the machines you do NOT want the user to see. Assign that user (only) the rights to this group.
  3. like when you open the script and click on scriptlog?
  4. Not effective for locations that have just a single 1 machine. You will want the location monitor triggered for those cases.
  5. 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
  6. 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?
  7. Just try SHELL .. it should work
  8. 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
  9. This is a fantastic monitor. A must-have if you are near the license limit.
  10. Dashboard - config - integration - ignite - group monitor management. Is that it per chance?
  11. 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}"
  12. You could detect the presence (or absence) of a filename instead?
  13. meh haters gonna hate just script the removal .. automation is what Labtech is good at
  • Create New...