I am looking to update multiple views with the same info. Like bulk editing nodes on the managed nodes page. Is there a way via the data base to do this?.
Need to look at the resource properties table for resourced 5219 and 5179, the resource files are the generic base stuff for all custom HTML resources
It can be done, but it isn't easy unless you are pretty familiar with SQL and VERY familiar with solarwinds.
You'd be working with the views, resources, and resourceproperties tables
Pretty straightforward, views lets you know which view you are working with (probably what you will be filtering on) then join the resources table to get the list of the types of resources on each page and their names, then the properties define all the settings you would see if you edit the resource.
I usually find it easiest to get myself some queries in place to watch these all at once, then make a few changes in the gui to see how they affect things, then design my sql queries to scale out those changes. If the change you want to make it something like "all these views have the same resource on them, i want to rename it) then that could be fairly easy, the more changes you want to make the more complex the queries become. Modifying the existing resources isn't terribly difficult, inserting new resources and their properties tends to be significantly more challenging as each resource has different sets of properties associated. I typically find it isn't worth the effort of going into the db to do view manipulations unless i need to make the exact same kind of change to maybe a dozen or more similar views. Short of that it's probably still faster/safer to work in the GUI.
Obviously back up your db before you muck around in any of this because misconfigured resources can make it so the website crashes every time you try to load the page. Not to mention you can ruin a dashboard that you rely on.
Good luck!
thanks for the help. I am looking to add a Custom HTML -Maintenance/Upgrade banner to everyone's view so i can make people aware solarwinds will be down at a specific date/time. Sending emails for upgrades only works for some. Having a scrolling banner everyday a week before will help eliminate the calls when solarwinds is down for a maintenance.
As you mention maybe i will just update the view manually via the GUI with the Custom HTML resource and then edit them later with the upgrade date/time via the Data Base.
Would that work?
Yeah the easiest way to make that happen would probably be to make sure the banners all had the same names, then you can update the same property for every resource where the name is maintenance banner, then you can do the bulk edit in one go very easily.
Ok where do I update the HTML code? I only found this in the database but unsure where that UserHTML.ascx file is to modify
