[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference azur::mcc

Title:DECmcc user notes file. Does not replace IPMT.
Notice:Use IPMT for problems. Newsletter location in note 6187
Moderator:TAEC::BEROUD
Created:Mon Aug 21 1989
Last Modified:Wed Jun 04 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:6497
Total number of notes:27359

5614.0. "Home Grown Reports" by GLDOA::KATZ (Follow your conscience) Wed Sep 22 1993 13:51

    Anyone creating reports without the canned reports generator?
    I'm looking for another way to create reports and would like
    your input. Thanks.
    
    		-Jim-
T.RTitleUserPersonal
Name		DateLines
5614.1Excel & DECdecisionGRANMA::JPARKERThu Sep 23 1993 00:3128
    Hi,
    
    I'm using MS-Excel to generate graphs and MS-Word to do periodic report
    files containing the graphs. I do-
    
     show snmp * all statistics, in domain mmacs, to file=foo.bar
     show snmp * interface 1 (or 2) all stat...
     show translan * line * all count to file=...
    
    to get the data out of the MIR & NFT, FTP the files to a PC.
    
    A quick low-level Visual Basic program reformats these to text files 
    that Excel can import into a sheet. Then select data areas and push the 
    Graph button...
    
    This VB program is specific to two current projects I'm doing and not at 
    all generic. I process data for 33 Cabletron mmacs on a campus-wide LAN 
    and 9 Translans for a WAN customer so the volume of data is generally low.
     
    The 'what-if' capability is hard to beat. And doing this on my
    Laptop as well as at home on the PC has been very time-efficient.
    
    I've also used DECmcc/VMS and DECwrite/DECdecision to do essentially
    the same. It was nice to open a DECwrite document and 'live-link'
    exported data into a report format/template 'while-u-watch'.
    
    Jeff.
5614.2RECORD and dclCTHQ::WOODCOCKThu Sep 23 1993 10:0211
    
>     show snmp * all statistics, in domain mmacs, to file=foo.bar
>     show snmp * interface 1 (or 2) all stat...
>     show translan * line * all count to file=...
    
We also use similar techniques with use of MIR (from RECORD) files. EXPORT
is too resource intensive for us. After the data is in text, dcl is used to
reformat and report.

best regards,
brad...
5614.3Record and CBERN01::GMUERFri Sep 24 1993 09:156
We are using RECORD, SHOW in the past and a C program to parse the ASCII
files. In C you can use 64bit floating point numbers to compute statistics
on 48bit counters. Such counters are needed in the DECnis management.

Edgar