Changing the ownership of Report
In order to change the ownership of the existing Reports, please follow the below steps, 1. connect to your database. Incase, if your connecting database is postgresql, please refer the below link to connect to it. viz. 2. Execute the below query to find the list of Reports, select * from customreport_details The above query will display the list of all Reports available in the application. 3. Choose the Reportid from the result of the executed query and the ownerid. 4. Now execute another query to find the list of users(viz. their names and other details), select * from aaauser 5. From the result of the above query, choose the user_id of the user to whom you want to give privilege for that Report. 6. Now in the query window, type the following query to apply the changes, update customreport_details set ownerid=** where reportid=**; In the above query, replace the ** with the respective values. For ownerid=**, replace with the user_id of the user to change the ownership. And in the reportid=**, replace with the values selected from the customreport_detail. |
New to ADSelfService Plus?
Related Articles
Scheduled Reports
This report is used to get the complete list of all the scheduled reports with the owner name configured in the application. SELECT CustomReport_Details.REPORT_NAME "Report Name", AaaUser.FIRST_NAME "Owner" FROM ReportScheduleTask LEFT JOIN ...Task related reports (MSSQL)
Tested in MSSQL build (14306) Sample Output and headers present in this report Goto reports -> New query report and executes the following SELECT taskdet.TASKID AS "Task ID", taskdet.MODULE AS "Module", taskprior.PRIORITYNAME AS "Priority", ...Asset Ownership History Report
Please use the below query to get the report on Asset Ownership History. SELECT r.resourcename AS "Workstation Name", ct.componenttypename AS "Product type", rs.displaystate AS "Asset State", aa.first_name AS "Assigned User", LONGTODATE(sh.starttime) ...Steps for deleting/modifying the reports created by other techs:
Steps for deleting/modifying the reports created by other techs: Connect to your database To connect to your database please refer http://www.manageengine.com/products/support-center/faq-general.html Execute the below query which will give you the ...Query report to extract Active Technician Login and IP Address (MSSQL & PGSQL)
Tested in builds PGSQL (14300) or MSSQL (14306) Go to Reports- New Query Report and execute this query. select DISTINCT ac.ACCOUNT_ID as "Login Account ID", au.FIRST_NAME as "Technician Name ( First Name )", count(acs.SESSION_ID) as "Number of ...