Tool to Export Public Reports from Database to Database

Reporting
1

(imported topic written by John_Nielsen91)

Hi Guys,

Is there a tool available for exporting, then importing reports from one database to another assuming that all properties exist in each DB?

2

(imported comment written by John_Nielsen91)

found this thread…

http://forum.bigfix.com/viewtopic.php?id=648

This is exactly what I needed, nevermind :slight_smile:

3

(imported comment written by John_Nielsen91)

I have another question on this subject, maybe for Ben.

In the “SAVED_REPORTS” database table, I notice that in some of the records the ArgumentString is blank, for these reports is this information stored somewhere else in the database? It’s a pretty small % of saved reports where this field is missing.

4

(imported comment written by SystemAdmin)

Has the SAVED_REPORTS table changed name for 7.2? I don’t have this table available under BESReporting database.

5

(imported comment written by chris_lindsay91)

The SAVED_REPORTS table doesn’t exist in 7.2. Instead, there’s a table WEBREPORTS that holds all of the saved reports.

6

(imported comment written by GRALLEN91)

What is the SQL command that can be used within Management Studio to export a saved web report from the WEBREPORTS table on our core server?

Thanks

7

(imported comment written by SystemAdmin)

Is it OK if I delete a row with one of the defult reports from this table? i.e. Vulnerabilty by Console Operator

8

(imported comment written by chris_lindsay91)

You can do it, but there are a couple caveats. You need to remove all references to the report from the FAVORITE_WEBREPORTS table. You also need to remove all of the scheduled activities referencing the report, which are stored in the SCHEDULED_ACTIVITY table.

If you do that, you should be able to remove a built-in report.