Jeff,
You can refer to the help on the command line interface.
You can also see the Query in cststrpt.ini.
- Use Performance Graphs utility to configure a report job.
- Save the job.
- Open cstatrpt.ini.
You can even add additional SQL statements. Here is an example
in which I have inserted a time query:
[Hour]
ARGS=-lwugstatdata.tab -oascend -rwugstathour.rpt -s20020701 -e20021115 -z100
QUERY= {_.DEVICE} like ["wks*"] and {_.TIME} >= "0800" and {_.TIME} <= "1200"
Regards,
Joe
In reply to 9 Jul message from [EMAIL PROTECTED]:
>This message is in MIME format. Since your mail reader does not understand this
>format, some or all of this message may
>not be legible.
>------_=_NextPart_001_01C34624.C071DB40
>Content-Type: text/plain
>Oh, that will be cool. How are the From/To dates passed thru? What about a dynamic
>title for the month run?
>---------------------------------------------
>Jeff Benedict
>Tech Services
>Lan/Wan Support
>228-214-5465
>-----Original Message-----
>From: Joe Sepielli [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 8:39 AM
>To: [EMAIL PROTECTED]
>Subject: RE: [WhatsUp Forum] WUGSTATDATA.TAB file
>Jeff,
>FYI: You can place your custom report template (.rpt) files into the WhatsUp Gold
>directory and the Performance Graphs
>utility will list them as known Report Types?
>Joe
>In reply to 9 Jul message from [EMAIL PROTECTED]:
>>Joe,
>>Thanks for the insight. I was missing how the wugstatdata.tab file was
>>getting created. It all makes sense now. I inherited the roll of
>>producing monthly SLA reports and could not figure out how the
>>wugstatdata file was getting created. It is being used in a custom
>>Crystal Reports report. Now I know that I need to run a phony Stats
>>Report for the time period I need and then run my Crystal Report.
>>---------------------------------------------
>>Jeff Benedict
>>Tech Services
>>Lan/Wan Support
>>228-214-5465
>>-----Original Message-----
>>From: Joe Sepielli [mailto:[EMAIL PROTECTED] Sent: Tuesday, July
>>08, 2003 7:51 PM
>>To: [EMAIL PROTECTED]
>>Subject: Re: [WhatsUp Forum] WUGSTATDATA.TAB file
>>Jeff,
>>Every time a report is created by the Performance Reports utility
>>cstatrpt.exe Wugstatdata.tab is created. It is an aggregate of the
>>ST-YYYY-MM-DD.tab files per the date range provided to cstatrpt. It
>>remains after each report run, and is overwritten on subsequent report
>>job runs.
>>You could do the aggregation in a similar manner. How are you creating
>>your reports?
>>Regards,
>>Joe
>>In reply to 8 Jul message from [EMAIL PROTECTED]:
>>>I'm trying to get more info on the WUGSTATDATA.TAB file. When is it
>>>created, how can I re-create it. Does anyone run reports against it w/
>>>Crystal to get an overall picture of all their maps.
>>>
>>>How can I use the individual ST-YYYY-MM-DD.tab files to collectively
>>>create a report for an entire month?
>>>
>>>---------------------------------------------
>>>Jeff Benedict
>>>Hancock Bank
>>>Tech Services
>>>Lan/Wan Support
>>>228-214-5465
>>>
>>>It's not a matter of Having what you want,
>>>It's a matter of Wanting what you have!
>>>
>>Please visit http://www.ipswitch.com/support/mailing-lists.html to be
>removed from this list.
>>An Archive of this list is available at:
>>http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
>Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from
>this list.
>An Archive of this list is available at:
>http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
>------_=_NextPart_001_01C34624.C071DB40
>Content-Type: text/html
>Content-Transfer-Encoding: quoted-printable
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
><HTML>
><HEAD>
><META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii">
><META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2653.12">
><TITLE>RE: [WhatsUp Forum] WUGSTATDATA.TAB file</TITLE> </HEAD>
><BODY>
><P><FONT SIZE=3D2>Oh, that will be cool. How are the From/To = dates passed
>thru? What about a dynamic title
>for the month = run?</FONT>
></P>
><P><FONT SIZE=3D2>---------------------------------------------</FONT> <BR><FONT
>SIZE=3D2>Jeff Benedict</FONT>
><BR><FONT SIZE=3D2>Tech Services</FONT>
><BR><FONT SIZE=3D2>Lan/Wan Support</FONT>
><BR><FONT SIZE=3D2>228-214-5465</FONT>
></P>
><BR>
><P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Joe
>Sepielli [<A =
>HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</= A>] </FONT>
><BR><FONT SIZE=3D2>Sent: Wednesday, July 09, 2003 8:39 AM</FONT> <BR><FONT
>SIZE=3D2>To:
>[EMAIL PROTECTED]</FONT> <BR><FONT SIZE=3D2>Subject: RE: [WhatsUp Forum]
>WUGSTATDATA.TAB = file</FONT>
></P>
><BR>
><P><FONT SIZE=3D2>Jeff,</FONT>
></P>
><P><FONT SIZE=3D2>FYI: You can place your custom report template (.rpt) = files into
></FONT>
><BR><FONT SIZE=3D2>the WhatsUp Gold directory and the Performance = Graphs utility
>will list them as known Report Types?
></FONT> </P>
><P><FONT SIZE=3D2>Joe</FONT>
></P>
><P><FONT SIZE=3D2>In reply to 9 Jul message from = [EMAIL PROTECTED]:</FONT>
></P>
><BR>
><P><FONT SIZE=3D2>>Joe,</FONT>
><BR><FONT SIZE=3D2>>Thanks for the insight. I was missing how = the
>wugstatdata.tab file was </FONT>
><BR><FONT SIZE=3D2>>getting created. It all makes sense = now. I
>inherited the roll of </FONT>
><BR><FONT SIZE=3D2>>producing monthly SLA reports and could not = figure out how
>the </FONT>
><BR><FONT SIZE=3D2>>wugstatdata file was getting created. It = is being used
>in a custom </FONT>
><BR><FONT SIZE=3D2>>Crystal Reports report. Now I know that I = need to run
>a phony Stats </FONT>
><BR><FONT SIZE=3D2>>Report for the time period I need and then run = my Crystal
>Report.</FONT>
></P>
><P><FONT =
>SIZE=3D2>>---------------------------------------------</FONT> <BR><FONT
>SIZE=3D2>>Jeff Benedict</FONT>
><BR><FONT SIZE=3D2>>Tech Services</FONT>
><BR><FONT SIZE=3D2>>Lan/Wan Support</FONT>
><BR><FONT SIZE=3D2>>228-214-5465</FONT>
></P>
><BR>
><P><FONT SIZE=3D2>>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>>From:
>Joe Sepielli [<A =
>HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</= A>] Sent: Tuesday, July
></FONT>
><BR><FONT SIZE=3D2>>08, 2003 7:51 PM</FONT>
><BR><FONT SIZE=3D2>>To: [EMAIL PROTECTED]</FONT> <BR><FONT SIZE=3D2>>Subject:
>Re: [WhatsUp Forum]
>WUGSTATDATA.TAB = file</FONT>
></P>
><BR>
><P><FONT SIZE=3D2>>Jeff,</FONT>
></P>
><P><FONT SIZE=3D2>>Every time a report is created by the Performance = Reports
>utility </FONT>
><BR><FONT SIZE=3D2>>cstatrpt.exe Wugstatdata.tab is created. It is = an aggregate
>of the </FONT>
><BR><FONT SIZE=3D2>>ST-YYYY-MM-DD.tab files per the date range = provided to
>cstatrpt. It </FONT>
><BR><FONT SIZE=3D2>>remains after each report run, and is = overwritten on
>subsequent report </FONT>
><BR><FONT SIZE=3D2>>job runs.</FONT>
></P>
><P><FONT SIZE=3D2>>You could do the aggregation in a similar manner. = How are you
>creating </FONT>
><BR><FONT SIZE=3D2>>your reports?</FONT>
></P>
><P><FONT SIZE=3D2>>Regards,</FONT>
></P>
><P><FONT SIZE=3D2>>Joe</FONT>
></P>
><P><FONT SIZE=3D2>>In reply to 8 Jul message from = [EMAIL PROTECTED]:</FONT>
></P>
><BR>
><P><FONT SIZE=3D2>>>I'm trying to get more info on the = WUGSTATDATA.TAB
>file. When is it </FONT>
><BR><FONT SIZE=3D2>>>created, how can I re-create it. Does = anyone run
>reports against it w/ </FONT>
><BR><FONT SIZE=3D2>>>Crystal to get an overall picture of all = their
>maps.</FONT>
><BR><FONT SIZE=3D2>>> </FONT>
><BR><FONT SIZE=3D2>>>How can I use the individual = ST-YYYY-MM-DD.tab files to
>collectively </FONT>
><BR><FONT SIZE=3D2>>>create a report for an entire month?</FONT> <BR><FONT
>SIZE=3D2>>> </FONT>
><BR><FONT =
>SIZE=3D2>>>---------------------------------------------</FONT> <BR><FONT
>SIZE=3D2>>>Jeff Benedict</FONT>
><BR><FONT SIZE=3D2>>>Hancock Bank</FONT>
><BR><FONT SIZE=3D2>>>Tech Services</FONT>
><BR><FONT SIZE=3D2>>>Lan/Wan Support</FONT>
><BR><FONT SIZE=3D2>>>228-214-5465</FONT>
><BR><FONT SIZE=3D2>>> </FONT>
><BR><FONT SIZE=3D2>>>It's not a matter of Having what you = want,</FONT>
><BR><FONT SIZE=3D2>>>It's a matter of Wanting what you = have!</FONT>
><BR><FONT SIZE=3D2>>> </FONT>
></P>
><BR>
><BR>
><BR>
><P><FONT SIZE=3D2>>Please visit <A =
>HREF=3D"http://www.ipswitch.com/support/mailing-lists.html"; =
>TARGET=3D"_blank">http://www.ipswitch.com/support/mailing-lists.html</A>=
> to be removed from this list.</FONT>
></P>
><P><FONT SIZE=3D2>>An Archive of this list is available at:</FONT> <BR><FONT
>SIZE=3D2>><A =
>HREF=3D"http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/"; =
>TARGET=3D"_blank">http://www.mail-archive.com/whatsup_forum%40list.ipswi=
>tch.com/</A> </FONT>
></P>
><BR>
><BR>
><BR>
><P><FONT SIZE=3D2>Please visit <A =
>HREF=3D"http://www.ipswitch.com/support/mailing-lists.html"; =
>TARGET=3D"_blank">http://www.ipswitch.com/support/mailing-lists.html</A>=
> </FONT>
><BR><FONT SIZE=3D2>to be removed from this list.</FONT> </P>
><P><FONT SIZE=3D2>An Archive of this list is available at:</FONT> <BR><FONT
>SIZE=3D2><A =
>HREF=3D"http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/"; =
>TARGET=3D"_blank">http://www.mail-archive.com/whatsup_forum%40list.ipswi=
>tch.com/</A></FONT>
></P>
></BODY>
></HTML>
>------_=_NextPart_001_01C34624.C071DB40--
>Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from
>this list.
>An Archive of this list is available at:
>http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
