AppManager Custom Property Report - Version 7.2.1.1

0 Likes
over 11 years ago
AppManager Custom Property Report:

Update: 12-2-2011

Added Report KS Version to report for better tracking of changes. 

Verified on latest AM 7.x Hotfixes.

Update: 10-25-2010

Steve - Added support for Case Sensitive SQL Server Databases.  

This report list out the currently deployed Custom Property settings, with sublinks into which systems have the custom property attached and the current value set for the system. 


Installation Steps:

1.       Copy the NetIQ_AM_Custom_Property_Report_Setup_V7.2.1.1.sql SQL script to either the AppManager Repository Server or a workstation that has SQL Query Analyzer/Management Studio with access to the AppManager Repository Server.


2.       Open the SQL Script in SQL Query Analyzer/Management Studio and connect to the AppManager Repsoitory Server.


3.       Select the AppManager Repository Database “QDB” from the Database drop down menu. 


4.       Execute the script, which creates the _AM_Custom_Property_Report stored procedure used by the AMADMIN_AM_Custom_Property_Report reporting knowledge script. 


5.       Copy the AMADMIN_AM_Custom_Property_Report.qml knowledge script to a system that has the Operator/Control Center Console installed. 


6.       Navigate to the Knowledge Script view/pane, right click and select check-in KS. 


7.       Browse to the location of the AMADMIN_AM_Custom_Property_Report.qml file and click ok. 


8.       In the AppManager Operator/Control Center Console deploy the AMADMIN_AM_Custom_Property_Report ks to the AppManager Report Agent installed in the environment.  







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/

Labels:

How To-Best Practice
Comment List
Anonymous
Related Discussions
Recommended