configuration wizard reports import

score 6
Voted on 6 times. You have not voted. Open for Voting

Running configuration wizard after upgrading to NPM 12.5, I noticed it takes about an hour to finish.

Considering I have about 120.000 elements in my database Solarwinds Support staff considered reasonable, and I concur.

However, I also noticed that the reports import step detailed in the extract from the log below took about 30 minutes to finished.

 

This is the first intruction I see right before the imports start, and next

2019-08-13 12:03:56,403 [39] DEBUG SqlHelper - SQL: IF NOT EXISTS (SELECT * FROM [dbo].[ReportDefinitions] WHERE Definition like '%<ReportGuid>' + @ReportGuid + '</ReportGuid>%') BEGIN INSERT INTO [dbo].[ReportDefinitions] ([Name], [Title], [SubTitle], [Type], [Description], [Category], [Definition], [ModuleTitle], [LimitationCategory], [Hash], [OrionFeatureName])

2019-08-13 12:26:06,451 [13] DEBUG TaskAdapter - Orion.MigrateOrionReports [100.0%]:

2019-08-13 12:26:06,451 [13] INFO  TaskAdapter - Finished task Orion.MigrateOrionReports Migrate Orion reports to ReportDefinitions table [00:00:03.1050946].

 

My feature request would be...

Why not to have a column in the reports table to control when was the last time each report was generated and skip it if not necessary to re-import.

This will very useful when you are troubleshooting and required to run configuration wizard multiple times.

Comments

Vote history

SolarWinds uses cookies on its websites to make your online experience easier and better. By using our website, you consent to our use of cookies. For more information on cookies, see our cookie policy.