Query
Steps to import Archived Request into Analytics Plus
By default, we don't import archived request details into Analytics Plus but we are working on a model to import these details out of the box and will be available in one of our future builds. Meanwhile, please follow the below text instructions Step ...
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 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 ...