Ticket creation from external email sender.
To parse the email from external email address. Follow the below configuration.
We have to enable this option to accept "unknown email" (not setup on the system), under Admin > Self-service Portal.
Also, select the below option as per your convenience to add the unknown user in the application.
If you choose to add "unknown user" as "unapproved user". The request will be created placed under unknown request.
Reject emails sent from unknown requester and send notification using scripts for 10.6 and above.
This script is specifically for 10.6 and above Usecase : Organizations don't want to handle/fetch unapproved contacts mails into the application. They also want to notify the end user when they send email stating-> "The Request raised by you is ...
Last Login Report - All Users
SELECT AaaUser.FIRST_NAME "Users", MAX(AaaLogin.NAME) "LoginName", MAX(AaaContactInfo.EMAILID) "Email", MAX(AaaAccSession.USER_HOST) "IP Address", longtodate(MAX(AaaAccSession.OPENTIME)) "Logged In Time" , longtodate(MAX(AaaAccSession.CLOSETIME)) ...
Script to send notifications when a unknown request is raised
Use case The script will send email notifications to the address configured inside the script whenever a request is created under unknown requests. This notification will be sent to Admin Email Pre-requisite - Python should be installed in the ...
Criteria for User Account overwrite in Active Directory User Imports
While performing a user import from Active Directory, Criteria 1: ObjectGUID - If the ObjectGUID of a user account in ServiceDesk Plus MSP matches with the user account in Active Directory, then the record in ServiceDesk Plus MSP will be ...
Query to know the User details,account,site based on email
select aaau.user_id,aaau.first_name, aaaci.emailid,sdu.status, sdo.name "Site", adef.org_name "Account" from aaauser aaau LEFT JOIN aaausercontactinfo aaauci ON aaauci.user_id=aaau.user_id LEFT JOIN aaacontactinfo aaaci ON ...