Hi,
Why doesn't the dates match for the Custom Chart Graph? As you can see the Zoom Rang is incorrect and does not match the SQL data range. This is very confusing when have multiple graphs of different types on the same page. Please
Can you describe how this resource was created and where you are seeing this behavior? Date/time information is not typically displayed in the resource title itself. I'd like to attempt to reproduce the issue but I'll need more details on what resource this is, what type of information is being displayed etc.
So let me start from the beginning, I'm adding a custom chart to a view and proceeding to edit it (/Orion/NetPerfMon/Resources/Reports/EditCustomChartTableWrapper.aspx)
Then I "SELECT DATASOURCE", and add the custom SQL, as follows,
DECLARE @endDate DateTime = ${toTime}DECLARE @startDate DateTime = ${fromTime}SELECT M.DateTime, M.AvgNumericData as "writes per second", N.Caption as "MultiData"FROM APM_MultiValueReportsData M WITH(NOLOCK)JOIN APM_Component C on C.ID = M.ComponentIDJOIN APM_Application A on A.ID = C.ApplicationIDJOIN Nodes N on N.NodeID = A.NodeIDWHERE C.Name like 'DISK%' and M.Name in ('writepers') AND M.DateTime between @startDate AND @endDate
DECLARE @endDate DateTime = ${toTime}
DECLARE @startDate DateTime = ${fromTime}
SELECT M.DateTime, M.AvgNumericData as "writes per second", N.Caption as "MultiData"
FROM APM_MultiValueReportsData M WITH(NOLOCK)
JOIN APM_Component C
on C.ID = M.ComponentID
JOIN APM_Application A
on A.ID = C.ApplicationID
JOIN Nodes N
on N.NodeID = A.NodeID
WHERE C.Name like 'DISK%' and M.Name in ('writepers') AND M.DateTime between @startDate AND @endDate
The output is as follows,
I then proceed to setup the resource,
The following graph is displayed,
The time in the graph is incorrect, as the time of screenshot is "Screen Shot 2014-05-21 at 7.34.08 PM"
Am i missing something in the SQL statement?
SAM version 6.1, NPM 10.7
Regards,
Danie
Hello,
Could you please try use
DECLARE @endDate DateTime = ${toTimeUTC}
DECLARE @startDate DateTime = ${fromTimeUTC}
SAM use UTC times in tables.
Incorrect zoomrange is tracked internally: 333502
Thanks lada
I've updated the SQL to UTC, but still am seeing incorrect times,
Screen Shot 2014-05-23 at 14.11.22 PM
