Query to find out who created Accounts

Query to find out who created Accounts

Execute the below queries under  Reports->New  Query Report.

select org_id, org_name from accountdefinition ad where ad.org_name in('Requester Name', 'Palanivel Palras','Muhammad Nadeem Khan')

Note down the Org_IDs of the above query from the result and replace the ID in the below query.

SELECT err.message "System log message", err.errormodule "Module", err.suberrormodule "Sub Module", err.action "Action", err.type "Type", case when au.first_name is null then 'System' Else au.first_name end "Performed by", longtodate(err.occurredtime) "Time of occurrence" FROM errorlog err LEFT JOIN aaauser au ON err.ownerid=au.user_id WHERE
err.action like '%Add%' and err.errormodule like '%Account%' AND err.message like '%3301%'

NOTE: Replace the IDs one by one and execute the above query separately to know who created these accounts from the Performed By field.

          • Related Articles

          • Query to list the custom and query reports and the technician created

            Use case The query displays the custom reports and query reports saved by technicians. Query SELECT custrepdet.report_name "Report Name",               au.first_name"Created By" from customreportquery custrep LEFT JOIN customreport_details custrepdet ...
          • Query to find the time taken to assign a field

            Use case The query will pull a report of when an additional field was first assigned a value DB: MSSQL Query  Please replace additional field name with the Field Name Here. SELECT "wo"."WORKORDERID" AS "Request ID",  "ad"."ORG_NAME" AS "Account",  ...
          • Query to show technician created time

            PGSQL & MSSQL: SELECT AaaUser.FIRST_NAME "Technician Name", aci.emailid "Email ID", LONGTODATE(AaaUser.createdtime)  "Technician Created Time", SDUSER.STATUS "Status(Active/Inactive)" FROM AaaUser left JOIN SDUser ON AaaUser.USER_ID=SDUser.USERID ...
          • Query to find status change, its time and comments.

            Execute this query under Reports->New Query Report. Date filter is highlighted, you can modify it as per the need. PGSQL: SELECT wo.WORKORDERID "Request ID", aau.FIRST_NAME "Requester", std.STATUSNAME "Request Status", wo.TITLE "Subject", ...
          • How to remove a Scheduled Report Created By Another Technician

            Please note that you would not be able to edit the scheduled reports (private) created by other technicians. However, you can delete the unwanted scheduled reports you don't have access to, by connecting to the database. 1. In order to find the list ...