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.]]

Aenabs last won the day on November 11

Aenabs had the most liked content!

Community Reputation

1 Neutral

1 Follower

My Information

  • Location
    Scotland
  • Agent Count
    < 500 Agents
  1. Hi @Matthew Mclaughlin How have you got on? I have made the required modifications and the script is now working as i wanted
  2. Hi @Matthew Mclaughlin Apologies for the late reply, I used the Location Cache Directory for our clients with servers. I configured a shared folder on the client server\workstation which is always online. Shared the folder with read access only so no domain details required. Set the folder location as the cache share in Automate - client location. I then have a copy file command using PS to copy file from cache directory to device. I also tested it using LT copy command and it copies the file from the cache to the specified directory on the agent. For clients without servers or workstations that are always online - I am looking to script a download from Onedrive or any other storage platforms. Only downside to the script is the end user is not notified when the update command is completed. It automatically reboots the device. I am now looking for a way to modify the script to prompt the user to reboot when completed.
  3. Hi @Matthew Mclaughlin Apologies for the late reply, I managed to get the script working (Windows 10 - Install Feature Update). I changed the setup of the script to perform all checks before prompting the logged in user. It was the other way around initially, It prompted the users initial and then did drive space checks. At the moment I have the script pointing to a shared location on the network to download and copy the Windows 10 ISO to the local device and running the install. I have been in touch with Automate and they advised me the Cache function in Automate does not work and they are currently trying to fix it.
  4. Hi @Matthew Mclaughlin I am very interested to see if or how you manage to get this sorted. I am in the process of looking for a way to achieve the Version upgrades for more than 200 endpoints. Interesting I see you are trying to achieve this by using a server location I am trying to use it by using the Cache function in Automate. However we do have some cloud clients who would have the suffer the brunt of having the exe downloaded to each device.
  5. @MGreenThanks for your response. Sorry it took a while to respond back. What you advised worked and I have actioned it, however I made a slight change to make it less persistently painful on the device processors. 1) I created a search function and limited it to the location, laptops and online devices. 2) Created a group under the client and applied the search to populate the devices in group. Devices in group is limited search. 3) Created a script to copy the exe file across to the devices and linked script to the group. 4) Created a remote monitor for the group to run the exe on the device and if it has VPN installed take no action. If VPN is not installed the remote monitor has an alert to install the VPN client using the script. Early days but seems to be all working. Important part there was to limit the group to online devices. Thanks once again.
  6. Sorry for the late reply @MGreen The EXE returns the following results; IF already installed Exe_output - Displays VPN name (LOGGED-IN User RAS Phonebook) Exe_output1 - Displays VPN name (GLOBAL RAS Phonebook) IF not installed Exe_output - Displays OK (LOGGED-IN User RAS Phonebook) Exe_output1 - Displays OK (GLOBAL RAS Phonebook)
  7. Thanks for your reply @MGreen I have a script (VPN Install) that checks is not automated. It is triggered manually on devices by technicians. The function of this script is to check if VPN native adaptor is installed with a specific name eg Work VPN. If the VPN is installed, the script goes on to delete the VPN adaptor on the device and reinstalls the VPN Likewise if the VPN is not installed, the script goes on to create a new VPN adaptor with name Work VPN. This script works a treat and allows our technicians to remotely deploy & update VPN adaptors for our clients. However I am trying to make it smarter. The script has an EXE it downloads & runs to check if a VPN adaptor is installed. Like I mentioned above if the VPN is not installed it proceeds to install the VPN. I am trying to run this EXE against 80 endpoint periodically so it catches any endpoint without a VPN adaptor and puts this device into a group (VPN Not Installed) where i can action the full script to install VPN on any endpoint(s) in the group. I think your suggest about a remote monitor might work however i am struggling to see how i can run the exe periodically e.g weekly, to check endpoints and put these endpoints into a group where i can trigger the script inside Automate to install the VPN. I hope this makes sense? Thanks
  8. Hi Guys, I have a script that installs VPN adaptor for clients using EDF's. It collates the info from the EDF for specified client and pushes out the VPN software(native adaptor) using the info. The script has an EXE that checks the RAS phonebook to see if the VPN already exists via the name and if so for now it overwrites it. I would like to create a group whereby it run this CheckIFVPNExists exe in a script against a whole client and if devices in the client has no VPN installed it populates this group with the list of automate device. I believe I am trying to populate a group using script rather than a search function. Thanks in Advance
  9. Hi Guys, Looking for some help in regards to cluster-aware updating. We have a cluster which failed to patch for 2 months, this was only noticed because the device did not restart and the monitor - Device not restarted in LT Automate triggered. I had to do some leg work to find out why it failed and i believe i have resolved it, however i am trying to see how i can setup a monitor to alert me weekly if the Cluster-aware updating fails. My first thoughts where to create monitors on the device using System Logs Event ID's specifically for the following; EVENT ID: 2004/ Level: Error/ Details: Download failed with HRESULT 0x800704C7 EVENT ID: 2002/ Level: Error/ Details: Scan failed with HRESULT 0x8024402F EVENT ID: 2007/ Level: Warning/ Details: Cancelling Windows Update Agent operation And for success confirmation EVENT ID: 2001/ Level: Information/ Details: Scan for updates succeeded EVENT ID: 2003/ Level: Information/ Details: Download for updates succeeded. EVENT ID: 2005/ Level: Information/ Details: Install for updates succeeded. Installed 1 updates I believe this is the way to go, however looking for any other solutions out there. Suggestions appreciated. Thanks in advance
  10. Hi Guys, Looking for some help in regards to cluster-aware updating. We have a cluster which failed to patch for 2 months, this was only noticed because the device did not restart and the monitor - Device not restarted in LT Automate triggered. I had to do some leg work to find out why it failed and i believe i have resolved it, however i am trying to see how i can setup a monitor to alert me weekly if the Cluster-aware updating fails. My first thoughts where to create monitors on the device using System Logs Event ID's specifically for the following; EVENT ID: 2004/ Level: Error/ Details: Download failed with HRESULT 0x800704C7 EVENT ID: 2002/ Level: Error/ Details: Scan failed with HRESULT 0x8024402F EVENT ID: 2007/ Level: Warning/ Details: Cancelling Windows Update Agent operation And for success confirmation EVENT ID: 2001/ Level: Information/ Details: Scan for updates succeeded EVENT ID: 2003/ Level: Information/ Details: Download for updates succeeded. EVENT ID: 2005/ Level: Information/ Details: Install for updates succeeded. Installed 1 updates I believe this is the way to go, however looking for any other solutions out there. Suggestions appreciated. Thanks in advance
  11. Thanks Gavsto - This worked a treat, however after posting this topic - I couldn't give up and keep trying various methods and got it work using this code "ComputerDatelastContact < DATE_SUB(NOW(),INTERVAL 30DAYS)" in the 'Where SQL' in my last screenshoot Thanks
  12. Hi Guys, I have been using Automate for the last 6 months and so far I have managed to improve my Knowledge and usage of the system. We recently got Report Center installed and I have been working on what I thought to be a simple solution to the Monitor - Agents no checkin for last 30days. Objective: Create an automated report that queries the Computer data and returns data (Agents no checkin for last 30days) I have configured my data source to use the following; Computer table, I can pull information from all clients but cannot restrict this information to only return devices that have not checked in online using the field () I have also tried the following but it has failed to return the required results. I changed the expression for the field ComputerDateLastContact I have added the following ComputerName as a calculated field and set the expression to below; But still no results. To my surprise there is no clear location to restrict this info using SQL codes such as (', Format(AddDays(Now(),-30), 'MMMM d - '), Format(Now(), 'MMMM d, yyyy)')). I also tried to add this to the Where SQL statement in the Query Editor; Please I need help, I have been in touch with ConnectWise support and their response was not great - they only assist with default reports not custom reports. I believe in normal SQL application this would be as easy as - SELECT Computers FROM computers, location, client LEFT JOIN by client WHERE computer.ComputerDateLastContact > 30days I am looking to restrict the data pulled from the database, which I believe is similar to the filter screen on connectwise Report list, see below. However no one in connectwise support is trained extensively to advise. I feel this is a simple filter that can be applied to the report. Any directions or help would be great
  13. Hi Just to mention as well when I try to use the 'LastContact Field' to query LT it does not run. Here is a snippet of my code; SELECT `computerid`,`Name`,`OS` FROM computers WHERE computers.`LastContact`< DATE_ADD(NOW(), INTERVAL -60 DAY) AND `ClientID`=%clientid% For some reason it seems to miss the Where Field and just runs a full search of all the computers in the specific location.
  14. Hi Finally some Answers in regards to questions. I also have a question in regards to creating scripts for this Monitor mentioned by @DarrenWhite99. I am trying to make this monitor more automated and want to see if I can collate a list of all the Agents No checkin for More Than 30 days by client and send a single email to each and every client with a list of all the agents which have not checked in for More Than 30 Days. However I can only manage to send emails per Agent rather than a group of Agents for a single Client
  15. Hi all, New to Automate and learning to handle its vast capabilities of automation. I have a monitor that checks for devices not discovered on the network for a setting time period e.g. 7days for all locations and clients. It works fine it sends an email to the registered email in the alert template when a new device is discovered. However I want to improve the automation with this monitor/alert/script. I would like to create a script that trigger when the alert runs, it collate a list of the devices by "client/location" generated from the monitor and rather than send individual repeated emails to same client, It would email the contact for the client/location with a single full list of the devices not seen at the location. I had a look at running a search and creating search groups but it seems like this would lead to various obstacles. I believe their should be a way to script what I want automate to do so It looks up the list of devices, looks up the client name, groups it and emails it to the contact for that client. Not sure if that make sense. Thanks in advance.
×
×
  • Create New...