Objective  

The objective of this integration is to synchronize hardware summary details from Endpoint Central (EC) to ServiceDesk Plus On-Premise (SDP).

The following fields will be synced:

• Acquisition Date (Purchase Date)

• Warranty Expiry Date

• Asset Tag

Configuration Steps  

1. Place Required Files  

Ensure the following files are placed in the appropriate directories:

• Place the executor file:
  hardwaresummarysync.txt
  under:[Application Home]/integration/custom_scripts/executor_files

• Place the script file:
  HardwareSummarySync.py
  under:[Application Home]/integration/custom_scripts
  Note: Configure server details and API key before placing the file.

        

2. Create Query Report for Hardware Summary Sync  

1. Navigate to the Reports tab.

2. Click on New Report → Select Query Report.

3. Run the following query:

select r.resourceid,r.resourcename,ro.otherappid from resources r inner join RESOURCES_OTHERAPPSMAP ro on r.resourceid = ro.resourceid where r.warrantyexpiry is null or r.acquisitiondate is null or r.assettag is null

4. Save the report with the name:
   Hardware Summary Sync

5. Save it under the All Computers folder.

3. Create Custom Schedule  

1. Navigate to:
   Admin → Automation → Custom Schedule

2. Click Create New Schedule.

3. Configure the following:

• Schedule Name:
  Hardware Summary Sync

• Executor:
  Select Execute Script

• Executor File Name:
  hardwaresummarysync.txt

• Argument:
  Select the query report
  Hardware Summary Sync

4. Configure the frequency as required (daily, weekly, etc.).

5. Save the schedule.

Result  

Once configured, the custom schedule will automatically:

• Fetch systems where hardware summary fields are missing.

• Execute the custom script.

• Synchronize Acquisition Date, Warranty Expiry Date, and Asset Tag from EC to SDP.