How to construct a query to pull additional fields - Asset
To find Alais name of an asset additional field name
select COLUMNNAME,ALIASNAME from columnaliases where tablename='Resource_fields'
Sample Additional fields
- Environment
- Hosting Platform
- Patching Time-Frame
- MFA
- Function
- Datacenter
- Backups Scheduled
- DXC Disposed Date
- Sensitive Data
- DMZ
- OS Expiry Date
Sample
select resFields.resourceid,resFields.UDF_CHAR1 AS "Environment",resFields.UDF_CHAR2 AS "Hosting Platform",resFields.UDF_CHAR3 AS "Patching Time-Frame",resFields.UDF_CHAR4 AS "MFA",resFields.UDF_CHAR5 AS "Function",resFields.UDF_CHAR6 AS "Datacenter",resFields.UDF_CHAR7 AS "Backups Scheduled",resFields.UDF_CHAR8 AS "DXC Disposed Date",resFields.UDF_CHAR9 AS "Sensitive Data",resFields.UDF_CHAR10 AS "DMZ",longtodate(resFields.UDF_DATE1) AS "OS Expiry Date" FROM Resource_fields resFields
New to ADSelfService Plus?
Related Articles
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 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 ...Query Reports not refreshing on Build 3600
Issue: Once migrated to 3600, the existing query reports do not get refreshed with latest data. Needs manual update. Solution: This seems to be breakage in 3600 builds. Open the <AnalyticsPlus\conf\ app.properties> file and then change the value ...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 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 ...