Is there a way to view the version history of all the GPOs in the GP Repository without having to se (NETIQKB50072)

goal
Is there a way to view the version history of all the GPOs in the GP Repository without having to select each one individually?

goal
Is there a SQL Query that will return the version history of all the GPOs in the GP Repository?

fact
NetIQ Group Policy Administrator 4.6

fix

Yes, you can view the version history of all the GPOs in the GP Repository by running a SQL query in SQL Query Analyzer against the GP Repository database.

To run a SQL Query using SQL Query Analyzer:

1. Start SQL Query Analyzer in the Microsoft SQL Server program group.
2. Connect to the SQL Server that is hosting the GP Repository database.
3. In the Object Browser, select the GPO_REPOSITORY database.
4. In the Query window, paste the following SQL query: 
   select a.gpo_name, a.gpo_cn_name, a.gpo_id, b.gpo_version, b.operation, b.operation_date, b.comment from fa_rep_gpo a, fa_rep_gpo_history b where a.gpo_id = b.gpo_id order by a.gpo_id, a.gpo_cn_name, b.gpo_version, b.operation_date
5. On the Query menu, select Execute.

Formerly known as NETIQKB50072