Script to list the number of SQL PI agents assigned to each Fglam and PI repository (4226978)

Download and run the attached groovy in the script console to list the SQL PI agents and their PI repositories and Agent Managers. This  script will list agents that have PI enabled in their configuration, even if those agents are currently turned off (not running or inactive). Users must be logged into Supportlink to download this script.

1. Navigate to Administration | Tooling | Script Console.
2. Select the Scripts tab
3. Click the Add button
4. Paste the script text from below into the dialog box
5. (optional) Enter a title for the script
6. (optional) Click the Save button to save the script in the FMS
7. Click the Run button
8. Select Log Messages tab
9. Copy the output and paste the results into a text editor.

In the results

• The lines followed by a number represent the PI Agent Manager, with the number of total agents using that PI FglAM
• The lines preceded by ++++++++ are the agent managers where the database agents are installed, followed by the number of database agents with PI
• The lines preceded by ++++++++++++++++ are each of the database agents with the PI extension enabled using those agent managers