Query to take the Email domain added in Account Domain field
Query to take the Domain field data - Email domain added in Account Domain Name)
select accountid, count(maildomain) from emaildomainaccountmapping group by accountid;
Go to Reports -> New query to execute the same.
New to ADSelfService Plus?
Related Articles
Query to get technician details(domain, associated account, email) from builds (MSSQL & PGSQL)
Tested in builds from PGSQL (14300) or MSSQL (14306) SELECT aau.first_name "First Name", sdu.lastname "Last Name", AaaContactInfo.EMAILID "Email Address", sdo.name "Associated Sites", adef.org_name "Associated Accounts", df.domainname "Domain Name" ...Query to find out who created Accounts (MSSQL & PGSQL)
Tested in build PGSQL (14300) and MSSQL (14306) 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 ...Query to retrieve Account details along with additional attributes, postal address and additional fields data
TESTED IN BUILDS: 14700 (Postgres) QUERY 1 - Without Account Additional Fields: select ad.ORG_NAME As "Account", org.description AS "DESCRIPTION", ad.LOGIN_WEBURI AS "LOGIN WEB URL", ad.LOGIN_URI AS "LOGIN URI", ad.SUPPORT_EMAIL AS "SUPPORT EMAIL", ...Send email notification to requester when a note is added to a request
How it works? A report will be scheduled to run at a periodic interval which will fetch he details of the request. Once the schedules runs, the script will fetch the values from the report and sends an notification through email to the requester of ...Query to show technicians associated accounts, sites and Support groups - (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) 1.Technicians and associated Accounts/Sites: select aau.User_id, aau.first_name "First Name", sdu.lastname "Last Name", aal.name "Login Name", AaaContactInfo.EMAILID "Email Address",sdu.jobtitle "Job ...