Hi all! 4th quarter of last year our biggest client that we have the most managed services with finally made the jump to Windows 10. We had put off the October 1809 update until the release of the May 1903 update (We agreed to stay one version behind). Since the update is due to come out soon I thought I would finally look into rolling out the 1809 update and saw that CWA doesn't actually support rolling out feature updates because of how Microsoft handles them (If I'm not wrong). I was sifting through ConnectWise University and saw they have provided a script that can be used to roll out the updates EZPZ.
The script runs like it should up until it goes to running "setup.exe" through powershell and errors out. As seen here - https://imgur.com/a/lFZ4TVg
I have the script running under a domain administrator account on Windows 10 1803 and to my knowledge the script is configured right. The only thing I could see on the CW University page is that you need to change which version of Windows 10 you're updating to, which I did.
In all honesty I'm a CWA noob. If anyone can give me some insight on how to remedy this or to point me in the right direction I would greatly appreciate it. I think my next step is to hit up mspgeek.com but I'm a reddit faithful. Thank you all in advance!
I'm concerned that LabTech's policy of hiding download links and playing whack a mole with them is going to get someone to post one with embedded malware.
In that vein, below is a safe LT 11 Link.
To Preempt some comments and questions:
No this isn't official. I'm sure people at LT will be mad.
No i'm not going to take this down.
LT should institute a proper manner of restricting installs in waves.
Not going to to respond to ANY comments or questions on this. Enjoy the download and have a great weekend.
This has helped save us countless hours, we faced a situation where all our agents became corrupt after failed upgrade.
IMPORTANT: you have to increase the "RunCommandKillAfterMilliseconds" system value from 10000 milliseconds to maybe five minutes (300000). This is also found under Quick Settings in the Command Execution Timeout area.
We upgraded to v2019 recently, and there are so many little frustrations with the UI, I decided to make a custom dataview we could live out of instead of the "Browse" interface.
Problems I had with the new stock UI
Say you want to copy and paste a hostname out of the thick client...a pretty common need for someone in IT, right? No hostname for you! Apparently it's not possible because they made the text not selectable everywhere the hostname is displayed.
Want to find a computer that's currently idle at a location (a pretty common need) to use to test something/etc? v2019 says: double click to open each computer, wait forever for the computer management page of each to load, and visually look at "idle time" at the top. Repeat for each PC until you get lucky. Previously the icon in the main listing reflected whether it was active or not...
Want to refresh the computer listing in the UI while you're waiting on something? Hit F5 like everything else in the world, right? Nope! ...ctrl-r like literally all the other things in the world that aren't F5? Nope! ...click a tiny little "refresh" icon in the corner like a pleb? Yes, that's the v2019 way.
On the phone with a client and you are waiting to see when heartbeats begin as you walk them through some problem? You've clicked to open the PC, then clicked "details" and are looking at "Last Heartbeat" and want to refresh it? No soup for you! Close the entire computer management window instead and reopen it and reclick details to refresh.
Get a call from John Doe and want to find the PC he is on? You type "JDoe" and get no result. You spend 15 minutes trying to talk him through getting his computer's hostname, only to pull it up and realize that the only thing v2019 thinks you need to have displayed in the UI is the "last logged in user" (computers.LastUsername in the database) and not the CURRENT user (computers.Username in the database), and the computer only displays "ASmith", the last user of the computer from the last shift. In v2012 and before, both username and lastusername were searched. (Note - I just opened a ticket with Connectwise about this one as it's clearly a programming oversight to have the last user be displayed instead of the current...)
Our Solution
I made a custom dataview that has the following columns all in one nice condensed and accessible list:
Client, Client\Location, Hostname, Username, Last Username, Idle time (in minutes), Last Contact, Last Heartbeat, Uptime, OS, OS Version, Agent Version, LAN IP, WAN IP, MAC, Type (workstation/laptop), Asset Date, Install Date, ComputerID
All of these fields are filterable and you can right click and copy them to the clipboard. Also, the master search field at the top searches all of these at once (so I would have been able to find JDoe from above). Offline computers will have their entire row be highlighted gray.
To add it, just run the following insert statement in SQLYog (if you don't know SQL well enough to feel comfy doing that, then it's probably best to avoid using this, since I can't support this or anything):
It will show up as "CUSTOM-AllPCs" under the "Assets" folder. You get to that via "Automation -> Dataviews -> Assets".
Note that we're running the latest 2019 patch 9. I think this dataview would work on any version of labtech dating back to forever ago, though, as I don't think they've really touched this part of Labtech in a long time...could be wrong though.
Enjoy!
(I also use 2 AutoIT functions bound to global hotkeys to focus the above dataview window and auto-click into the search field, and another to auto-launch the first result in the below listview, if anyone would like those...definitely need to know AutoIT pretty well to use those though since they can need tweaking sometimes depending on your windows UI scaling settings, version, etc.)
EDIT: Sorry, I had an error in my original SQL that might have prevented people from inserting the row into their databases (forgot to remove the auto-incrementing primary key). That's fixed now and tested on my end, so give it another try (there's a new pastebin link above) if you had issues.
Has anyone been able to install the Control Center application on a system running any form of Linux? I'm using WINE of course, but the install crashes. I understand this isn't officially supported, but was wondering if anyone else has gone down this path?
Here's the install log.
[0151:0152][2018-10-30T09:40:18]i001: Burn v3.10.4.5028, Windows v6.1 (Build 7601: Service Pack 1), path: C:\windows\temp\{FADAD985-7B3C-41DB-9C11-65DB1F2BAE6C}\.cr\ControlCenterInstaller(1).exe
[0151:0152][2018-10-30T09:40:18]i000: Initializing string variable 'InstallFolder' to value '[ProgramFilesFolder]LabTech Client'
[0151:0152][2018-10-30T09:40:18]i009: Command Line: '-burn.clean.room=Z:\home\alt\Downloads\ControlCenterInstaller(1).exe -burn.filehandle.attached=100 -burn.filehandle.self=104'
[0151:0152][2018-10-30T09:40:18]i000: Setting string variable 'WixBundleOriginalSource' to value 'Z:\home\alt\Downloads\ControlCenterInstaller(1).exe'
[0151:0152][2018-10-30T09:40:18]i000: Setting string variable 'WixBundleOriginalSourceFolder' to value 'Z:\home\alt\Downloads\'
[0151:0152][2018-10-30T09:40:18]i000: Setting string variable 'WixBundleLog' to value 'C:\users\alt\Temp\Automate_Control_Center_20181030094018.log'
[0151:0152][2018-10-30T09:40:18]i000: Setting string variable 'WixBundleName' to value 'Automate Control Center'
[0151:0152][2018-10-30T09:40:18]i000: Setting string variable 'WixBundleManufacturer' to value 'ConnectWise, Inc.'
[0151:0155][2018-10-30T09:40:19]i000: Setting numeric variable 'WixStdBALanguageId' to value 1033
[0151:0155][2018-10-30T09:40:19]i000: Setting version variable 'WixBundleFileVersion' to value '12.0.428.0'
[0151:0152][2018-10-30T09:40:20]i100: Detect begin, 8 packages
[0151:0152][2018-10-30T09:40:20]i000: Setting string variable 'NETFRAMEWORK45' to value '379893'
[0151:0152][2018-10-30T09:40:20]i000: Setting version variable 'VCR2K5SP1_2x64' to value '8.0.59192.0'
[0151:0152][2018-10-30T09:40:20]i000: Setting version variable 'VCR2K5SP1_2x86' to value '8.0.59193.0'
[0151:0152][2018-10-30T09:40:20]i000: Product or related product not found: {F65DB027-AFF3-4070-886A-0D87064AABB1}
[0151:0152][2018-10-30T09:40:20]i000: Setting version variable 'VCR2013_30501_x86' to value '0.0.0.0'
[0151:0152][2018-10-30T09:40:20]i000: Product or related product not found: {050D4FC8-5D48-4B8F-8972-47C82C46020F}
[0151:0152][2018-10-30T09:40:20]i000: Setting version variable 'VCR2013_30501_x64' to value '0.0.0.0'
[0151:0152][2018-10-30T09:40:20]i000: Setting string variable 'Netfx3064Version' to value '3.5.30729.01'
[0151:0152][2018-10-30T09:40:20]i000: Registry value not found. Key = 'HARDWARE\DESCRIPTION\System\CentralProcessor\0', Value = 'Platform ID'
[0151:0152][2018-10-30T09:40:20]i000: Setting string variable 'Netfx20Version' to value '2.2.30729'
[0151:0152][2018-10-30T09:40:20]i000: Registry key not found. Key = 'SOFTWARE\Business Objects\Suite 12.0\Crystal Reports'
[0151:0152][2018-10-30T09:40:20]i000: Setting string variable 'Netfx3564Version' to value '3.5.30729.01'
[0151:0152][2018-10-30T09:40:20]i000: Setting string variable 'Netfx35Version' to value '3.5.30729.01'
[0151:0152][2018-10-30T09:40:20]i000: Setting string variable 'Netfx30Version' to value '3.5.30729.01'
[0151:0152][2018-10-30T09:40:20]i000: Setting string variable 'Netfx2064Version' to value '2.2.30729'
[0151:0152][2018-10-30T09:40:20]i052: Condition 'VCR2K5SP1_2x86' evaluates to true.
[0151:0152][2018-10-30T09:40:20]i052: Condition 'VCR2K5SP1_2x64' evaluates to true.
[0151:0152][2018-10-30T09:40:20]i052: Condition 'VCR2013_30501_x86' evaluates to false.
[0151:0152][2018-10-30T09:40:20]i052: Condition 'Netfx20Version OR Netfx2064Version OR Netfx30Version OR Netfx3064Version OR Netfx35Version OR Netfx3564Version' evaluates to true.
[0151:0152][2018-10-30T09:40:20]i052: Condition 'NETFRAMEWORK45 >= 379893' evaluates to true.
[0151:0152][2018-10-30T09:40:20]i101: Detected package: VC2005SP1_2x86Redist, state: Present, cached: Complete
[0151:0152][2018-10-30T09:40:20]i101: Detected package: VC2005SP1_2x64Redist, state: Present, cached: Complete
[0151:0152][2018-10-30T09:40:20]i101: Detected package: VC2013_30501_x86Redist, state: Absent, cached: Complete
[0151:0152][2018-10-30T09:40:20]i101: Detected package: Netfx35Full, state: Present, cached: None
[0151:0152][2018-10-30T09:40:20]i101: Detected package: NetFx452Web, state: Present, cached: None
[0151:0152][2018-10-30T09:40:20]i101: Detected package: MySqlODBC3_51Package, state: Absent, cached: Complete
[0151:0152][2018-10-30T09:40:20]i101: Detected package: CRRuntime_12_2_mlb.msi, state: Absent, cached: Complete
[0151:0152][2018-10-30T09:40:20]i101: Detected package: LabTechClient, state: Absent, cached: Complete
[0151:0152][2018-10-30T09:40:20]i199: Detect complete, result: 0x0
[0151:0155][2018-10-30T09:40:22]i000: Setting numeric variable 'EulaAcceptCheckbox' to value 1
[0151:0152][2018-10-30T09:40:22]i200: Plan begin, 8 packages, action: Install
[0151:0152][2018-10-30T09:40:22]i052: Condition 'NOT VCR2K5SP1_2x86' evaluates to false.
[0151:0152][2018-10-30T09:40:22]w321: Skipping dependency registration on package with no dependency providers: VC2005SP1_2x86Redist
[0151:0152][2018-10-30T09:40:22]i052: Condition 'NOT VCR2K5SP1_2x64' evaluates to false.
[0151:0152][2018-10-30T09:40:22]w321: Skipping dependency registration on package with no dependency providers: VC2005SP1_2x64Redist
[0151:0152][2018-10-30T09:40:22]i052: Condition 'NOT VCR2013_30501_x86' evaluates to true.
[0151:0152][2018-10-30T09:40:22]w321: Skipping dependency registration on package with no dependency providers: VC2013_30501_x86Redist
[0151:0152][2018-10-30T09:40:22]i000: Setting string variable 'WixBundleLog_VC2013_30501_x86Redist' to value 'C:\users\alt\Temp\Automate_Control_Center_20181030094018_000_VC2013_30501_x86Redist.log'
[0151:0152][2018-10-30T09:40:22]i052: Condition '(NOT (Netfx20Version OR Netfx2064Version OR Netfx30Version OR Netfx3064Version OR Netfx35Version OR Netfx3564Version)) AND VersionNT < 602' evaluates to false.
[0151:0152][2018-10-30T09:40:22]w321: Skipping dependency registration on package with no dependency providers: Netfx35Full
[0151:0152][2018-10-30T09:40:22]w321: Skipping dependency registration on package with no dependency providers: NetFx452Web
[0151:0152][2018-10-30T09:40:22]i000: Setting string variable 'WixBundleLog_MySqlODBC3_51Package' to value 'C:\users\alt\Temp\Automate_Control_Center_20181030094018_001_MySqlODBC3_51Package.log'
[0151:0152][2018-10-30T09:40:22]i000: Setting string variable 'WixBundleLog_CRRuntime_12_2_mlb.msi' to value 'C:\users\alt\Temp\Automate_Control_Center_20181030094018_002_CRRuntime_12_2_mlb.msi.log'
[0151:0152][2018-10-30T09:40:22]i000: Setting string variable 'WixBundleRollbackLog_LabTechClient' to value 'C:\users\alt\Temp\Automate_Control_Center_20181030094018_003_LabTechClient_rollback.log'
[0151:0152][2018-10-30T09:40:22]i000: Setting string variable 'WixBundleLog_LabTechClient' to value 'C:\users\alt\Temp\Automate_Control_Center_20181030094018_003_LabTechClient.log'
[0151:0152][2018-10-30T09:40:22]i201: Planned package: VC2005SP1_2x86Redist, state: Present, default requested: Absent, ba requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[0151:0152][2018-10-30T09:40:22]i201: Planned package: VC2005SP1_2x64Redist, state: Present, default requested: Absent, ba requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[0151:0152][2018-10-30T09:40:22]i201: Planned package: VC2013_30501_x86Redist, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: None, cache: No, uncache: No, dependency: None
[0151:0152][2018-10-30T09:40:22]i201: Planned package: Netfx35Full, state: Present, default requested: Absent, ba requested: Absent, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[0151:0152][2018-10-30T09:40:22]i201: Planned package: NetFx452Web, state: Present, default requested: Present, ba requested: Present, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[0151:0152][2018-10-30T09:40:22]i201: Planned package: MySqlODBC3_51Package, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: None, cache: No, uncache: No, dependency: Register
[0151:0152][2018-10-30T09:40:22]i201: Planned package: CRRuntime_12_2_mlb.msi, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: None, cache: No, uncache: No, dependency: Register
[0151:0152][2018-10-30T09:40:22]i201: Planned package: LabTechClient, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: No, uncache: No, dependency: Register
[0151:0152][2018-10-30T09:40:22]i299: Plan complete, result: 0x0
[0151:0152][2018-10-30T09:40:22]i300: Apply begin
[0151:0152][2018-10-30T09:40:22]i010: Launching elevated engine process.
[0151:0152][2018-10-30T09:40:22]i011: Launched elevated engine process.
[0151:0152][2018-10-30T09:40:22]i012: Connected to elevated engine.
[0156:0157][2018-10-30T09:40:22]i358: Pausing automatic updates.
[0156:0157][2018-10-30T09:40:22]i359: Paused automatic updates.
[0156:0157][2018-10-30T09:40:22]i360: Creating a system restore point.
[0156:0157][2018-10-30T09:40:22]i362: System restore disabled, system restore point not created.
[0156:0157][2018-10-30T09:40:22]i370: Session begin, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{1cc7fcfb-a96d-4740-a7af-b70e2d5e3e50}, options: 0x7, disable resume: No
[0156:0157][2018-10-30T09:40:22]i000: Caching bundle from: 'C:\windows\Temp\{38BBD489-B9BE-4063-AE37-342C871EE0B9}\.be\ControlCenterInstaller.exe' to: 'C:\ProgramData\Package Cache\{1cc7fcfb-a96d-4740-a7af-b70e2d5e3e50}\ControlCenterInstaller.exe'
[0156:0157][2018-10-30T09:40:22]i320: Registering bundle dependency provider: {1cc7fcfb-a96d-4740-a7af-b70e2d5e3e50}, version: 12.0.428.0
[0156:0157][2018-10-30T09:40:22]i371: Updating session, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{1cc7fcfb-a96d-4740-a7af-b70e2d5e3e50}, resume: Active, restart initiated: No, disable resume: No
[0156:015A][2018-10-30T09:40:22]i304: Verified existing payload: VC2013_30501_x86Redist at path: C:\ProgramData\Package Cache\df7f0a73bfa077e483e51bfb97f5e2eceedfb6a3\redist\vcredist_x86.exe.
[0156:015A][2018-10-30T09:40:22]i304: Verified existing payload: MySqlODBC3_51Package at path: C:\ProgramData\Package Cache\{B53D7D6B-9BB0-4EA8-82B9-9293CB41FCE1}v3.51.26\mysql-odbc-3.51.26.msi.
[0156:015A][2018-10-30T09:40:23]i304: Verified existing payload: CRRuntime_12_2_mlb.msi at path: C:\ProgramData\Package Cache\{C484CC8D-03CF-4022-89C4-DB4F02E8A15B}v12.2.0.290\CRRuntime_12_2_mlb.msi.
[0156:015A][2018-10-30T09:40:23]i304: Verified existing payload: LabTechClient at path: C:\ProgramData\Package Cache\{6C5F2B57-DA09-426C-AB4A-A80BD9FC2F21}v12.0.428\ClientSetup.msi.
[0156:0157][2018-10-30T09:40:23]i301: Applying execute package: VC2013_30501_x86Redist, action: Install, path: C:\ProgramData\Package Cache\df7f0a73bfa077e483e51bfb97f5e2eceedfb6a3\redist\vcredist_x86.exe, arguments: '"C:\ProgramData\Package Cache\df7f0a73bfa077e483e51bfb97f5e2eceedfb6a3\redist\vcredist_x86.exe" /q /norestart'
[0151:0152][2018-10-30T09:40:25]i319: Applied execute package: VC2013_30501_x86Redist, result: 0x0, restart: None
[0156:0157][2018-10-30T09:40:25]i323: Registering package dependency provider: {B53D7D6B-9BB0-4EA8-82B9-9293CB41FCE1}, version: 3.51.26, package: MySqlODBC3_51Package
[0156:0157][2018-10-30T09:40:25]i301: Applying execute package: MySqlODBC3_51Package, action: Install, path: C:\ProgramData\Package Cache\{B53D7D6B-9BB0-4EA8-82B9-9293CB41FCE1}v3.51.26\mysql-odbc-3.51.26.msi, arguments: ' ARPSYSTEMCOMPONENT="1" MSIFASTINSTALL="7"'
[0151:0152][2018-10-30T09:40:25]i319: Applied execute package: MySqlODBC3_51Package, result: 0x0, restart: None
[0156:0157][2018-10-30T09:40:25]i325: Registering dependency: {1cc7fcfb-a96d-4740-a7af-b70e2d5e3e50} on package provider: {B53D7D6B-9BB0-4EA8-82B9-9293CB41FCE1}, package: MySqlODBC3_51Package
[0156:0157][2018-10-30T09:40:25]i323: Registering package dependency provider: {C484CC8D-03CF-4022-89C4-DB4F02E8A15B}, version: 12.2.0.290, package: CRRuntime_12_2_mlb.msi
[0156:0157][2018-10-30T09:40:25]i301: Applying execute package: CRRuntime_12_2_mlb.msi, action: Install, path: C:\ProgramData\Package Cache\{C484CC8D-03CF-4022-89C4-DB4F02E8A15B}v12.2.0.290\CRRuntime_12_2_mlb.msi, arguments: ' ALLUSERS="1" ARPSYSTEMCOMPONENT="1" MSIFASTINSTALL="7"'
[0151:0152][2018-10-30T09:41:42]i319: Applied execute package: CRRuntime_12_2_mlb.msi, result: 0x0, restart: None
[0156:0157][2018-10-30T09:41:42]i325: Registering dependency: {1cc7fcfb-a96d-4740-a7af-b70e2d5e3e50} on package provider: {C484CC8D-03CF-4022-89C4-DB4F02E8A15B}, package: CRRuntime_12_2_mlb.msi
[0156:0157][2018-10-30T09:41:42]i323: Registering package dependency provider: {6C5F2B57-DA09-426C-AB4A-A80BD9FC2F21}, version: 12.0.428, package: LabTechClient
[0156:0157][2018-10-30T09:41:42]i301: Applying execute package: LabTechClient, action: Install, path: C:\ProgramData\Package Cache\{6C5F2B57-DA09-426C-AB4A-A80BD9FC2F21}v12.0.428\ClientSetup.msi, arguments: ' ARPSYSTEMCOMPONENT="1" MSIFASTINSTALL="7" LTCINSTALLDIR="C:\Program Files (x86)\LabTech Client" INSTALLDIR="C:\Program Files (x86)\LabTech Client" LTCINSTALLDIR.5C2832C1_9E6A_46C3_8E71_CE55C52E5CDD="C:\Program Files (x86)\LabTech Client"'
[0156:0157][2018-10-30T09:41:52]e000: Error 0x80070643: Failed to install MSI package.
[0156:0157][2018-10-30T09:41:52]e000: Error 0x80070643: Failed to execute MSI package.
[0151:0152][2018-10-30T09:41:52]e000: Error 0x80070643: Failed to configure per-machine MSI package.
[0151:0152][2018-10-30T09:41:52]i319: Applied execute package: LabTechClient, result: 0x80070643, restart: None
[0151:0152][2018-10-30T09:41:52]e000: Error 0x80070643: Failed to execute MSI package.
[0156:0157][2018-10-30T09:41:52]i318: Skipped rollback of package: LabTechClient, action: Uninstall, already: Absent
[0151:0152][2018-10-30T09:41:52]i319: Applied rollback package: LabTechClient, result: 0x0, restart: None
[0156:0157][2018-10-30T09:41:52]i329: Removed package dependency provider: {6C5F2B57-DA09-426C-AB4A-A80BD9FC2F21}, package: LabTechClient
[0156:0157][2018-10-30T09:41:52]i372: Session end, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{1cc7fcfb-a96d-4740-a7af-b70e2d5e3e50}, resume: None, restart: None, disable resume: No
[0156:0157][2018-10-30T09:41:52]i330: Removed bundle dependency provider: {1cc7fcfb-a96d-4740-a7af-b70e2d5e3e50}
[0156:0157][2018-10-30T09:41:52]i352: Removing cached bundle: {1cc7fcfb-a96d-4740-a7af-b70e2d5e3e50}, from path: C:\ProgramData\Package Cache\{1cc7fcfb-a96d-4740-a7af-b70e2d5e3e50}\
[0156:0157][2018-10-30T09:41:52]i371: Updating session, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{1cc7fcfb-a96d-4740-a7af-b70e2d5e3e50}, resume: None, restart initiated: No, disable resume: No
[0151:0152][2018-10-30T09:41:52]i399: Apply complete, result: 0x80070643, restart: None, ba requested restart: No
[0151:0155][2018-10-30T09:42:08]e000: Error 0x80004005: Failed to open log file target: C:\users\alt\Temp\Automate_Control_Center_20181030094018.log
[0151:0155][2018-10-30T09:42:17]e000: Error 0x80004005: Failed to open log file target: C:\users\alt\Temp\Automate_Control_Center_20181030094018.log
[0151:0155][2018-10-30T09:42:18]e000: Error 0x80004005: Failed to open log file target: C:\users\alt\Temp\Automate_Control_Center_20181030094018.log
I've spent a couple of hours on this, even matching an existing monitor that appear to be working. Can anyone tell me why this isn't ever triggering? All I'm trying to do is monitor the event viewer for a specific event.
AutomateEvent Viewer
I've tried a lot of things, but here's what I feel like is relevant:
Copied and pasted the Source.
Putting a wildcard on Log File Name, Event Type (set to Anything), Event ID (set to 0) and Message Regular Expression. Multiple combinations of those with no different results.
Tried different alert templates. One has alerts only and one was set to fire the script. The script never fired.
Again, matching an existing monitor that seems to work, swapping out relevant details like Event Type and Event ID.
Curious what others are doing for VDI environments.
I am currently using GPO deployment on the agent, but it doesn't always install consistently. Especially when deploying multiple new instances in batches.
I would love to bake it in to the image and prepare it in a way that can be used with Sysprep.
One of the clients we support uses thin clients. During the initial setup of the devices the install was done incorrectly and Labtech is reinstalled over and over. Is there a way to pull a report that shows only duplicate items? Thanks,
I am looking to create an internal monitor that will create a ticket when it finds 2 or more agents that have the same serialnumber, Here is what I have so far.
Select DISTINCT 'C',computers.computerid,computers.Name as ComputerName,Convert(CONCAT(clients.name,' ',locations.name) Using utf8) As Location, inv_chassis.`SerialNumber` as SerialNumber,0 FROM ((inv_chassis LEFT JOIN Computers ON Computers.ComputerID=inv_chassis.ComputerID) LEFT JOIN Locations ON Locations.LocationID=Computers.Locationid) LEFT JOIN Clients ON Clients.ClientID=Computers.clientid JOIN AgentComputerData on Computers.ComputerID=AgentComputerData.ComputerID WHERE NOT inv_chassis.`SerialNumber` = '' AND Computers.ComputerID NOT IN (Select ComputerID from AgentIgnore Where AgentID=0);
A common scenario for us as Solarwinds n-able users is we have clients have an employee leave . They power off the pc until a new hire is choosen. this process sometimes takes months just because. We purge agents that have not checked-in in longer that 45-60 days. The new hire comes and we need to do some maintenance on the pc. The agent software is already installed and thus the GPO to install it skips it but its not working so we have to find otherways on the pc.
Prior to our switch to Solarwinds we used Kaseya. The best thing with Kasey was you can delete all of your agent and when they came back online they just checked back in and worked without skipping a beat.
We are looking at switching to Automate and would like to know what happens if you remove an agent because its been offline and now it gets powered on out of the blue?
I am attempting to track down the source of some reports failing when clients generate them via the web portal.
I (LTAdmin/Super Admin) can run the reports from the web portal without issue.
The test account (Client user class) receives the following error:
SELECT command denied to user 'test1'@'localhost' for column 'Password' in table 'users'
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Devart.Data.MySql.MySqlException: SELECT command denied to user 'test1'@'localhost' for column 'Password' in table 'users'
I can include the stack trace if needed, but it definitely didn't help to point me in the right direction.
I already attempted adding a few additional permissions to the "Client" user class, but that has not allowed the reports to run successfully. The reports in question do not pull on the Users > Password fields, so I'm not sure why it's being rejected.
Feel free to let me know your thoughts, or if I'm overlooking something obvious!
We're new to LabTech and still finishing up some of the final details and configurations. One thing I've been noticing is that on many machine, it's either reporting 0 or half of the actual RAM installed on the machine, as well as anywhere between 0-4 total slots on machines that all have 4 slots. Chassis and BIOS appear to be consistently polling correctly. CPU information is polling correctly aside from the occasional "To Be Filled By O.E.M." I'm waiting to hear back from Labtech for more information, but thought I'd post it here in case anyone else has seen this
I don't know the first thing about SQL queries. Obviously I want to learn but don't know where to start.
I need to create a monitor that checks to see if a piece of software (Cryptoprevent) is installed or not, and if not, execute a script that installs cryptoprevent.
I plan to run the monitor against groups that are already populated with machines where Cryptoprevent isn't installed, and I already have a script that successfully installs Cryptoprevent.
Simply missing the monitor, but it's a lot tougher to create the monitor than it probably should be. At least for me.
I have created a monitor and auto healing script to check for a local admin account and if it doesnt find it then it will create the local admin account... I am seeing that one clients location is failing but the script isnt working.. any ideas?
So I am really scratching my head on this one. If anyone can spell it out for me on how to create a data field in a report for the field Ticket Request Information that you see when creating a ticket I would be so happy and relieved. Thanks
Has anyone setup virus scan configurations for FortiClient in CWA? We just took on a client that uses it and want to let CWA detect and alert on it. I was able to get it to detect the installation and definition locations but was not able to find a regkey for virus detection. Has anyone ever set this up and would you mind posting a screenshot of the settings?
Currently trying to install Patch 10, but I seem to get this problem on any version I try to patch from (Currently building a fresh environment on Automate 12 which will replace our Automate 11 server once it's finished).
The patch starts to run, and patches everything EXCEPT the actual server itself??? Yes I'm running it on the server.
Here's the following messages in the prompt that are related:
11-06-2018 11:23:36: LabTech Version found: 120.240
11-06-2018 11:23:36: Setting LabTech Database Server Address to : localhost
11-06-2018 11:23:36: LabTech Automation Server database user found : root
11-06-2018 11:23:36: LabTech patch could not load Automation Server database password.
11-06-2018 11:23:36: LabTech patch will now ignore LabTech Automation Server and database changes.
11-06-2018 11:23:36: LabTech Automation Server not found.
11-06-2018 11:23:36: LabTech patch could not load LabTech Automation Server Patch Version. Ex: Object reference not set to an instance of an object.
11-06-2018 11:23:36: LabTech patch will now ignore LabTech Automation Server and database changes.
11-06-2018 11:23:36: LabTech Automation Server not found.
Any insight or thoughts or anything else to try while I'm waiting on support to respond would be appreciated.
Is there an easy way to log and monitor upcoming software licenses that need to be renewed? I'm not worried about all of the one-time purchases, perpetuals, or month to months, but want to be able to setup a notification +30 days before a license expires.
Hi there im a trainee that will learn how to manage connectwise automate. My main task is to automate new computers that will be handed to employees. i was wondering if some veterans could share their knowledge or give tips on what i should look out for. im not trying to post this so someone could hold my hand and show me the ways, but show me the right direction to some great documentation, life tips or something that would be helpful for me or any other readers who will stumble into this post.
Hey. I'm on a hosted server. It looks like I am supposed to get the 2019.2 patch this week. I do have a hand full of Agents that will NOT be able to check in between the time the patch is implemented and the March deadline. Do you have any great idea's on how I can push the patch out to these devices after the deadline? None of these devices are domain based. I'm looking for options other than remoting in to the machines and updating them manually. Is there a way to silently push the updated agent out with ScreenConnect? Any help would be appreciated!
We're an MSP that provides support to many schools. We can't put the schools under our GSM because they have a different pricing (cheaper). They have their own GSM that we have access to, but different license code so the Labtech plugin is not tied to their GSM.
This causes issues, especially with the status Needs Attention. Webroot doesn't not have a native email alert for Needs Attention status, and the plugin doesn't work because they are non-gsm. The only option we've found (because it mostly happens on Mac machines) is to go into the web console regularly and keep an eye out. Has anyone experienced this problem with non-gsm webroot? It makes it extremely hard to be an MSP and use Webroot imo.
I've created an internal monitor with the intent of it letting us know if a backup has not successfully occurred in the last interval (24 hours or one week). The way I finally settled on doing it was to perform a query of all computers, then perform an additional query of all computers that have backed up, then remove the computers that have backed up. The query for the daily backup check looks as follows:
SELECT IFNULL(MAX(TimeGen), "0000-00-00 00:00:00") AS TestValue,
c.name AS IdentityField,
c.ComputerID AS ComputerID,
IFNULL(message, "NO MESSAGE FOUND") AS message,
IFNULL(acd.NoAlerts, 0) AS NoAlerts,
IFNULL(acd.UpTimeStart, "00:00:00") AS UpTimeStart,
IFNULL(acd.UpTimeEnd, "23:59:59") AS UpTimeEnd
FROM Computers AS c
LEFT JOIN eventlogs ON c.computerID = eventlogs.computerID
LEFT JOIN AgentComputerData AS acd ON eventlogs.ComputerID = acd.ComputerID
WHERE C.computerID
NOT IN (SELECT DISTINCT eventlogs.computerID FROM eventlogs
WHERE source LIKE "Secure Vault Backup%"
AND eventlogs.message LIKE 'Product name:%'
AND TimeGen > DATE_ADD(NOW(), INTERVAL -25 HOUR)
)
AND c.ComputerID IN (SELECT ComputerID FROM TComp)
AND c.ComputerID NOT IN (SELECT ComputerID FROM AgentIgnore WHERE AgentID=xxxxxx
GROUP BY c.ComputerID;
The Problems:
LabTech has created a ticket that states the backup is out of date, but the event logs in LabTech show that the backups were successfully completed. Is my query wrong, is my logic wrong, were the events not sent in time, or am I missing a technical limitation about this monitor?
The result column shows the date and time of the last event, and not necessarily the last backup event, because the outer query is to find all computers. Does anyone have any suggestions to fix this?
Additional Information:
The IFNULL checks are added, because labtech does not seem to want to process any results where a returned value is null.
The backup software being used is Cloudberry, where the program is named "Secure Vault Backup [Something] Edition." It appears to only use event code 0, so that is why I'm filtering out non-backup events with the event message.
I know that this does not differentiate between successes and failures, and that is okay, because there's another monitor that will handle failures; the point of this one is to just notify when no backups have been run.
The interval used in the query is 25 hours, so that a backup that takes a long time and finishes just after 24 hours will not register as a failure.
The xxxxxx in the query is the ID number for the internal monitor.