This web page lists primary and secondary management server assignments for each AppManager agent. To install it, save the ASP file to a Web Server, then edit it and change the INSTANCE and DATABASE names near the top of the file. The web page has the capability to output the results to a CSV file. To enable this, change the DO_EXPORT constant to True and configure the web site to allow writes.
The ASP file has been designed as a template such that it may very easily be modified output other information, simply by editing the details and SQL query at the top of the file. Note that the web page has been tested on Microsoft IIS only, and that IIS must be configured to allow the page to access to the AppManager repository.
14-6-11: Modify SQL query to include NOLOCK on all tables.