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

Community Reputation

0 Neutral

My Information

  • Agent Count
    500+

Recent Profile Visitors

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

  1. They want me to give them an admin user for API access with no 2fa. Not an option. How is everyone else handling this?
  2. Hi all! Does anyone know if we can install the Linux agent on a Synology NAS?
  3. Does anyone have a method set up to determine if a client's firewall or server is allowing 3389 through the internet, and alerting on it? Trying to make sure we have a fail safe in place. We only allow RDP over VPN, but just in case a firewall is misconfigured, I want to know about it.
  4. See attached SQL error. Doesn't' run for me. on latest Automate, cloud hosted.
  5. Is there any way to do something similar on a hosted server?
  6. ran: /* SQLyog Community v9.50 MySQL - 5.5.31-log ********************************************************************* */ /*!40101 SET NAMES utf8 */; INSERT INTO `dataviews` (`DataViewID`, `Name`, `FieldList`, `ColumnList`, `HiddenList`, `SQLBody`, `IDColumn`, `SQLWhere`, `FolderID`, `ClientLink`, `ComputerLink`, `SortField`, `GroupField`, `SortOrder`, `FilterControl`, `FormatControl`, `LocationLink`, `IconControl`, `SystemPermission`, `UserClassName`, `GUID`, `SystemPermissionHigh`) VALUES('716','Computer Status and Idle','Contacts.ContactID as `ContactID`, CONCAT(Contacts.FirstName;;\' \';;Contacts.LastName) as `Contact`, Contacts.Email as `Contact Email`, Contacts.Phone as `Contact Phone`, Contacts.Cell as `Contact Cell`, Contacts.Address1 as `Contact Address1`, Contacts.Address2 as `Contact Address2`, Contacts.City as `Contact City`, Contacts.State as `Contact State`, Contacts.Zip as `Contact Zipcode`, Contacts.Fax as `Contact Fax`, Contacts.Pager as `Contact Pager`, Contacts.MSN as `Contact MSN`, Contacts.AIM as `Contact AIM`, Contacts.ICQ as `Contact ICQ`, Contacts.NetBiosName as `Contact Netbios`, Clients.ClientID as `ClientID`, Clients.Name as `Client Name`, Clients.Address1 as `Client Address`, Clients.City as `Client City`, Clients.State as `Client State`, Clients.Zip as `Client Zipcode`, Clients.Address2 as `Client Address2`, CONVERT(IF(Clients.SupportMins>0;;Clients.SupportMins;;IF(Clients.SupportMins=0;;\'None\';;\'Unlimited\')) using UTF8) as `Client SupportMins`, Clients.Phone as `Clients Phone`, Clients.Fax as `Clients Fax`, Clients.Country as `Clients Country`, Locations.LocationID as `LocationID`, CONCAT(Clients.Name;;\'/\';;Locations.Name) as `Client Location`, Locations.Name as `Location Name`, Locations.Address as `Location Address`, Locations.City as `Location City`, Locations.State as `Location State`, Locations.Zip as `Location Zipcode`, Locations.Phone as `Location Phone`, Locations.Fax as `Location Fax`, Locations.Country as `Location Country`, Locations.Router as `Location Router`, Locations.RouterPort as `Location Router Port`, Computers.Version as `Agent OS Version`, Computers.ServiceVersion as `Agent Version`, computers.Comment as `Agent Comment`, Computers.LastContact as `Agent Last Contact Date`, Computers.LastInventory as `Agent Last Inventory Date`, Computers.CPUUsage as `Agent CPU Usage`, Computers.TotalMemory as `Agent Memory Total`, Computers.MemoryAvail as `Agent Memory Avail`, Computers.RouterAddress as `Agent Router Address`, Computers.Uptime as `Agent Uptime`, Computers.DataIn as `Agent Bytes IN`, Computers.DataOut as `Agent Bytes Out`, Computers.MAC as `Agent MAC`, Computers.DateAdded as `Agent Install Date`, Computers.BiosName as `Agent Mainboard`, Computers.BiosVer as `Agent Serial Number`, Computers.BiosFlash as `Agent Bios`, Computers.Name as `Agent Name`, Convert(IF(INSTR(Computers.Username;;\';;\')>0;;LEFT(Computers.Username;;Instr(Computers.UserName;;\';;\')-1);;Computers.Username) using utf8) as `Agent User`, Computers.OS as `Agent Operating System`, Computers.Domain as `Agent Windows Domain`, Computers.BiosMFG as `Agent Manufacturer`, Computers.LocalAddress as `Agent IP Address`, Computers.AssetTag as `Agent Asset Tag`, Computers.AssetDate as `Agent Asset Date`, CONVERT(IF(Computers.LastContact>DATE_ADD(NOW();;interval -7 Minute);;\'Online\';;\'Offline\') using utf8) as `Agent Status`, CONVERT(IF(Computers.OS like \'%darwin%\';;\'True\';;\'False\') using utf8) as `Agent Apple`, CONVERT(IF(Computers.OS like \'%windows ce%\';;\'True\';;\'False\') using utf8) as `Agent Mobile`, CONVERT(IF(Computers.OS like \'%nix%\';;\'True\';;\'False\') using utf8) as `Agent Unix`, CONVERT(IF(Computers.BiosFlash like \'%portable%\';;\'True\';;\'False\') using utf8) as `Agent Laptop`, CONVERT(IF((Computers.Flags & 1)=1;;\'True\';;\'False\') using utf8) as `Agent FasTalk`, CONVERT(IF((Computers.Flags & 16)=16;;\'True\';;\'False\') using utf8) as `Agent Master PC`, CONVERT(IF((Computers.Flags & 32)=32;;\'True\';;\'False\') using utf8) as `Agent Monitors Running`, CONVERT(IF((Computers.Flags & 128)=128;;\'True\';;\'False\') using utf8) as `Agent Probe PC`, CONVERT(IF((Computers.Flags & 256)=256;;\'True\';;\'False\') using utf8) as `Agent ShadowProtect Detected`, Convert(IF(Computers.OS like \'%server%\';;\'Server\';;IF(Computers.BiosFlash like \'%portable%\';;\'Laptop\';;\'WorkStation\')) using utf8) as `Agent Type`, AgentComputerData.Reliablity as `Agent Reliability`, Computers.WindowsUpdate as `Agent Windows Update`, Computers.Windir as `Agent Windows Directory`, IF(computers.`idletime`>0;;SEC_TO_TIME(computers.`idletime`);;\'Not Available\') as `Agent Idle Time`','Client Name,Agent Name,Agent Status,Agent User,Agent CPU Usage,Agent Memory Total,Agent Memory Avail,Agent Uptime,Agent Bytes Out,Agent Reliability,Agent Idle Time,Agent Last Contact Date','','FROM ((((computers JOIN locations ON computers.locationid=locations.locationid) JOIN clients ON computers.clientid=clients.clientid) LEFT JOIN contacts ON computers.contactid=contacts.contactid) LEFT JOIN agentcomputerdata ON computers.computerid=agentcomputerdata.computerid)','Computers.ComputerID','','7','Computers.ClientID','Computers.ComputerID','Computer','Client Name','0','Agent Apple,0,0,,1|Agent Mobile,0,0,,1|Agent Unix,0,0,,1|Agent Laptop,0,0,,1|Agent FasTalk,0,0,,1|Agent Master PC,0,0,,1|Agent Monitors Running,0,0,,1|Agent Probe PC,0,0,,1|Agent ShadowProtect Detected,0,0,,1|','Agent CPU Usage,A,,,2,,0,,%,3,90,1,FF0000,,1|Agent Memory Total,A,,,1,,0,,mb|Agent Memory Avail,A,,,1,,0,,mb|Agent Uptime,A,,,1,,0,, mins|Agent MAC,A,,,2,,0,,|Agent Status,1,FFFFFF,EE0000,2,,0,,,1,Online,0,FFFFFF,00EE00,1|','Computers.LocationID','54|Agent Status|1,Online,49|','0','','6baf6956-058c-4a2c-baf6-fbe7d3780b0f','0'); got: No query(s) were executed. Please enter a query in the SQL window or place the cursor inside a query.
  7. I imported the SQL, but it doesn't show up in my dataview, even after restarting the DB agent, and reloading the control panel.
  8. I ran a Resend Everything on a server to see if this was working and i get this error: Parameters: Tools\recoverkeys\x64\sqlite3-x64.ddl|%ltsvcdir%\recoverkeys\sqlite3-x Output: ERR Could not Download file /Transfer/Tools\recoverkeys\x64\sqlite3-x64.ddl
  9. Yep. Even though I argued it was for the good of the whole community.
  10. Hi everybody, I have some helpful news. I worked with my LT rep, and explained that this is clearly a broken monitor. It simply doesn't work as it should, by detecting all these false positives due to USB drives. She assigned a tech, and Julio figured out an acceptable modification for the "EV - Drive Errors and Raid Failures" Internal Monitor. 1. Open the Internal Monitor 2. Go to the Configuration tab 3. Change the "Additional Condition" text field to the following: Eventlogs.Source like 'disk' and timegen > DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY) AND (eventblacklist.message like '%bad block%' OR eventblacklist.message like '%fail%' OR eventblacklist.message like '%degraded%' OR eventblacklist.message like '%corruption%') This works to grab some more critical issues, as you can see from the text. The tech mentioned that with about 4 hours time, he could modify it so it would truly work as designed, and the monitor could tell us which computer, drive and partition had the issue. My rep explained that they would need to charge for the time (about $1,000.00), so I've declined that. However, if you all think this should be done, please reference this (LT support ticket #5304598) and, for the good of the community, perhaps we can convince them to fix it. Good luck!
  11. Hi everybody, I have some helpful news. I worked with my LT rep, and explained that this is clearly a broken monitor. It simply doesn't work as it should, by detecting all these false positives due to USB drives. She assigned a tech, and Julio figured out an acceptable modification for the "EV - Drive Errors and Raid Failures" Internal Monitor. 1. Open the Internal Monitor 2. Go to the Configuration tab 3. Change the "Additional Condition" text field to the following: Eventlogs.Source like 'disk' and timegen > DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY) AND (eventblacklist.message like '%bad block%' OR eventblacklist.message like '%fail%' OR eventblacklist.message like '%degraded%' OR eventblacklist.message like '%corruption%') This works to grab some more critical issues, as you can see from the text. The tech mentioned that with about 4 hours time, he could modify it so it would truly work as designed, and the monitor could tell us which computer, drive and partition had the issue. My rep explained that they would need to charge for the time (about $1,000.00), so I've declined that. However, if you all think this should be done, please reference this (LT support ticket #5304598) and, for the good of the community, perhaps we can convince them to fix it. Good luck!
×
×
  • Create New...