Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

1 Follower

My Information

  • Agent Count

Recent Profile Visitors

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

  1. I was able to upgrade Windows 10 build, but never worked on Windows 7 machines. Tested on old and new build Windows 7 VMs. The email always says: The results for the upgrade are as follows: Script failed because error was given for install: ERROR: General Windows Update failure, try the following troubleshooting steps - Run update troubleshooter - sfc /scannow - DISM.exe /Online /Cleanup-image /Restorehealth - Reset windows update components. (Code: 0x80070490) There are no Windows update issues on both. Any thoughts? Also, has anyone tested on Windows 7? P.S: I'm testing on not activated Windows Pro.
  2. We use both, I can tell that Webroot maybe lighter, but ESET is 100% better than Webroot in detection\protection (Talking about the business version with Automate)
  3. rami

    Use ODBC in Script

    Edit: No more question ... You can delete this topic or keep it if someone finds it in search. I had to create ODBC connection on Labtech server, opened the port 1433 in the firewall and ensured it's opened in SQL server, then run a query with ODBC Connection: Driver={SQL Server};Server=;DNS=MySLQ_Test;Uid=user;Pwd=pass;
  4. As I started reading 1st line of your reply, the full idea came to my mind! I can't believe I didn't think about getting the ComputerID from the group itself. (I've done a lot harder than this one i think lol) SELECT s.computerid FROM subgroups s WHERE s.groupid=1931 That will list all the IDs I want. Then just need to tell the guys here to not run the script on the group, just run it against any agent. I believe this is the easiest way. Thanks Darren! Really appreciate your time writing your reply!
  5. Hi, I have a group of 50+ servers. I need to run a script on them but I don't want this script to run on more than 1 server at the same time. Anyone one thought about a way to do that? The idea is that I want to write into text file the result of the 1st server, then on the same text file the result of the other .. etc. Then after that email this text file instead of emailing 30 text files in 30 emails. Any thoughts or ideas are appreciated.
  6. Do you need more than to go to the internal monitor > Exclusions > Disabled Computers?
  7. try: computers.ClientID = %ClientID%
  8. Michael, Glad to hear that it worked. More info: It worked on this monitor without using JOIN because there is already JOIN, if you go to "Build and View Query" you can see in the query the following: "LEFT JOIN Clients ON Clients.ClientID=Computers.clientid" Reading the queries helped me alot before to modify other monitors. Other thing i wanted to mention, that i would prefer using CLIENTS.CLIENTID instead of CLIENTS.NAME in case someone changed the name later for any reason. You can know the client id by going to Tools > Show ID's. the ID will appear after the name of the client (and the script, location, computer, group..... etc.)
  9. You can do the following in your script: (Not Tested) 1 - If user NOT logged in >>> Sleep 2 - If user is logged in: Function: "Console Show Message" In the Message window field: - Yes/No buttons. 90 second timer on the Yes button: Enter ‘~1~’ then the message (e.g., ~1~We will be rebooting your system in five minutes for updates. Please save your work). - Yes/No buttons. 90 second timer on the No button: Enter ‘~2~’ then the message (e.g., ~2~We will be rebooting your system in five minutes for updates. Please save your work). - OK button with no timer: Enter ‘~3~’ then the message (e.g., ~3~We will be performing updates at 3a, please log off at the end of the business day). Click OK to send the message or Cancel to close the window. 3 - Function: "If User Respond" If Yes/No buttons were used, when the user selects Yes or the timer runs out, the Console will display OK. If the user selects No, the Console will display Cancel. If an OK button with no timer was used, when the user clicks OK, the Control Center Console will display Cancel. Regarding to the 3: If Yes: Script Sleep 5 minutes >>> Sleep If No: Exit script.
  10. in general it's: AND Clients.Name NOT LIKE 'First Company' AND Clients.Name NOT LIKE 'Second Company' But sometimes it requires "JOIN". What monitor exactly you want to write? P.S: you can use "Monitor Target"
  11. I'm not sure what causes the duplicates, but you can read through this topic: viewtopic.php?f=6&t=1900 There is a link there which doesn't work, it's the same link here: https://docs.labtechsoftware.com/knowledgebase/article/12601
  12. rami

    Agent Updates

    You're welcome. Yes, it solved for us this issue on computers that had another versions of .NET
  13. rami

    Agent Updates

    Installing .NET 3.5 was the working solution for us, and also force pushing agent update. I'm not sure why you couldn't import the script, maybe because I exported it from LT 11. But anyways, check the file properties and click "Unlock" then try again. Here are the steps if it didn't work: Note: Exit if non Windows Exit Script Note: Check if .NET 3.5 installed IF [REGISTRY HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v3.5\] Exists THEN Jump to :Installed Note: Enabling Windows Features .NET 3.5 LOG: Enabling Windows Features .NET 3.5 SHELL: Dism /Online /Enable-Feature /FeatureName:NetFx3 and store the result in %shellresult% Note: Check if succeed IF [REGISTRY HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v3.5\] Not Exists THEN Jump to :Failed LOG: Microsoft .NET Framework 3.5 has been successfully installed. LOG: Forcing LT Agent to update LabTech Agent Update Resend Config Resend System Information Exit Script Note: Conditions :Failed - Label LOG: Failed to install "Microsoft .NET Framework 3.5" Please try to install it manually. Script Exit with Error :Installed - Label LOG: "Microsoft .NET Framework 3.5" is already installed on this computer. LOG: Forcing LT Agent to update LabTech Agent Update Resend System Information Resend Config Exit Script
  • Create New...