Queries to collect data before Id migration/Migrating from Professional to Enterprise Edition
Collect query output from Managed server / Professional Edition:
To check Id range :
- Select min(resourceid),max(resourceid) as AM_ManagedObject from AM_ManagedObject where resourceid > 10000000;
- Select count(*) as AM_ManagedObject_Count from AM_ManagedObject;
- Select min(Id),max(Id) as Alert from Alert;
- Select min(Id),max(Id) as Event from Event;
- Select min(RELATIONSHIPID),max(RELATIONSHIPID) as AM_PARENTCHILDMAPPER from AM_PARENTCHILDMAPPER;
NOTE: Before collecting below query output ensure that the Query tool max row count value has been updated with max value.
To check MO count list based on its type:
select m.displayname as ParentName,m.type as ParentType,m1.type as ChildType,count(m1.type) from AM_ManagedObject m join AM_PARENTCHILDMAPPER p on m.resourceid=p.parentid join AM_ManagedObject m1 on m1.resourceid=p.childid and m.type!='HAI' group by m1.type,m.displayname,m.type order by 4 desc;
To check MO count based on resource name:
select m.displayname as ParentName,m.type as ParentType,m1.type as ChildType,m1.resourcename as ChildName,count(m1.resourcename) from AM_ManagedObject m join AM_PARENTCHILDMAPPER p on m.resourceid=p.parentid join AM_ManagedObject m1 on m1.resourceid=p.childid and m.type!='HAI' group by m1.type,m.displayname,m.type,m1.resourcename order by 5 desc;
To check stray entries in AM_ManagedObject:
select TYPE,count(TYPE) from AM_ManagedObject where RESOURCEID not in (Select PARENTID from AM_PARENTCHILDMAPPER) and RESOURCEID not in (Select CHILDID from AM_PARENTCHILDMAPPER) and TYPE not like '%_TEMPLATE%' and TYPE not in (Select distinct(RESOURCEGROUP) from AM_ManagedResourceType) and type not in (Select distinct(RESOURCETYPE) from AM_ManagedResourceType) and TYPE not in ('DUMMY','Interface','Script Monitors') group by TYPE order by 2 desc;
To check database size:
For PGSQL
select table_schema as schema_name, ((pg_database_size(current_database())) / (1024 * 1024)) as "database_size in MB" from information_schema.tables where table_schema=current_schema() group by schema_name
For Microsoft SQL
select name,sum(CONVERT(DECIMAL(10,2),(size * 8.00) / 1024.00)) As 'database_size (MB)' from master.sys.master_files where name in (select DB_NAME()) group by name;
Collect query output from Admin server:
select * from AM_MAS_Server;
New to ADSelfService Plus?
Related Articles
How to perform migration to fix "ID out of allocated range" issue or unable to add managed server into admin server due to "server id does not match" error in Applications Manager
If the id value used internally for the monitors crosses the server id value specified in Settings -> Support -> Installation Information -> Server Id - Managed server, then you will get the following alert in Admin server: For existing Managed ...Convert Professional edition to Enterprise edition
Install an "Admin Server" with the same build number as that of your professional edition. (You can find the build number in Settings -> Tools -> Support -> Build number) Archive link: http://archives.manageengine.com/applications_manager/ After ...What are the prerequisites required to monitor 'Top 10 Queries By CPU' in KingbaseDB monitor?
1. Include the below lines in kingbase.conf file located in <Data DIRECTORY>: shared_preload_libraries = 'sys_stat_statements' sys_stat_statements.track = all 2. Execute the below commands in psql shell if the extension sys_stat_statements is not ...Tachometers not being displayed on Admin server console in Enterprise Edition
Problem: Tachometers are not displayed on the Admin server console in Enterprise Edition. Solution: 1. Login to Admin Server UI. 2. Navigate to Admin -> Global Settings -> Enterprise Edition Settings. 3. Kindly enable the Proxy Managed Server request ...Add new Managed server with existing server ID
To add a new managed server with an existing server ID, follow these steps: 1. Install the App Manager Professional Edition (Ensure it's the same as the Admin version). Refer this link for more details. 2. Update the 'am.server.startresidrange' as ...