Database Analysis Page

The Database Analysis command lets Administration Managers check user compliance with purchased licenses. You can list the names of system components, and the number of active and inactive users for each app and integration.

You must be logged in as a user assigned to the Administration Manager role.

To access this page:

From the compass, select Social and Collaborative Apps .
In the list of apps, click Collaboration and Approvals.
In the navigation pane, click Utilities > Database Analysis.


Section Name	Description
System Information	Lists each component and shows whether it is detected or not. The Comments column contains names or numbers for each component. See table below.
Core User Information	Shows the number of active and inactive users of the Studio Modeling Platform (MQL). These users are not counted as active/inactive users: creator, guest, Test Everything, User Agent, Corporate.
AEF Registered Users	Shows the number of active and inactive users of each of the installed apps.
Integrations Information	Shows the total, active, and inactive number of users of all integrations and the names of the installed integrations.

This table lists the Components that could show in the System Information section of the report:


Platform Component	Detected	Comment
Loosely Coupled Database (LCD)	Shows "Not Detected"	Shows "No remote vault." LCD's are no longer supported.
Platform Adaplet	Shows "Detected" or "Not Detected"	Lists the name of the adaplet .dll or shared library for foreign vaults. If none are detected, shows "No foreign vault."
File Collaboration Server (FCS)	Shows "Detected" or "Not Detected"	Lists the names of each FCS, based on the "fcs url" phrase on the `print store` and `print location`statements. If none are detected, shows "No site defined."
Database Replication	Shows "Not Detected"	Shows "0 connect string(s) used by 0 server(s)". Database replication via server administration objects is no longer supported.
Application Development Kit	Shows "Suspected" or "Not Detected"	Lists number of custom JPOs, based on the MQL`select property[installer].value expression`on the`print program`statement.