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 ...How to import description field details from ServiceDesk Plus to Analytics Plus?
Description details from the Requests' module are not available out-of-the box in Analytics Plus as it might contain HTML contents and cannot be displayed properly for reporting. However, if you wish to import description details into Analytics Plus, ...Problem Module Data import
Importing Problem data into Analytics Plus: You could log into the Analytics Plus 'ME ServiceDesk Plus Analytics' database and start creating these two tables using the below queries. Check this link for steps to import data from Local DB. Problem ...Query table throws error upon execute query - Linux - 4400 and above
Issue: Query table's 'execute query' will throw an error as shown below. Even when executing 'select 1', we might get this error. Build affected: 4400, 4410 and 4420 Only on Linux installations Cause: It is due to internal code changes and will be ...