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 details of custom reports which are created and saved by other support reps
SELECT * FROM customreport_details WHERE ownerid!='-1';
From the above query take a copy of the reports that you want to modify/delete and make note of the "userID"
To find the userID of the support reps run the below query
Select * from aaauser;
After you get the USERID now execute the below query to change the ownerid
Update customreport_details set ownerid= newownerid where ownerid= oldownerid;
Then the new owner can login and modify/delete the report.
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 details of custom reports which are created and saved by other support reps
SELECT * FROM customreport_details WHERE ownerid!='-1';
From the above query take a copy of the reports that you want to modify/delete and make note of the "userID"
To find the userID of the support reps run the below query
Select * from aaauser;
After you get the USERID now execute the below query to change the ownerid
Update customreport_details set ownerid= newownerid where ownerid= oldownerid;
Then the new owner can login and modify/delete the report.
New to ADSelfService Plus?
Related Articles
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. ...Assessment reports
Datebase: MSSQL Status wise: select wo.workorderid, sd.statusname,convert(varchar(5),(sum(wsi.timespent))/60)+':'+convert(varchar(5),((sum(wsi.timespent))%60))'timespent' from workorder wo join wo_assessment wa on wo.workorderid=wa.workorderid join ...Issue running reports
Cause : Report API running the background causes the issue. If the user mentions issue with running reports with the below error and trace as mentioned below. Error trace: ...Login Frequency Query Report
The below report would help us find the last logged in time of the users in SCP 11.0 SELECT AaaUser.FIRST_NAME "Technician", MAX(AaaLogin.NAME) "LoginName", MAX(AaaContactInfo.EMAILID) "Email", MAX(AaaAccSession.USER_HOST) "IP ...Phone number need to be mandatory in 8.1 for contacts
Kindly follow the steps below to create the FAFR, 1. Access admin Module 2. Select the request template option and click the edit option the required request template the script needs to be applied on 3. Select the Fields and Forms Rule tab and paste ...