Given all the AWESOME help I have received from this forum I have made great progress in my project. So thank you all for that, SW has a great community of people.
I am looking at the following tables in teh database:
Nodes
APM_AlertsAndReportsData
APM_StatisticsUsage
APM_ApplicationStatus
My query is:
SELECT A.Customer,
A.Caption AS NodeName,
A.NodeID,
C.DateTime,
B.ApplicationName,
B.ApplicationStatus,
B.ComponentName,
B.ComponentStatus,
C.MinStatisticData,
C.MaxStatisticData,
C.AvgStatisticData,
D.PercentAvailability
FROM [dbo].[Nodes] AS A
JOIN [dbo].[APM_AlertsAndReportsData] AS B
ON ( A.Caption = B.NodeName )
JOIN [dbo].[APM_StatisticsUsage] AS C
ON ( B.ComponentID = C.ComponentID )
JOIN [dbo].[APM_ApplicationStatus] AS D
ON ( B.ApplicationID = D.ApplicationID )
It returns SOOO much data. So either my query is poorly written (which is VERY possible 
) or I am looking in the wrong place for this data. I wan to have history of applications and its components.
Hopefully this makes sense.
