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.

Custom Chart with Data driven by SWQL QuerySQL

IanBaker over 4 years ago

I am having real problems ... nothing I have seen before and wondered if anyone knows why

I generate data using an SQL query. Relatively simple ... Links a bit of Data

SELECT s.TimeStamp, n.SysName, a.InstanceName, d.Name, f.PhysicalName, f.Size, f.UsedSpace

FROM Orion.Nodes n

,Orion.APM.SqlServerApplication a

,Orion.APM.SqlDatabase d

,Orion.APM.SqlDatabaseFile f

,Orion.APM.SqlDatabaseFileStatistic s

WHERE n.SysName = 'XXXXXXXXXXX'

AND n.NodeId = a.NodeId

AND d.ApplicationId = a.ApplicationId

AND d.DatabaseId = f.SQLDatabaseId

AND f.databasefileid = s.databasefileid

AND f.FileType = 0 AND d.Name = 'msdb'

order by n.SysName, a.InstanceName, d.Name, f.PhysicalName

Produces the data I want:

However, when I try and Throw the same datasource into the Chart and select "ADD DATA SERIES" I get this?

Settings are :

Where am I going wrong?

Top Replies