Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


rmuell01 last won the day on July 31

rmuell01 had the most liked content!

Community Reputation

5 Neutral

My Information

  • Agent Count

Recent Profile Visitors

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

  1. Try pasting the following code into your additional conditions after whatever you have in there: AND computers.LastContact > DATE_ADD(NOW(),INTERVAL -15 MINUTE) So it should look like this: Drives.Size > 20480 and Drives.FileSystem not in ('ERR','CDFS','UNKFS','DVDFS','FAT','FAT32','NetFS') and Drives.free < 4096 and Drives.internal=1 and Drives.Missing !=1 and Drives.Model not like '%USB%' AND computers.LastContact > DATE_ADD(NOW(),INTERVAL -15 MINUTE)
  2. I created a script to test the hard drives on a machine and alert based on the log it generates. Below I have outlined how you can install it: Download Crystal Disk Info 8.2.0 (It may work with a newer one, just have not tested it) Place the zip file in L:\Transfer\Software\Disk Check (I believe everyone should have a L drive for the LabTech share) Extract the zip file attached and Import the XML file attached. Copy the diskinfo.ini file into L:\Transfer\Software\Disk Check Open the script and starting at line 91, you will need to modify the ticket creation settings to your liking. The category number will need to get changed to the category you would like to use Notes about the script: The default threshold on the alerting is 50 (Reallocated sectors, events, or errors) If you would like to change the Threshold, it can be changed from the top variable named @Threshold@ If you get the script failing with it unable to find the threshold.txt file, then CrystalDiskInfo is unable to detect any hard drive and you may need to update the exe used and try to see if the newer update is able to detect the hard drive. Lines 64 through 79 parses through the log to get information if you would like to put it into the ticket. You will need to add some lines to get rid of the extra spaces that are in the variables if you go that route though. The script is supposed to attach the log to the ticket but for some reason it does not attach it in ConnectWise. If you figure out how to get it working, let me know You can manually modify the ini file on specific machines to change the threshold on individual machines and it will keep the threshold in-tact every time the script runs. Crystal Disk Info HDD Test - With Ticket Creation.zip
  3. The white space of the search, where you add your conditions.
  4. You can, its just not a simple answer. You need to use subreports and do a bunch of modifications to the report.
  5. I added VMWare information into my Asset Summary report with the following Query: SELECT `locations`.`ClientID` AS `clientID`, `locations`.`LocationID` AS `LocationID`, `plugin_vm_esxhosts`.`DeviceId` AS `DeviceId`, `plugin_vm_esxhosts`.`DeviceName` AS `DeviceName`, GROUP_CONCAT(DISTINCT `plugin_vm_esxvirtualmachines`.`VmName` SEPARATOR ',') AS `VMList`, `plugin_vm_esxhosts`.`ProductName` AS `ProductName`, SUBSTRING_INDEX(SUBSTRING_INDEX(`plugin_vm_esxhosts`.`OtherInformation`,'Service tag=',-(1)),';',1) AS `SERIAL`, `plugin_vm_esxhosts`.`ProductFullVersion` AS `ProductFullVersion`, `plugin_vm_esxhosts`.`Vendor` AS `Vendor`, CONCAT(`plugin_vm_esxhosts`.`Vendor`,' ',`plugin_vm_esxhosts`.`Model`) AS `ModelString`, `plugin_vm_esxhosts`.`BiosVersion` AS `BiosVersion`, `plugin_vm_esxhosts`.`License` AS `License`, `plugin_vm_esxhosts`.`CpuGhz` AS `CpuGhz`, `plugin_vm_esxhosts`.`NumberCores` AS `NumberCores`, CONCAT((`plugin_vm_esxhosts`.`OverallMemoryUsage` DIV 1024),'GB','/',(`plugin_vm_esxhosts`.`RamMb` DIV 1024),'GB') AS `MEMUsed`, CONCAT(`plugin_vm_esxhosts`.`ProcessorSockets`,'x',' ',`plugin_vm_esxhosts`.`ProcessorType`,' (',(`plugin_vm_esxhosts`.`CoresPerSocket` * `plugin_vm_esxhosts`.`ProcessorSockets`),' Total Cores)') AS `CPU`, CONCAT(`plugin_vm_esxhosts`.`HyperThreadActive`,'/',`plugin_vm_esxhosts`.`HyperThreadAvailable`) AS `HTActiveAvail`, `plugin_vm_esxhosts`.`NumberNics` AS `NumberNics`, `plugin_vm_esxhosts`.`CoresPerSocket` AS `CoresPerSocket`, `locations`.`Name` AS `LocationName`, `networkdevices`.`IPAddress` AS `hostIP`, `plugin_vm_esxhosts`.`LastUpdate` AS `Last Updated`, GROUP_CONCAT(DISTINCT CONCAT(ROUND((`plugin_vm_esxdatastorage`.`CapacityGB` - `plugin_vm_esxdatastorage`.`FreeGB`),0),' GB','/',ROUND(`plugin_vm_esxdatastorage`.`CapacityGB`,0),' GB') SEPARATOR ',') AS `Datastorage` FROM ((((`plugin_vm_esxhosts` JOIN `networkdevices` ON ((`networkdevices`.`DeviceID` = `plugin_vm_esxhosts`.`DeviceId`))) JOIN `locations` ON ((`networkdevices`.`LocationID` = `locations`.`LocationID`))) LEFT JOIN `plugin_vm_esxvirtualmachines` ON ((`networkdevices`.`DeviceID` = `plugin_vm_esxvirtualmachines`.`DeviceId`))) LEFT JOIN `plugin_vm_esxdatastorage` ON ((`plugin_vm_esxvirtualmachines`.`DeviceId` = `plugin_vm_esxdatastorage`.`DeviceId`))) GROUP BY `plugin_vm_esxhosts`.`DeviceId` Because Report Center does not like RAW SQL query's (Or didn't when I created the report). I created a custom view and added it to the report.
  6. You could look at the h_users table in the database. It stores Audit information, including when EDF's were checked. SELECT * FROM h_users WHERE AuditAction=138 The above SQL statement will select all EDF changes (checkbox not data). If you want data it is a different AuditAction ID. What you would do is simply look for when a specific EDF changes and based on the historic date you can run a script against it to uncheck it, which would in-turn take it out of the group. I think it only keeps a history of a few months so if you wanted longer you would need to get more creative.
  7. I created working Mac Install scripts. If anyone would like to use them, they are attached. They are very easy to update versions in the future with variables. Mac Machines - Uninstall OpenDNS Roaming Client.xmlMac Machines - Install OpenDNS Roaming Client.xml
  8. I am looking to do this as well and I unfortunately have no Mac Knowledge that I can apply to this. Does anyone have a script pre-created for this that they can share?
  9. I am not sure what is going on with yours. Mine is hosted in house, but I don't suspect that would be an issue.
  10. I had to uninstall and re-install the extension within control after updating everything. The extension was not loading in Control for some reason.
  11. What version of Automate are you on currently?
  12. I assume you have the Active Directory plugin installed? And you confirmed the views are showing up and there is data in them?
  13. Try to import everything with this .sql file. ADViews.sql
  14. You will only get this error if you dont have the correct nameing for the views or all of the same columns for the views. Can you verify the views show the correct information when you select them in Sqlyog?
  15. This is the correct way to do it. When I exported the report, I figured it would match the report with the imported one, but I guess not.
  • Create New...