NetIQ AppManager 7.0.x
To view the Charts created in the QDB before the database was moved to another server, ensure that the Logon ID being used to access SQL on the new QDB server is identical to the Logon ID that was used to access SQL on the old QDB server then perform the following steps:
- Launch SQL Query Analyzer on the new QDB server.
- Select the QDB.
- Query the blob table to get the row values for previously existing charts by using the following query (This query will not work if the QDBis not the actively selected database in SQL Query Analyzer):
select * from blob
- You will get a return consisting of a list of rows representing chart info. The content of the "Comment" value is the piece you will want to inspect. On each chart row, the Comment value should be in the format: Charts_<QDB server name>\<qdb name>\<user> Where the <QDB server name> represents the name of the Server that previously hosted the QDB, <qdb name> represents the name of your QDB, and <user> represents the Logon ID being used to access SQL on the old QDB server.
- The content of that field should be the same on each row all the way through, unless multiple accounts were used to create Charts on the old QDB server. The existing Comment value on these old charts will need to be changed to match the Comment value as they would have appeared had the charts been created while the QDB was on the new QDB server. The following steps will help you to accomplish this:
- In the Operator Console that is pointing at the QDB on the new SQL Server, create ONE new chart.
- Re-query the blob table with the follwing query:
- select * from blob
- Compare the value in the Comment field on the old charts to the value of the Comment field for the newly created chart. The server name in the Comment field representing the previously created Charts will not match the server name of the new QDB SQL Server.
update blob set comment = 'Charts_<NEW QDB Server>\<qdb name>\<user>' where comment = 'Charts_<OLD QDB Server>\<qdb name>\<user>'
- select * from blob