Analytics Plus inventory

Analytics Plus Inventory

Aim:

To have the detailed list of all the Reports, Databases created in Analytics 
  1. Open Local & Cloud Databases and fill the entries password = Postgres and if any error occurs stating something like "check the DB connection" change the Port to "33376" and try again.
  2. In the next page select "Single table" and select the table "iamemail". 
  3. Name the Database as "Inventory of Analytics".
  4. In the final import tab, schedule it for whichever frequency is required.
  5. Inside the Database "Inventory of Analytics", click on Create new table -> Local & Cloud Databases and follow the steps followed in Step 1, but change the Database Name as "zreportsdb".
  6. Click on Multiple tables and select the following tables - zdbdbobject, zdbmailscheduleobjects, zdbscheduledemails.
  7. In the final import tab, schedule it for the frequency you scheduled the earlier table.

Now create the following query tables(in the same order)

Query table 1 :-

Name it as -  Reports Created  
SELECT
"zdbdbobject"."displayname" "Report Name",
"iamemail"."email_id" "Created By",
"zdbdbobject"."description" "Description",
FROM_UNIXTIME("zdbdbobject"."createdtime" / 1000) "Created Time",
"zdbdbobject"."id" "ObjID"
FROM  "iamemail",
"zdbdbobject" 
WHERE "iamemail"."zuid"  = "zdbdbobject"."owner_zuid"
 AND "iamemail"."zuid"  > 107
 AND "zdbdbobject"."type"  NOT IN ( ('0')  , ('6')  , ('7')  )
 
This Query table will contain the report name, report description, user who created it, created time.


Query table 2 :-

Name it as - Dashboards Created
 SELECT
"iamemail"."email_id" "Created By",
"zdbdbobject"."displayname" "Dashboard Name",
"zdbdbobject"."description" "Description",
FROM_UNIXTIME("zdbdbobject"."createdtime" / 1000) "Created Time",
"zdbdbobject"."id" "ObjID"
FROM  "iamemail",
"zdbdbobject" 
WHERE "iamemail"."zuid"  = "zdbdbobject"."owner_zuid"
 AND "iamemail"."zuid"  > 107
 AND "zdbdbobject"."type"  IN ( ('7')  )

This Query table will contain the Dashboard name, Dashboard description, user who created it, created time.

Query table 3 :-

Name it as - Reports Scheduled
 SELECT
"Reports Created"."Created By" "Created By",
"Reports Created"."Report Name" "Report Name",
"Reports Created"."Description" "Description",
"zdbscheduledemails"."emailid" "Receiver Email Address"
FROM  "Reports Created" JOIN "zdbmailscheduleobjects" ON "zdbmailscheduleobjects"."objid"  = "Reports Created"."ObjID"  INNER JOIN "zdbscheduledemails" ON "zdbscheduledemails"."instance_id"  = "zdbmailscheduleobjects"."instance_id"  

This Query table will contain the Report Name, Created by and Email receiving user's email addresses.  

Query table 4:-

Name it as - Dashboard Scheduled
 SELECT
"Dashboards Created"."Created By",
"Dashboards Created"."Dashboard Name",
"Dashboards Created"."Description",
"zdbscheduledemails"."emailid" "Receiver Email Address"
FROM  "Dashboards Created" JOIN "zdbmailscheduleobjects" ON "zdbmailscheduleobjects"."objid"  = "Dashboards Created"."ObjID"  INNER JOIN "zdbscheduledemails" ON "zdbscheduledemails"."instance_id"  = "zdbmailscheduleobjects"."instance_id"  

This Query table will contain the Dashboard Name, Created by and Email receiving user's email addresses. 

Query Table 5:-
Name it as  - Database Created 
SELECT
 "zdbdatabase"."name" "Database Name",
 FROM_UNIXTIME("zdbdatabase"."createdtime" / 1000) "Created on",
 "iamemail"."email_id" " Created By"
FROM  "zdbdatabase" LEFT JOIN "iamemail" ON "iamemail"."zuid"  = "zdbdatabase"."owner_zuid"  
WHERE  "iamemail"."zuid"  > 107
 
This query table will contain the Database name, created time and the user who created it.

                  New to ADSelfService Plus?

                    • Related Articles

                    • Steps to enable Google Analytics Connector

                      1. Stop the Analytics Plus services. 2. Modify the entry under <Analytics Plus home>/reports/conf/app.properties show.create.google.analytics.view=true Note: If the above property is missing, add them. By default the value will be set to 'false' 3.  ...
                    • Compare Analytics Plus vs Zoho Reports

                      Please find the attachment
                    • How to connect to Analytics Plus database

                      This article will help you with the steps to connect to Analytics Plus database(Postgres) Note: Analytics Plus is bundled with Postgres and it cannot be changed to any other database due to reliability and chart rendering. Steps for Windows: 1. Open ...
                    • Move Analytics Plus from one Server/folder

                      Go to Start --> Services.msc and stop the ManageEngine Analytics Plus service. Take a backup of the entire <Analytics Plus_Home> directory and then move it to the new server.  On the new server, navigate to (similar path) <Analytics Plus_Home>\bin ...
                    • Servicedesk Plus gets logged off after integrating with ManageEngine Reports

                      Problem: Servicedesk Plus logs off randomly. Problem occurs after setting up integration between ManageEngine Reports and Servicedesk Plus. Solution: If you have installed Servicedesk Plus and ManageEngine Analytics Plus on same server, please access ...