Jump to content

gibsurfer84

Members
  • Content Count

    45
  • Joined

  • Last visited

  • Days Won

    2

gibsurfer84 last won the day on October 7 2019

gibsurfer84 had the most liked content!

Community Reputation

3 Neutral

My Information

  • Agent Count
    200+
  1. Well I figured out how to get the ID of the EDF's: SELECT * FROM extrafield WHERE NAME = "purchase date" Also, I apparently also have a EDF for Warranty Expiration, so I updated the script to fill that out too, here it is: ###################################################### # Warranty Master Sync Script # # This script manually syncs all Purchase Dates and # Warranty Expirations from Warranty Master to # other fields in the labtech database. # # Instructions for use: # Hit CTRL+F9 to execute all commands in SQLyog ###################################################### #Update WarrantyEnd Dates UPDATE computers c, plugin_warrantymaster_aux w SET c.WarrantyEnd=w.ExpiryDate WHERE w.ComputerID=c.ComputerID AND w.ExpiryDate; #Insert/Update Purchase Dates INSERT INTO extrafielddata SELECT w.ComputerID, 539, w.PurchaseDate FROM plugin_warrantymaster_aux w WHERE w.PurchaseDate ON DUPLICATE KEY UPDATE VALUE=w.PurchaseDate; INSERT INTO extrafielddata SELECT w.ComputerID, 540, w.ExpiryDate FROM plugin_warrantymaster_aux w WHERE w.ExpiryDate ON DUPLICATE KEY UPDATE VALUE=w.ExpiryDate; #539 = purchase date EDF #540 = warranty expiration EDF
  2. I was going to figure this out myself but alas, you did the work! Thank you! We are just going to run this nightly as a schedule SQL script in Automate. But the 577, do I need to figure out the ID of the EDF or put the name of the EDF in?
  3. Is this addin still supported? Will it work safely on LT 2020.1?
  4. Thank for looking into it! But I already took that code out of the stock off-boarding script and it doesn't work. It uninstalls off the machine just fine, but it still just an offline computer in the screenconnect console.
  5. Will This work on a screenconnect instance not installed on the LT server? We simply have it on another server.
  6. Is it possible to script this during the offboarding of a computer? We really don't want to give everyone access to screenconnect/control if we don't have to, and not just to delete computers.
  7. So with LT 12 tunnels and redirectors seem to be working great. I was playing around with adding a new redirect for MMC.exe so that we can remotely manage computers using...well...any tool MMC can perform. I really have no idea where to start for this since there isn't really a direct list of ports or services to connect to in a normal sense. Has anyone been able to do this or can share some things to try?
  8. Is there anything that can done so that internal monitors for event logs don't "hang" around. I have a screenshot of our blacklisted events monitor but events that occur in maintenance windows or HOURS earlier still show up, even though the interval says -1 (go back one hour). Or is this typical labtech I am just stuck with?
  9. Does anyone have a script for deleting tickets older than 90 days? If the ticket has reached this age, we would consider it not sync'd with the plugin and worth manually killing in LT.
  10. Well I opened a case with LT support and they had me truncate the windowsupdateetlfiles table (it was 32gb). I had to stop the LTagent service, truncate it using SQYog and then started the service again. LT has been running fine. Since I'm not on LT12 patch 6+, they said this should be done every 2 weeks! This is also apparently a binary "holding area" for data and wiping it out effects nothing, it just goes here and then goes to the proper table. So far I can't find anything data that is missing so I guess we can trust LT support on this one....
  11. As the title states, out of nowhere, it seems my LTAgent.exe on my server is using massive amounts of ram for no reason. Possibly Windows Updates? Nothing else has changed on the server and it seems to crash the server daily during the LT backup time. I'm running LT11 P19, I do plan to move to 12 once the October patch is released, but who know if that would even fix it. Is there a config file somewhere I need to adjust? This is NOT the mysqld.exe, this is the LTAgent service.
  12. Do you mean change it so the command looks like this?: --proxy-server="socks5://%localip1%:1080" %RemoteIP% --incognito --user-data-dir=%temp%\LTChrome --allow-no-sandbox-job
  13. This is pretty neat, and half of the reason to get the paid MSP version.....which I'd like to avoid! Thank you!
  14. Hi the screenshots are no longer available and I was wondering if someone had newer screenshots or if I am on the right track.... I created a Performance Counter Check monitor for Memory and Available MBytes. I use the Less Than/Equal condition and the result is 80\o777 (which should be 80%????). Does this make sense or am I totally wrong here?
  15. I actually found a simple answer for this. Call 3 "Variable Set" script functions set to "Constant" VariableName=TicketCreateSubject and the Parameter=Whatever your ticket subject should be VariableName=TicketCreateBody and the Parameter=Whatever your ticket body should be VariableName=TicketCreateComment and the Parameter=Whatever your ticket body should be (this is for existing tickets getting additional info) Call the script "_System Automation\Functions\Ticket Comment That's it! Stupid easy! I was really surprised how easy it was. It will create a new ticket, or if one exists, append it. I selected the 4 items and made a scriptlet with it so that using this in the future is easy in my scripts.
×
×
  • Create New...