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 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 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 ...Initial Sync Failed Between ServiceDesk Plus Cloud and AnalyticsPlus Cloud due to Custom Field Names
Issue The initial synchronization between ServiceDesk Plus Cloud and AnalyticsPlus Cloud failed because custom field names in ServiceDesk Plus contained backslashes (\). Error screenshot for reference Cause This is due to a limitation in the SDPOD ...How to pull the attachment information of all the users from Servicedesk plus to Analytics plus ?.
If you are looking to import the information for the attachment of the user module as shown below, Sample imported table in the Analytics plus UI: Then, please follow the below instructions: 1. Login to your Analytics Plus and go-to your ServiceDesk ...