Updated 14/6/11: Web page to show Primary & Secondary MS Assignment

0 Likes

over 10 years ago

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.

Regards
Alain

14-6-11: Modify SQL query to include NOLOCK on all tables.

NetIQ does not test or validate any software, code or other materials provided in, on or through NetIQ Cool Solutions (collectively, "Materials"), so please use caution when downloading or accessing any Materials from Cool Solutions and ensure that you have reasonable and current security, spyware and anti-virus measures in place on your computer and/or network prior to downloading. Additionally, do not use any Materials downloaded from Cool Solutions in any production environment without first testing the Materials to ensure they are compatible with your version of NetIQ software or any other hardware or software present in your network or environment. Cool Solutions is not a substitute for authorized NetIQ support and should not be used as such. NETIQ COOL SOLUTIONS AND ANY MATERIALS ARE PROVIDED ON AN AS-IS, AS-AVAILABLE BASIS WITHOUT ANY WARRANTY OF ANY KIND. By downloading this file, you are agreeing to these terms of use. To report a problem please contact: coolguys-netiq@netiq.com. Your use of Cool Solutions is governed by the Cool Solutions Terms and Conditions. https://www.netiq.com/communities/coolsolutions/terms-and-conditions/

MSAssignment.zip

Tags:

Knowledge Depot

reporting

Labels:

How To-Best Practice

Comment List

MigrationDeletedUser over 9 years ago

Resolved, disabled anonymous auth and enabled basic auth. Thanks.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
MigrationDeletedUser over 9 years ago

Hello,

I get the same error.

Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Any resolution to this?

Thanks.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
MigrationDeletedUser over 10 years ago

Looks pretty straight forward however I modified the script as required and get the following:

Failed to create ADO connection to las-netiqsql-01\QDB

Login failed for user ''. The user is not associated with a trusted SQL Server connection.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
MigrationDeletedUser over 10 years ago

Hi Alain,
Do you know why i most case i have info about MS in the registry of the machine and not in to the QDB ?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Related Discussions

Recommended

Menu

AppManager

Top Contributors

Updated 14/6/11: Web page to show Primary & Secondary MS Assignment

Tags:

Labels:

Resources