Ok, I spared you the “SQL Sequel” puns this time, but this article does contain some SQL…In this article, I’m again going to talk about actually removing data, so here goes the big scary warning box:
Note from the legal department: The process described here is not officially supported by Microsoft and are provided only as an example to the community. This process makes modifications to your SQL Database for Orchestrator and will remove data from the database!
Neither I nor Microsoft, nor any other person, animal, vegetable or mineral assumes responsibility for the process demonstrated here. USE AT YOUR OWN RISK!
Here’s the scenario… you had a server where you deployed a Runbook Designer and Runbook Server. This server (named “OLD-SERVER” in this example) is no longer accessible. It died, was taken offline and sent to recycling. There is absolutely no way you can get onto that server using Deployment Manager and uninstall the components. Yet the server still appears in Deployment Manager’s list of Runbook Designers and Runbook Servers:
So what do you do? You don’t want to have to see this server forever, and there isn’t any automatic removal mechanism for these kinds of things (remember, we don’t like to automatically remove your data). As it happens, this information is easily removed with a couple of SQL queries. First you need to understand where the Deployment manager gets the list of computers that it displays.
Knowing this and the correct column names that indicate the server name you need to remove, you just run these two SQL scripts:
DELETE FROM [Orchestrator].[dbo].[CLIENTCONNECTIONS] WHERE [ClientMachine] = 'OLD-SERVER' DELETE FROM [Orchestrator].[dbo].[ACTIONSERVERS] WHERE [Computer] = 'OLD-SERVER'
After I run these scripts, I just refresh the two nodes in the Deployment Manager and I can see the computers are gone!
So what happens if you accidentally delete an active Runbook Designer or Runbook Server? Are those machines now in some weird state where they can’t connect and need to be reinstalled? Luckily, no.
In the case of the Runbook Designer, simply opening the Runbook Designer on the remote computer will recreate the appropriate database entry and the machine will reappear in the Deployment Manager’s list.
In the case of the Runbook Server, you’ll need to restart the Orchestrator Runbook Server service, and that will recreate the database entry for that component.
Now you know how to clean out old machines you can’t access anymore, and you know a little more about the inner workings of Orchestrator. Until next time!
After applying of this method appears empty value in Runbook Designer Console > Runbook Servers
help, i also have empty server name in runbook designer console now !
Same as last 2 comments.
how we can delete this empty Runbokk server?
Hi guys, I searched the DB and came across objects still in the dbo.objects table in the database. This should clean up the orphaned items in the Runbook Designer. Back up the DB before executing in case it does anything unexpected. DELETE FROM dbo.OBJECTS
where Name = 'OLD-SERVER'