Query to Fetch Warranty Details from Endpoint Central
Requirement:The requirement is to fetch warranty expiry details of managed machines from Endpoint Central into Analytics Plus using a custom query through local database import. This enables users to track warranty coverage, identify machines nearing warranty expiry, etc.
Solution:To achieve this, connect to the backend database of the Endpoint Central application and imported the warranty details into Analytics Plus using a custom SQL query through the Local Database Import option.
Steps to Import Data from Local Database:Navigate to: Analytics Plus → Endpoint Central Workspace → Import Data → Local Database
Enter the required database connection details:
Hostname:
Port:
Database Name:
Username:
Connection Type: Data Import
Note:Ensure that the appropriate Endpoint Central database is selected and that the necessary database access credentials and permissions are available before proceeding with the import. Here is a guide that provides step-by-step instructions for Configuring Remote Access to the Database in Central Server.
Query:SELECTm.resource_id as "Computer ID",
m.full_name as " Computer Full Name",
to_timestamp(invce.WARRANTY_EXPIRY_DATE/1000) as "Warranty Expiry Date"
from
InvComputerExtn invce
join managedcomputer m on
invce.computer_id = m.resource_id
where
m.managed_status not in (65, 66)
order by
"Computer ID"