Jump to content

Aenabs

Members
  • Content Count

    6
  • Joined

  • Last visited

Community Reputation

0 Neutral

1 Follower

My Information

  • Location
    Scotland
  • Agent Count
    < 500 Agents
  1. Aenabs

    Report Center Date Format

    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
  2. Aenabs

    Report Center Date Format

    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
  3. Aenabs

    Remove Computers based on last checkin

    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.
  4. Aenabs

    Remove Computers based on last checkin

    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
  5. 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.
  6. Aenabs

    Monitor /Alert/Script template

    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. 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 when the monitor is trigger the alert runs. I want this script to collate a list of the devices by "client/location" generated from the monitor and rather than send individual repeated emails to same client(email field) I would like it to input all the devices not seen for more than eg 7days into the automate email and email the client(selected email field). 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.
×