Customizations lost suddenly

rottengeek‌,

Did you recently upgrade DPA ? I had seen the video prompt come back after upgrade. On the custom chart displays this could also be from the upgrade. I think you mean you had custom metrics that are not displaying for you in DPA now. Some of the things needed for Custom metrics would be in the DPA repository database and some is stored in XML files.So if you did an upgrade and didn't get the XML moved to the new folder path that might explain why they are not there. The folder path should be similar to "SolarWinds\DPA\iwc\tomcat\ignite_config\idc\metrics\userdefined"

The XML in this section will have names like userdefined-metrics-queries.XML and userdefined-metrics-properties_SQLServer.XML. The metrics in the metrics-properties_{database type}.XML files will have names like CustomMetric-1.

In the Repo you can view if they are there by running something like this SQL statement. Note that you will need to change table names per monitored server.

--first run this

Select id, name from COND;

---replace xx with ID of instance you had a

Select

  *

from CON_METRICS_xx m

inner join CON_METRICS_NAMES_xx n

on m.METRIC_NAME_ID = n.ID

left join CON_METRICS_DISABLED md

on n.NAME = md.METRIC_NAME

where n.NAME like 'Custom%'

This can be some involved also so if need please just open a support case and we can follow up there and post back the solution.

no, actually - it is really kind of odd.

The Resrouces tab, which shows all the graphs, is no longer showing the SQL graphs I had added.  In fact, the only graphs it shows are VM related (and I'm not on the VM tab, I'm on the performance tab)

It is allowing me to put them back in, I just thought it was odd and decided to let the Ignite team know.

try to restart the SW server, sometimes our views go away and after a reset they reappear.