Jump to content

scythe000

Members
  • Content Count

    29
  • Joined

  • Last visited

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

    Synology Agent?

    Hi all! Does anyone know if we can install the Linux agent on a Synology NAS?
  2. scythe000

    Detect public RDP?

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

    Major Windows 10 Updates (Anniversary, Creators)

    @davidc It just worked for me
  4. scythe000

    Domain Computers without Automate Agent

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

    "Flu Shot" Antivirus & Malware plugin for LabTech

    Is this plugin still being updated?
  7. scythe000

    Computer Status and User Idle Time dataview

    Works perfect, thanks!
  8. scythe000

    Computer Status and User Idle Time dataview

    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.
  9. scythe000

    Computer Status and User Idle Time dataview

    Weird, i'll try importing again
  10. scythe000

    Computer Status and User Idle Time dataview

    I imported the SQL, but it doesn't show up in my dataview, even after restarting the DB agent, and reloading the control panel.
  11. scythe000

    Discover Keys - Product Key Collector

    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
  12. Yep. Even though I argued it was for the good of the whole community.
  13. 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!
  14. 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!
  15. 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!
×