Monitor Group filter for APM Alarms Query
SELECT
"APM Monitor Group to Monitor Mapping"."Group ID" ,
"APM Monitor Group to Monitor Mapping"."Resource ID",
"APM Monitor Groups"."Group Name"
FROM "APM Monitor Group to Monitor Mapping",
"APM Monitor Groups"
WHERE "APM Monitor Group to Monitor Mapping"."Group ID" = "APM Monitor Groups"."Group ID"
New to ADSelfService Plus?
Related Articles
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 ...Filters getting duplicated when reports are saved and reopened
This issue is seen in Analytics Plus build 3800. Issue: When a filter is added/edited to a report and saved, the report shows up fine. But, when we close and reopen the report, the filter gets duplicated and causes issues in loading the right data. ...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 ...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 ...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 ...
