Query to display Accounts and Sub Accounts (8.1)
Execute the below query from the Reports Tab -> New Query (Applicable for 8.1 version)
SELECT acc.NAME AS "Account",sorg.NAME AS "Sub Account" FROM Customer cust
LEFT JOIN AaaOrganization acc ON cust.CUSTOMER_ID=acc.ORG_ID
LEFT JOIN SubAccount subacc on cust.CUSTOMER_ID=subacc.parentaccountid
LEFT JOIN AaaOrganization sorg ON subacc.subaccountid=sorg.ORG_ID
LEFT JOIN Department_Account dep_acc ON cust.CUSTOMER_ID=dep_acc.ACCOUNTID
WHERE (cust.customer_id not in (select subaccountid from SubAccount) and dep_acc.DEPARTMENTID = 1) order by acc.NAME, sorg.NAME
New to ADSelfService Plus?
Related Articles
Query to find contact associated in Sub-accounts
SELECT org.NAME "Account Name",aaauser.FIRST_NAME "Contact Name",ucinfo.EMAILID "Contact Email", au1.first_name "Subaccount Contact's name", aci.emailid "Subaccount's contact's email address" FROM AaaUser aaauser LEFT JOIN AaaUserContactInfo ...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 ...Query to display task details and associated account (start date, due date, createdby, assigned to, etc.,)
Use the below query to show all task information (columns listed : taskid, title, Linked account, start date, due date, status, Description, Assigned to, Created by and Created time) select td.taskid, ad.title, org.name as "Linked Account", ...Steps to Import accounts / contacts through schedule csv from SCP 11001 build
This is applicable only from 11001 builds. How to do? # Based on the Globalconfig table entry with category as 'CSVUserImportSchedule', this can be turned ON/OFF. By default this is turned OFF. Query to enable the feature - update Globalconfig set ...Apply Contract to All Requests raised by this account option is greyed out while creating a new contract
1. Whenever I put in Expiry date the checkbox for Apply Contract to All Requests raised by this account becomes greyed out. --> This will happen if there is another active contract for the same period. Two rules are applied while creating a contract ...