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"
New to ADSelfService Plus?
Related Articles
Query to Fetch Automatic Patch Deployment Data from Endpoint Central (Local DB Import)
Requirement: The requirement is to fetch Automatic Patch Deployment data from Endpoint Central into Analytics Plus using a custom query via local database import, enabling detailed reporting and analysis on patch automation. Solution: To achieve ...Query to Fetch Browser and Policy Data from Endpoint Central (Local DB Import)
Requirement: The requirement is to fetch Browser and Policy details from Endpoint Central into Analytics Plus using a custom query via local database import, enabling detailed reporting and analysis on browser usage and policy management. Solution: ...Query to Fetch Inactive Columns from a Workspace
Requirement: Customer wanted to determine the number of used or unused columns in a workspace. Solution: To achieve this, we need to connect to the Analytics Plus database by using local database import method (PostgrSQL) and then use the custom ...Query to Pull Asset Module data from ServiceDesk Plus
Please use the following query for Asset Module(General Details) PGSQL: select res.RESOURCEID AS "ASSET ID", res.RESOURCENAME AS "NAME", to_timestamp(res.ACQUISITIONDATE/1000) AS "ACQUISITION DATE", to_timestamp(res.WARRANTYEXPIRY/1000) AS "WARRANTY ...Query to fetch table sizes in the Analytics application
Requirement To determine the sizes of the tables available under our analytics application, we can execute the following query in the DB Query tool and retrieve the details. Query Navigate to Application Settings --> Troubleshoot --> DB Query Tool ...