Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


jbrantley last won the day on December 23 2018

jbrantley had the most liked content!

Community Reputation

1 Neutral

My Information

  • Location
    Alpharetta, GA
  • Agent Count
    4000 - 6000 Agents


    Scripting, MySQL, PowerShell, basic coding
    Providing consulting services for ConnectWise products as well as technical manager for a MSP in the Atlanta, GA area.

Recent Profile Visitors

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

  1. Hey Pat, sorry for the delayed reply. I'll build a script for you tomorrow morning to ensure the stored procedure is properly added to your environment. I'll send it via direct message. If you'd like, I'll be happy to have a remote support session with you as well. Let me know your thoughts! I'd love to get this working for you. Thanks, Jared MSP Automated, LLC
  2. Hey all you need to do is a single command in the script. SQL EXECUTE is the function then use CALL sp_Custom_DeleteClient(%clientid%); Make this a client script and then run it against the client you wish to remove. As long are there are no computers (all are retired), the scrip should remove everything associated with the client you run the script against. The %clientid% variable is passed to the script when you run it against the client.
  3. Hey, save the query as a text file with a .SQL extension. From there, you can open the Control Center client, then go to System -> General -> Import -> SQL file. Import the SQL file you created and that should add the procedure to your hosted database. From there you can call the procedure in a script as outlined above via SQL EXECUTE script function with CALL sp_Custom_DeleteClient(X); If you still have issues, reply here or message me on the MSPGeek slack channel and I'll help you out.
  4. Kudos to you sir, you found a typo in my notes. The DECLARE statement is correct with the SQLSTATE 02000. I accidentally added an extra zero in the comment above the statement explaining the purpose of the DECLARE.
  5. It does, you'll first need to write a SQL Execute script function to add the stored procedure to the database. Other than that, you should be good.
  6. What version of MySQL are you using? If you’re copy/pasting then make sure you paste as plain text. You should also be able to download the SQL file and import it via the control center. if all else fails, let me know and I’ll be happy to setup a support session and check it out with you. -Jared
  7. Hey fellow geeks! Like many of you, I used the check boxes to Hide from All Clients and Disable this Client when offboarding and removing old clients from the navigation tree. Since moving to Automate 12, this functionality no longer works. Having several former clients cluttering up the tree in the CC, I started the process of manually deleting clients. This process was slow and frustrating. To combat this, I created a new stored procedure that can be run from script or via SQLyog to simplify this process. The procedure performs the following steps: Checks to ensure no co
  8. Hey, finally home! I don't have immediate access to a version 12 environment but this should more or less allow you to add a single PC to a contact. 1. From the Control Center, select Browse > Clients tab then either double-click on the desired client or right-click on the desired client and select Open. The Client window is displayed. 2. Click on the Contacts tab. 3. Select/highlight the contact in question. 4. On the right side, there should be a box for Associated Computers. Click the drop down arrow and find the computer in the list. This will assign the computer to
  9. Glad to help. It may be a couple of hours if that's ok. Running a few errands before starting vacation tomorrow morning :-) I'll definitely get you going though. Jared
  10. Hey, I'll be glad to help you out. I'll post some instructions as soon as I get home. Jared
  11. Hey guys, sorry I didn't see this yesterday. The notifications were flagged as spam. Anyway, you absolutely can associate a computerid to more than one contactid. There's many ways to do this including usage of a stored procedure or modifying the script. In efforts to manage the people that have access, I tend to copy the script then edit it based on the additional contact that needs access. If you were to look at my script folder tree, you'd see this script in the Client Access - ScreenConnect folder and then underneath that folder you would find an instance of that script for each contact wi
  12. Ok, are you on slack? Give me a few to grab my laptop and message me at jbrantley
  13. Do you have any VNC applications installed on the agent?
  14. Hey everyone, A few of you may have seen me present this solution in the partner quickfire session at AN17 last week. As requested, here is that solution available for your use: 1. Create a contact record for the customer/client associated with his company. Ensure that the email address is unique as this will be the username. 2. After saving the contact, open the record. On the permissions tab, set any permissions desired but ensure that "Remote Access" is enabled. Note the ContactID in the top of the window and click Save. 3. Open the attached script. Specify the ContactID
  • Create New...