BES_ANALYSES view returns duplicate rows

(imported topic written by SystemAdmin)

In BES 7.0, you may find that the BES_ANALYSES view returns duplicate rows for some of its entries. This view is supposed to return the SiteName, Analysis ID and Name of all analyses but it ends up returning duplicate rows for your custom Analyses.

Attached is a script which will create a new view, BES_ANALYSES70, with a fix for the duplicate rows problem.

(imported comment written by SystemAdmin)

It looks like several other views have the same problem which creates duplicate rows. The affected views are:

BES_ANALYSES

BES_BASELINES

BES_COMPUTERGROUPS

BES_FIXLETS

BES_TASKS

I’ll attach a script that will create new views with the ‘70’ suffix (example, BES_TASKS70) that have a fix for the duplicate row issue. The script will drop any existing 70 views prior to creating them so it will work if you already ran the script to fix BES_ANALYSES above.

http://support.bigfix.com/download/bes/misc/BESViewsDuplicatesFixes.sql