Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


lgs141 last won the day on February 12 2018

lgs141 had the most liked content!

Community Reputation

3 Neutral

My Information

  • Agent Count

Recent Profile Visitors

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

  1. Is this the same as just adding a HTTP response header at the IIS server level?
  2. Edit - rewriting topic based on slack feedback
  3. This is a good idea. We've gone for a slightly different approach. Our script is pretty much identical to yours, except for the SQL query at the start. We have a pre-patch script set on the reboot policy which is only applied to Hypver-V Hosts. Then our SQL queriy gets a list of all VMs in the database with a "vmhost" entry of %computername%.%domain% (which is going to be the server that's about to patch). Saves setting the entire location into Maintenance Mode - if you're like us you may have other unrelated devices there too that you don't want to silence. SELECT computerid FROM inv_bios WHERE VMHost = '%computername%.%domain%';
  4. Hey all. Migrated from single server to split server a few weeks ago. On the whole everything has seemed fine but we've had some Manage ticket sync issues which has made me review the server logs. I found a few recurring logs that suggest we have issues but to be honest I'm having a hard time verifying it's actually causing problems. First set of errors from LTRErrors.txt, I searched and found a thread that suggested it may be an issue with the System password, but ours is the same as before as it was migrated with the old database. We are on split server but the user it mentions is currently allowed from % host. Heartbeat data generally seems to be OK from what I've checked. Seems to be logged every minute or so. LTRedirSvc v200.141 - 4/29/2020 11:04:36 AM - Error writing heartbeat database results: Authentication to host 'SERVERNAME' for user 'asp_LabTech_1' using method 'mysql_native_password' failed with message: Access denied for user 'asp_LabTech_1'@'SERVERNAME' (using password: YES), Access denied for user 'asp_LabTech_1'@'SERVERNAME' (using password: YES)::: Then these in LTSQLErrors.txt which seem to be caused the "test" tables having hyphens in the name. I don't recall ever creating any test tables. LTAgent v200.141 - 4/29/2020 4:31:24 AM - ESQL You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-c59d6001-68cc-11e8-b09a-00155d4ad220' at line 1 ANALYZE TABLE test-c59d6001-68cc-11e8-b09a-00155d4ad220::: Thanks for any input.
  5. Are you using the older original code? You may want to read the newest posts in this thread, Dell has changed their system and HP took theirs offline completely.
  6. The Printers dataview is pretty useful for this. Right click the Client/location/or machine you want the info for. Then go to Dataviews > Inventory > Printers.
  7. This is a known issue. I don't know the KI number but in the ticket I raised with Connectwise they said it's a bug they are working on.
  8. Ah nice, even better. I might give this a go at the weekend - can't do much else at the moment anyway
  9. Thanks for this. I'm planning to migrate from one single server instance to a split server (database/Automate & web). If I license Automate on the new server using my dev license and then import the database, will the Automate server automatically use the old license?
  10. So has anybody worked out an alternative for the HP API? Is there even one? I've reached out to our account manager today but can't see that being any help.
  11. I have a feeling you'd have a much easier time of it if you used Powershell: https://stackoverflow.com/questions/5097125/powershell-comparing-dates
  12. Not a direct solution but try the 32bit version. I attempted to deploy the 64bit package for a long time and it simply would not work, whereas 32bit installs perfectly fine using the command you've pasted. Microsoft suggests it should work the same for both packages but that's not our experience and our ticket is still open with them.
  13. Heads up to anybody wanting to use the device API mapping fields in the Manage plugin - I had word in a ticket today that this field's sync is broken due to a known issue, it hasn't been turned off and should otherwise be working. I'm just waiting for the KI number to share it.
  14. @tlphipps How do you configure your maintenance windows? We patch monthly so the built in Maintenance windows don't work for us as that only allows weekly scheduling.
  15. @digitalmess @etaylor @grouchy.oscar I'm sure there's all sorts of better ways to handle it, but here's our current setup. Based off of this article, at the bottom you'll find an example of the output: https://blogs.msdn.microsoft.com/rodneyviana/2017/06/06/powershell-cmdlet-to-check-onedrive-for-business-or-onedrive-personal-status/ 1. Save OneDriveLib.dll to Automate server transfer directory. https://github.com/rodneyviana/ODSyncService/tree/master/Binaries/PowerShell 2. Create Automate script. The PowerShell must be run in the logged-on user context.
  • Create New...