wrong time displayed by unmanaged devices (reportwriter)

After entering the maintenance time of a device/interface the time is displayed in field 'Planned Maintenance Window'

When running a report (reportwriter) to show devices/interface which are in maintenance the time is wrong (offset ? timezone)

How can I change this?

Find more posts tagged with

Unmanaged

local_time

Unmanage

Accepted answers

All comments

superfly

I have noticed the same thing. The clock is displaying GMT and not the local timezone. Surely there must be a SQL command that set the timezone to local. But I don't know SQL at all. Hopefully an expert in SQL will chime in.

wknaap

Searching thwack and combining the information I made report using the reportwriter.

################################################################

select

Nodes.NodeID,

NULL InterfaceID, Nodes.Caption as NodeName, Nodes.IP_Address as IP_Address, null InterfaceName,

DateAdd(MINUTE,DATEDIFF(MINUTE,GETUTCDATE(),GETDATE()),Nodes.UnmanageFrom) as UnmanageFromLocal,

DateAdd(MINUTE,DATEDIFF(MINUTE,GETUTCDATE(),GETDATE()),Nodes.UnmanageUntil) as UnmanageUntilLocal

from Nodes where UNMANAGEuntil > (getdate()) or Nodes.Unmanaged = 1

union

select

Interfaces.NodeID, Interfaces.InterfaceID, Nodes.Caption as NodeName, Nodes.IP_Address as IP_Address,

Interfaces.InterfaceName as InterfaceName,

DateAdd(MINUTE,DATEDIFF(MINUTE,GETUTCDATE(),GETDATE()),Interfaces.UnManageFrom) as UnManageFrom,

DateAdd(MINUTE,DATEDIFF(MINUTE,GETUTCDATE(),GETDATE()),Interfaces.UnManageUntil) as UnManageUntil

from Interfaces join Nodes

on Interfaces.NodeID = Nodes.NodeID

where interfaces.unmanageuntil > (Getdate()) or Interfaces.UnManaged = 1 and Nodes.Unmanaged ! = 1

order by 2 asc -- interface

#################################################################