Jump to content

Recommended Posts

A couple years ago I worked with a CW consultant who mentioned a "core-only" migration of Automate -- that is moving over only the tables needed to make the application run. I couldn't find the list of tables posted anywhere, so I wanted to post them here.

Please note that there's an awful lot of items missing here (think of this like a "reset my server, keep my agents and users" measure). I'd advise anyone thinking about this that groups, scripts, monitors, searches, EDFs, and Connectwise Control are all missing. So too are all the tables for Patch Manager -- so with that, most partners would experience a long rebuild process if they attempted this.

With that, the tables are as follows: 

automate_api_security
 clients
 computerconfig
 computers
 config
 contacts
 controlcenterconfig
 locations
 passwords
 probeconfig
 probeconfiguration
 probeconfigurationcredentials
 probeexcludedipaddressrange
 probesnmpconfiguration
 probesubnet
 users_extend
 userFolders
 users

 

With that, this has a couple valid uses, such as removing Ignite or troubleshooting some migration-gunk if your stack has been migrated for years. 

I have not yet compiled a list of suggested additions, but if anyone posts suggested tables below I'd be happy to make a second list and curate this as a community guide.

 

EDIT: WARNING: I tried this in a lab environment, and after rebuilding I was unable to authenticate to my server. I'm guessing this has to with missing 2FA plugin tables, but I did not verify this. Please do not try this at home without good backups!

Edited by Automation Theory
Added warning message.
Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...