The Performance Management Baseline Deviation App fails to render the View. When the View is rendered instead of the expected chart, an error referencing "Uncaught XMLHttpRequest" is seen. This App is a Github provided App for Performance Management. More information can be found in the Community thread where it was first provided in CA PC App: Baseline Deviations.
All supported Performance Management releases
Support for App related problems is obtained through the Community site.
Alternative solution using mysql commands. This could be used to set up a script to run a cron job weekly that adds new users to the config to allow them access to the Views.
Use sql command to update the netqosportal PC database in the general table. Update the daProxyValidUsers attribute value with a comma separated list of user names. This allows the users access to the query run to allow the View to function properly.
Provide Access to Limited Users
This command will generate a comma separated list of user names created in the system:
Lab example with just two users shows:
mysql> select GROUP_CONCAT(Name) from user_definitions;
+--------------------+
| GROUP_CONCAT(Name) |
+--------------------+
| admin,user |
+--------------------+
1 row in set (0.00 sec)
Take the resulting comma separated list and remove any users that should not be permitted access to this View and it's data. Take the resulting list and insert it into this command to add the users to the daProxyValidUsers attribute value. Command with reference for where the comma separated list goes:
Add All Users At Once
To add all users at one time with a single command without control over access run the following command:
Add Users Individually
Basic command example to add 2 users by hand. Add more users as needed separating each with a comma:
In a lab with just two users to add them the command is:
Sample output adding two users. We'll only ever see 1 row affected as the value is a single entry for a single field, thus one single row affected.
mysql> replace into netqosportal.general values('daProxyValidUsers','admin,user');
Query OK, 1 row affected (0.00 sec)
Remove Users
To remove users we re-issue the replace command with the full permitted user list, minus the users targeted for access removal.
Listing User Currently Set
What users are currently set? The command to list out which users are currently assigned:
Sample output listing users currently set:
mysql> select * from general where attribute='daProxyValidUsers';
+-------------------+------------+
| Attribute | Value |
+-------------------+------------+
| daProxyValidUsers | admin,user |
+-------------------+------------+
1 row in set (0.00 sec)