Many old custom reports previously created under NVBU 9.2 and 10, no longer work due to changes to reports name fields and new database views introduced in 11.1.
Should you need to remove ALL of these old failing reports, please use the following procedure.
There is currently no easy way or tool to remove unwanted reports as was the case under NVBU 9.2.
Unwanted reports will have to be deleted directly from the netvault_scheduling database.
Reports are held in the netvault_scheduling database and are assigned job IDs in the 'jobdescription' table.
You will have to manually remove the report entry as follows:
****** Make sure you have run a successful NetVault Database backup before proceeding*********
This is important as in the event the wrong entry is deleted, a NVDB Scheduled Database restore can be carried out to recover.
Procedure:
1) Stop the NetVault service
2) Launch <NetVault Home>\pgsql\bin\pgAdmin3.exe
3) Click the File menu and select Add Server
4) Fill the Name field with anything, Host = localhost, Port = 51486, UserName = postgres, Password => <used during NetVault Installation> and then click OK.
5) Expand the newly added server as follows: Databases > netvault_scheduling > Schemas > Public > Tables
6) Select and right click the 'jobdescription' table > select View Data > View All Rows
7) In the window that appears under the "title test" column you will find all jobs listed including Reports.
These can also be easily identified from the "primarypluginname text" column with the value "Reports Producer"
8) Find and select the row for the old custom reports you wish to delete, then right click its corresponding number on the first column (primary key) and select Delete.
9) Close pgAdmin3 and verify the old custom reports are now removed.
Note:
In the event you have accidentally deleted valid NV canned report or you are unsure what has been removed due to too many deletions, you can re-add the default NetVault canned reports as follows:
1) Go to Manage Clients > select the NVBU Server > Manage > under Installed Software select "Report Producing APM" and use the (-) to remove this apm.
2) Start NetVault and reinstall the 'Reports Producing APM' via Manage Clients > NVBU server > Manage > click (+) and choose for example on a Pure 64 bit server:
..\NetVault Backup\packages\standard\rpt-11-3-0-0-WindowsPure64.npk on the NVBU server.
You must run the Web Ui locally on the NVBU server's or have this file on your computer.
3) Once the "Reports Producing APM" is installed open a command line as administrator and run the ..\NetVault Backup\util\nvaddcannedreports command which will re-add all default reports
