Matt,
The problem regarding Starttime and Endtime column in SNMPCollectData table
is solved in NetView 5.1. They are now kept "DateTime" format.
I also had been struggled with using C routine (ctime() and localtime()) to
accomplish
the same the objective without luck. Your formula is a good approach.
Ek C., IBM THAILAND Co.,Ltd.
Matt Moore wrote:
> Hi,
>
> the formula we use to convert the netview 5.0 for NT date format to the
> windows date format is:
>
> ([SnmpcollectData]![endTime]+2209161600)/(24*60*60)+0.5
>
> Note:
> 2209161600 = number of second between the windows 'zero' date (1/1/1900
> 12 AM) and the netview 'zero' date (1/1/1970 12 AM) -- (d/m/yy)
> (24*60*60) = number of seconds in a day
> 0.5 = 12 hours (in windows date format) because NZ is 12 hrs ahead of
> GMT
>
> Regards,
>
> Matt Moore
>
> >-----Original Message-----
> >From: Ken Ho [SMTP:KenH@dex.co.za]
> >Sent: Wednesday, September 16, 1998 10:05 PM
> >To: Matt Moore
> >Subject: FW: Corruption of default & map formula for date and time (??
> >time
> >zone based??)
> >
> >could you please help in regards to the formula, that you had sent to
> >dsparg.
> >
> >is it time zone based
> >
> >-----Original Message-----
> >From: Debbie Sparg [mailto:dsparg@fgh.co.za]
> >Sent: Wednesday, September 16, 1998 11:22
> >To: 'Ken Ho'
> >Subject: RE: Corruption of default map
> >
> >
> >
> >Hi Ken,
> >
> >Sorry, I don't believe it is possible to restore the default map from
> >the other copies. Unless you have a backup of the default to restore
> >from I think the only other option is to clear the databases and start
> >discovery from the beginning.
> >NetView 5.1 is available now and you should be receiving that soon,
> >maybe it will resolve this problem of the map getting corrupted. Backups
> >are important however,you should get them in place as soon as possible.
> >
> >The person who sent me the formula for the date and time is Neal
> >Wallace. He works for a Business Partner in New Zealand. His email
> >address is: NealW@datacom.co.nz
> >He told me he would be moving out of the NetView arena but I'm sure he
> >will still help you if he can. I also think that the problem of the date
> >being a day out is something to do with time zones as New Zealand would
> >be approximately 13 hours ahead of us.
> >The value of the date field is the number of seconds from the 01/01/1970
> >up to the current time when the record was written.
> >
> >Regards
> >Debbie
> >
> >>-----Original Message-----
> >>From: Ken Ho [SMTP:KenH@dex.co.za]
> >>Sent: Wednesday, September 16, 1998 10:48 AM
> >>To: Debbie Sparg
> >>Cc: Juri Busek
> >>Subject: Corruption of default map
> >>
> >>Debbie.
> >>
> >>
> >>Tivolli has once again corrupted the default map.
> >>
> >>
> >>Is there a way that the map can be restored from the other copies of
> >the
> >>maps?
> >>
> >>Also
> >>
> >>With regards to the date and time formula. Is it possible for you to
> >>email the person from which you got the formula
> >>as to the details about the formula, specifically in regards with
> >>whether they are using it in a time zone scenario, which could explain
> >>the incorrect date and possibly the time shown.
>
|