i'm saving MS perfmon data into a MSSQL db. Perfmon is automatically creating a db that have 3 tables
1. CounterData ( GUID,[int]CounterId,[char(24)]CounterDateTime )
2. CounterDetails ([int]CounterID,[varchar(1024)]MachineName,[varchar(1024)]CounterName,[varchar(1024)]ObjectName)
3. DisplaytoID (GUID,[int]MinutestoUTC)
when i'm using a simple table panel with the following sql query the data is showed
SELECT MachineName, CounterValue, CounterDateTime, CounterName, ObjectName > FROM CounterDetails INNER JOIN CounterData ON CounterDetails.CounterID = CounterData.CounterID INNER JOIN DisplayToID on DisplayToID.GUID = CounterData.GUID WHERE $__timeFilter(CounterDateTime) AND MachineName in($hostname) ORDER BY 1
But when i’m trying to have a Graph setting " format as" Time Series i doesn’t show anything . I think the reason why is because the CounterDateTime column is NOT in datetime type but
- i’m not sure of it
- don’t have any idea how to convert it