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"  

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',
"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"  

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',
"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"