Apparently the view has been deleted, when we click on the details of an object we receive this error: "RunQuery failed, check fault information. Invalid object name 'dbo.Orchestrators_Nodes_View'." Is this a view that can be added back through a query? Can anyone share the query if you have it? Thanks, Mike

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Is dbo.Orchestrators_Nodes_View a standard SQL view, included in normal installations, can it be reconstructed if deleted?

Apparently the view has been deleted, when we click on the details of an object we receive this error: "RunQuery failed, check fault information.<br>Invalid object name 'dbo.Orchestrators_Nodes_View'."

Is this a view that can be added back through a query? Can anyone share the query if you have it?

Thanks,

Mike

Find more posts tagged with

Accepted answers

All comments

HerrDoktor

only a restore from the database would bring the view back.

if you really want to go through the effort: Build a new Solarwinds Server, hook up a backup of your Solarwinds Database, export the view https://github.com/Mesverrum/MyPublicWork/blob/master/ViewExporter.ps1

and import it back https://github.com/Mesverrum/MyPublicWork/blob/master/ViewImporter.ps1

Props to @mesverrum

MikeRod

We ran the installer and created a new blank database, scripted the view as CREATE To new query and added it to the original system. Very simple.

HerrDoktor

Oh Cool. Didn’t know that this works. Thanks for the info