Site24x7 Solution Queries
This page contains queries that are used in Solution for Site24x7 Advanced Analytics
Internet Service Performance for each Monitor Group
This query consolidates internet service performance for each Monitor Group.
SELECT
"mg"."Account Id" as 'Account ID',
"mg"."Group Id" as 'Group Id',
"mg"."Group Name" as 'Group Name',
"mi"."Category" as 'Category',
"mi"."Data Collection StartTime" as 'Data Collection StartTime',
"mi"."DataCenter Id" as 'DataCenter Id',
"mi"."FQDN" as 'FQDN',
"mi"."Host Name" as 'Host Name',
"mi"."Inventory Status" as 'Inventory Status',
"mi"."IP Address" as 'IP Address',
"mi"."Monitor Id" as 'Monitor Id',
"mi"."Monitor Name" as 'Monitor Name',
"mi"."Monitor Type Key" as 'Monitor Type Key',
"mi"."Monitor Type Name" as 'Monitor Type Name',
"mi"."Tag Ids" as 'Tag Ids',
"isp"."Attribute Key" as 'Attribute Key',
"isp"."Attribute Name" as 'Attribute Name',
"isp"."Continent" as 'Continent',
"isp"."Count" as 'Count',
"isp"."Date" as 'Internet Service Perfomance Date',
"isp"."Location Name" as 'Location Name',
"isp"."Maximum" as 'Maximum',
"isp"."Minimum" as 'Minimum',
"isp"."NinetyFifth Percentile" as 'NinetyFifth Percentile',
"isp"."Performance" as 'Performance',
"isp"."Standard Deviation" as 'Standard Deviation',
"isp"."Step Id" as 'Step Id',
"isp"."Sum" as 'Sum',
"isp"."Units" as 'Units'
FROM "Monitor Groups" AS 'mg'
INNER JOIN "Group Mapper" AS 'gm' ON "mg"."Group Id" = "gm"."Group Id"
INNER JOIN "Monitors Inventory" AS 'mi' ON "gm"."Monitor Id" = "mi"."Monitor Id"
INNER JOIN "Internet Services Performance" AS 'isp' ON "mi"."Monitor Id" = "isp"."Monitor Id"
Infrastructure Performance for each Monitor Group
This query consolidates the infrastructure performance for each Monitor Group.
"mg"."Account Id" as 'Account ID',
"mg"."Group Id" as 'Group Id',
"mg"."Group Name" as 'Group Name',
"mi"."Category" as 'Category',
"mi"."Data Collection StartTime" as 'Data Collection StartTime',
"mi"."DataCenter Id" as 'DataCenter Id',
"mi"."FQDN" as 'FQDN',
"mi"."Host Name" as 'Host Name',
"mi"."Inventory Status" as 'Inventory Status',
"mi"."IP Address" as 'IP Address',
"mi"."Monitor Id" as 'Monitor Id',
"mi"."Monitor Name" as 'Monitor Name',
"mi"."Monitor Type Key" as 'Monitor Type Key',
"mi"."Monitor Type Name" as 'Monitor Type Name',
"mi"."Tag Ids" as 'Tag Ids',
"ip"."Attribute Key" as 'Attribute Key',
"ip"."Attribute Name" as 'Attribute Name',
"ip"."Count" as 'Count',
"ip"."Date" as 'Infrastructure Performance Date',
"ip"."Maximum" as 'Maximum',
"ip"."Minimum" as 'Minimum',
"ip"."NinetyFifth Percentile" as 'NinetyFifth Percentile',
"ip"."Performance" as 'Performance',
"ip"."Standard Deviation" as 'Standard Deviation',
"ip"."Sum" as 'Sum',
"ip"."Units" as 'Units'
FROM "Monitor Groups" AS 'mg'
INNER JOIN "Group Mapper" AS 'gm' ON "mg"."Group Id" = "gm"."Group Id"
INNER JOIN "Monitors Inventory" AS 'mi' ON "gm"."Monitor Id" = "mi"."Monitor Id"
INNER JOIN "Infrastructure Performance" AS 'ip' ON "mi"."Monitor Id" = "ip"."Monitor Id"
Outage/Downtime across Monitor Groups
This query consolidates the outage/downtime across Monitor Groups.
"mg"."Account Id" as 'Account ID',
"mg"."Group Id" as 'Group Id',
"mg"."Group Name" as 'Group Name',
"mi"."Category" as 'Category',
"mi"."Data Collection StartTime" as 'Data Collection StartTime',
"mi"."DataCenter Id" as 'DataCenter Id',
"mi"."FQDN" as 'FQDN',
"mi"."Host Name" as 'Host Name',
"mi"."Inventory Status" as 'Inventory Status',
"mi"."IP Address" as 'IP Address',
"mi"."Monitor Id" as 'Monitor Id',
"mi"."Monitor Name" as 'Monitor Name',
"mi"."Monitor Type Key" as 'Monitor Type Key',
"mi"."Monitor Type Name" as 'Monitor Type Name',
"mi"."Tag Ids" as 'Tag Ids',
"Alarms"."Continent" as 'Continent',
"Alarms"."Country" as 'Country',
"Alarms"."Duration in Hours" as 'Duration in Hours',
"Alarms"."Duration in Minutes" as 'Duration in Minutes',
"Alarms"."Duration in Seconds" as 'Duration in Seconds',
"Alarms"."Location Name" as 'Location Name',
"Alarms"."Reason" as 'Reason',
"Alarms"."Resolved IP" as 'Resolved IP',
"Alarms"."Start Time" as 'Start Time',
"Alarms"."End Time" as 'End Time',
"Alarms"."Status" as 'Status'
FROM "Monitor Groups" AS 'mg'
INNER JOIN "Group Mapper" AS 'gm' ON "mg"."Group Id" = "gm"."Group Id"
INNER JOIN "Monitors Inventory" AS 'mi' ON "gm"."Monitor Id" = "mi"."Monitor Id"
INNER JOIN "Alarms" ON "mi"."Monitor Id" = "Alarms"."Monitor Id"