This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Help with an SQL script please.

Hello people.

I am not good with SQL.  In fact you might as well be talking Russian when you start talking about SQL scripts.

I am trying to produce a chart for the following interfaces:

pastedImage_0.png

Now, the interface IDs are as follows:

pastedImage_1.png

Which is why I have (with the help of soalrwinds) got the following script:

SELECT TimeStamp, ComponentID, MinStatisticData, AvgStatisticData, MaxStatisticData

FROM APM_ChartEvidence2

WHERE ComponentID = '11826'

But when I run that through a custom chart I get the following:

pastedImage_3.png

Which is basically what number I input.

So looking at how it's built, this is what I produced.

pastedImage_4.png

So, could someone please offer me some advice on this issue please?