Debbie, I am particularly interested in any answers you may have
received for question 7. The company I work for has not found any such
thing and so has started to produce our own reports. The design of these
reports (so far just daily and weekly graphs) has taken a very long time
and so would be very interested in any such samples.
In relation to your other questions below, (3) - the database I believe
just wraps around - drops old data (writes it to the trapd.log if
specified in the trap drop down box of Server Setup) and fills it with
the new data. There is also an option (be warned: it is the default!) in
the Files page, Schedule SNMPCollect Data to Delete drop down option to
'Purge Every Day at 11:00:00 PM', 'Number of Records to Leave in
Database 0'. This will delete all of your precious data - I suspect you
are in a similar position to us, so change this very quickly!
In regards to (6), I believe there is a way of doing this, but
unfortunately I haven't learned how to yet - I suspect it may be a
function of the Tivoli Desktop or similar tool.
The other questions I do not think I could help with as I have been
involved more on the installation and maintenance sides rather than the
day-to-day usage side.
Datacom Network Services
PO Box 6041
160 Grafton Road
Phone +64 9 356 4080
Fax +64 9 303 0317
Email NealW AT Datacom.co DOT nz
>From: Debbie Sparg [SMTP:dsparg AT FGH.CO DOT ZA]
>Sent: Tuesday, August 18, 1998 4:21 AM
>To: NV-L AT UCSBVM.UCSB DOT EDU
>Subject: MORE QUESTIONS ON NETVIEW NT 5.0 REV A
>Please if anyone can help with the following questions/problems:
>1) Availability tracking: my customer wants reports of up/down time for
>nodes which seems to be what is provided by the availability feature in the
>Object Properties windows. This is always blank for any node I choose. What
>do I have to do to get availability statistics ? I am logging events to both
>trapd.log (flat file) and to the SQL database. We are using MS SQL Server
>6.5. I have also tried using uptimer.exe but don't what parameters to provide
>2) Events: As previously mentioned I am logging events to both trapd.log
>and the SQL database. What is each used for ? Is there a purpose for logging
>to both ?
>3) Events database: Is this used only for current events ? I need an
>explanation for the maximum events and no. events to refresh display. The
>notes say that when maximum events are reached the database is cleared - do
>they mean cleared of all events or does it wrap around ? What exactly is
>'refresh display' , it appears to me that the display refreshes each time a
>new event is received so I don't understand what this parameter is meant to
>4) Events history: I cannot see any difference in the display when I
>used all events (current?) or history ? Are all the events from the SQL
>database available to be viewed online ? Is the maximum events parameter for
>all events in the database or for those events which can be viewed as
>'current events'. My events seem to be cleared out or maybe archived as I can
>only view events for the last couple of days and not since NetView was
>5) DHCP: My customer uses DHCP for WIN95 workstations. What is the
>advantage of customising the seed file to tell NetView which nodes are DHCP ?
>What are the advantages of keeping or not keeping the DHCP clients ? My
>customer has IP addresses reserved for 30 days.
>6) Is there a way in NT to automatically start data collection for
>specific time intervals ? (something like cron for Unix ?)
>7) Are there any sample SQL queries/reports to produce customised
>reports from the SNMPCOLLECT database ?
>(dsparg AT fgh.co DOT za)