Jump to content
[[Template core/front/profile/profileHeader is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]]

DarrenWhite99 last won the day on January 13

DarrenWhite99 had the most liked content!

Community Reputation

400 Excellent

My Information

  • Location
    Redding, California, US
  • Agent Count
    2000 - 3000 Agents


    Senior Systems Engineer

Recent Profile Visitors

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

  1. That’s the problem. You could try replacing the TO_BAS64/FROM_BASE64 calls with BASE64_ENCODE/BASE64_DECODE. Those are stored procedures available in Automate, but they aren’t as fast as the native functions I’m using in 5.6+.
  2. It showed that there were no prior backups and nothing found to backup, so the SQL queries failed to return any results. Are you running MySQL 5.7? 5.6 (or was it 5.5?) doesn’t include the BASE64 functions needed so that could be the problem.
  3. I have an “onboarding accelerator” monitor. It triggers the onboarding script when it sees: A computer, online, in a location with onboarding enabled where onboarding has not completed and excluded from contract is not selected. I specifically use the v_extradata tables to test the EDF values because as soon as I can see the result there, I know that groups and such have rebuilt. (I tried triggering it quicker, but the standard onboarding script relies on groups/EDFs/etc. being up to date, so running it early means it misses things). That doesn’t speed the group builds, but it does start onboarding within about 20 minutes instead of only running once an hour. So, is the main issue that users are granted access to machines by specific groups, and the machines are not visible to them until the computer is in that group? A potential solution could be: Create a group that determines which agents they can see. Say you are using “Service Plans” as the group. You could have a search/group for “Agents Under Contract” or whatever, that just grabs all computers where the location has a server or workstation (as appropriate) service plan assigned with onboarding enabled and Exclude From Contract is not checked. Basically, it will be all computers that should be under contract. Ok, now, make a monitor that runs every 5 minutes to check if any not onboarded systems matched those conditions.. Trigger a script. (I think you already had all this design in mind) but instead of rebuilding EVERYTHING, just add a row to searches, subgroups and subgroupswchildren for the agent, adding the agent to the specific group(s) you need them in for technicians to access them. This would scale because you are only performing minor insert queries instead of asking for everything to be rebuilt for only one new agent. Not everything would be complete, but you could get them the access they need. (Oh yeah, also, some users permissions table would need to be touched..)
  4. It’s possible yes, but II don’t think it’s that great of an idea. ESPECIALLY if you are new to Automate, you wouldn’t know what problems can be caused or how to gracefully coordinate things. I’m thinking for example, what will your solution do when you are onboarding a client and 3-33 new machines get registered within a short window. Will your solution end up trying to rebuild groups and searches 30 times? Will that break all your internal monitors if they timeout while tables are locked? I’ll be honest and say that I don’t know all the trouble it would cause, but as someone who has used Automate for about 7 years and is familiar with many internal details at a level matched by few outside of the developers, my recommendation would be to reconsider your approach. Forcing these group and search refreshes are not things that you should need to routinely do.
  5. The script text for Execute Script must be ANSI. Is the script sending the email itself, or returning the email body and Automate is sending it?
  6. They seem to be working fine for me. I rolled it out to about 100 systems across 3 clients in the last two weeks.
  7. Does the monitor alert history show any fails and successes? If the agent is in maintenance mode then the alert cannot act against it. If you set an email address on a machine that has been offline for several days, then hit “Build and view” in the monitor, does that agent get returned?
  8. I was just recently looking at this. OpenDNS has provided a deployment script that includes client EDFs to set the fields needed for silent deployment, and an EDF to indicate the client should not be deployed on a specific computer. All that needs to be done is to create a monitor or search to trigger the script and deployment can be automated. https://github.com/opendns/Deploy-Scripts/tree/master/Labtech
  9. That looks right, what part isn’t working? When you run the script, you should be prompted for a NewComputerName value.
  10. How about a dataview that shows you if a user is logged in, and how long they have been idle? (I went with Red/Green for the status, no Blue)
  • Create New...