API -Listing Requester details based on Requester name
1. Encode the below value, thereby replacing the Account, Site Name, followed by the Requester name in "Searchstring":
{
"operation": {
"details": {
"accountname": "Sample Account",
"sitename": "Sample Site",
"searchstring": "Alex Smith"
}
}
}
2. Make sure to include "Data=" on starting the parameter as highlighted below:
Note: Having two different users with the same name will list the users accordingly and as per the mentioned Account / Site name:
New to ADSelfService Plus?
Related Articles
Requester details
This report is used to find the Requester complete details. SELECT AaaUser.USER_ID, AaaUser.FIRST_NAME "FullName", AaaLogin.NAME "LoginName", AaaLogin.DOMAINNAME "Domain", AaaContactInfo.EMAILID "Email", DepartmentDefinition.DEPTNAME "Department", ...API -Listing requests based on Additional Field Values
This can be met through V3 API. Go to Admin > Incident Additional Fields and make a note of the "API Field Name" as highlighted below: Please follow the below mentioned to pull the requests based on the additional field values: 1. Use the Input as ...Top Requester based on Request
This report is used to get the top 10 requesters count based on the request. To make any changes to a query, refer to the KB article below. https://pitstop.manageengine.com/support/manageengine/ShowHomePage.do#Solutions/dv/24000627781192 SELECT ...API - Listing of Worklogtype
1. Go to Admin > API > Reports > Execute Query: select * from worklogtypedefinition 2. Sharing screenshot for your reference:Contract Details
SELECT mcdt.Contractid "Contract ID", mcdt.CONTRACTNAME "Contract Name", mcdt.comments "Description", contractcategory.Categoryname "Contract Type", LONGTODATE(mcdt.CREATEDDATE) "Created Time", LONGTODATE(mcdt.FROMDATE) "From Date", ...