Environment
NetIQ AppManager 6.X
NetIQ AppManager 7.0.X
NetIQ AppManager 7.0.X
Situation
How do I view charts that were created in the QDB by an account that is no longer available?
Resolution
To view a chart created by an account that is invalid or no longer available use SQL Query Analyzer. In SQL Query Analyzer select the QDB before attempting to make any changes. Then run the following query against the QDB to change the name of the account that was used to create the chart:
update blob
set comment = 'Charts_<QDB Server>\<qdb name>\<New User ID>'
where comment = 'Charts_<QDB Server>\<qdb name>\<Old User ID>
The New User ID must have Administrative rights to SQL, and should be the account that is being used to write data to the QDB.
Additional Information
Formerly known as NETIQKB42217
This query is best used when the name of the account that is being used to write data to the QDB has been changed, or is no longer a valid ID in the domain, and there is a need to view charts that were created using the now-invalid account
This query is best used when the name of the account that is being used to write data to the QDB has been changed, or is no longer a valid ID in the domain, and there is a need to view charts that were created using the now-invalid account