Run Report'++LotusScript Development Environment:2:5:(Options):0:74
Use "reportlib"
'++LotusScript Development Environment:2:5:(Forward):0:1
Declare Sub Click(Source As Button)
'++LotusScript Development Environment:2:5:(Declarations):0:2
'++LotusScript Development Environment:2:2:BindEvents:1:129
Private Sub BindEvents(Byval Objectname_ As String)
Static Source As BUTTON
Set Source = Bind(Objectname_)
On Event Click From Source Call Click
End Sub
'++LotusScript Development Environment:2:2:Click:1:12
Sub Click(Source As Button)
Call RunReport()
End Sub
Categori_ze
_Edit Document
Send Docu_ment
_Forward
_Move To Folder...
_Remove From Folder2
Run Report,
faReport
0S0E
By Dateu*
vaDate
0S0E
By UserS*
vaUser
0S0E
By Type
vaType
0S0E
Dailyv,
vaDaily
0S0E
Weekly,
vaWeekly
0S0E
Monthlya.
vaMonthly
0S0E
Run Report'++LotusScript Development Environment:2:5:(Options):0:74
Use "reportlib"
'++LotusScript Development Environment:2:5:(Forward):0:1
Declare Sub Click(Source As Button)
'++LotusScript Development Environment:2:5:(Declarations):0:2
'++LotusScript Development Environment:2:2:BindEvents:1:129
Private Sub BindEvents(Byval Objectname_ As String)
Static Source As BUTTON
Set Source = Bind(Objectname_)
On Event Click From Source Call Click
End Sub
'++LotusScript Development Environment:2:2:Click:1:12
Sub Click(Source As Button)
Call RunReport()
End Sub
Categori_zem
_Edit Document
Send Docu_ment
_Forward
_Move To Folder...
_Remove From Folder
Run Report,
faReport
0S0E
By Date
vaDate
0S0E
By User
vaUser
0S0E
By Typeo*
vaType
0S0E
Daily0,
vaDaily
0S0E
Weekly,
vaWeekly
0S0E
Monthly
vaMonthly
0S0E
Lotus Product
OBJECT
O=Lotus Notes
O=Lotus Notes
PURSAFO
|.:#U
O=Lotus Notes
CN=Lotus Notes Template Development/O=Lotus Notes
PURSAFO
:T5pu
$AntiFolderIDTable
$TITLE
$PublicAccess
$Index
$Formula
$FormulaClass
$ViewFormat
$Comment
$WebFlags
$V5ACTIONS
$ACTIONS
$SCRIPTOBJ_0
Times New Roman
&Arial
Using Reports
?_?__
`!b`1
7`^///?
?b___
`bOOO
`<b!R
This database is provided so you can easily generate and store reports about messaging usage on a Domino server. You can create a new report or view the contents of previously run reports.
Creating new reports
To create a report, click
EventsCN
. Fill out the form that is displayed and click the OK button. The form has the following fields:
Report Type
highlight
the report you wish to run
Created by
will be filled in with your name
Created at
will be filled in with the current local date and time
Created on server
will be filled in with the name of the server the report refers to; i.e. where the reports database is stored
Description
optionally enter
text that identifies the report; this may be useful for writing your own agents later
Time range
highlight
the time interval you want the report to cover
Execution interval
highlight
how frequently you want to run the report
Earliest message found
will be filled in with the date and time of the earliest message found when the report is run
Latest message found
will be filled in with the date and time of the last message found when the report is run
Report results should be
highlight
the results output option you want
You can also choose to enter additional constraints for the report. In particular:
Sender's name
highlight
the match criterion you want to use and
enter
the string to match against
Recipient's name
highlight
the match criterion you want to use and
enter
the string to match against
Delivery status
highlight
the operator you want to use and
select
the status to use
Message size
highlight
the size comparison you want to use and
enter
the target size (in kilobytes)
If you choose an execution interval of
Once
, the report will be run immediately and the results either displayed on your workstation or mailed to the mailboxes you specified. If you choose an execution interval of
Daily
Weekly
Monthly
, the report request will be added to the appropriate folder and run the next time the agent for daily, weekly or monthly reports executes. If you specify a report to be mailed to a mailbox, it will
not
be saved in this database.
Viewing Existing Reports
There are four views provided with this database. The views allow you to view the results of previously executed reports.
Date View
Displays reports sorted by the date they were created.
Schedule View
Displays reports sorted by the schedule they were to be executed on (once, daily, weekly, monthly).
Type View
Displays reports sorted by the type of report (top 25 users, top 25 senders etc).
User View
Displays reports sorted by the name of the person who created them.
Scheduled Reports
To schedule a report to run at a later time, follow the instructions for creating a report above and select the desired value in the
Execution Interval
field. When you click the OK button, the report document will be added to the appropriate schedule folder. There are separate folders for daily, weekly and monthly reports. You can display the folders by clicking the Scheduled Reports twisty in the view pane of this database.
To modify the schedule of the report agents, right-click on the reports database icon on your workspace. Then select the
Go To Agents
menu choice. Double-click on the agent you want to modify. This will open the standard Notes agent dialog. You can click on the Schedule button and modify when the agent executes.
Scheduled reports can be
enabled
and
disabled
on an individual basis. This is accomplished via
action buttons
that are present when editing the document. A scheduled report that is disabled will remain disabled until it is manually re-enabled.
Getting more information
This is just a brief summary of the features you may want to use in the Reports database. For additional information,
'++LotusScript Development Environment:2:5:(Options):0:66
'++LotusScript Development Environment:2:5:(Forward):0:1
Declare Sub Click(Source As Button)
'++LotusScript Development Environment:2:5:(Declarations):0:2
'++LotusScript Development Environment:2:2:BindEvents:1:129
Private Sub BindEvents(Byval Objectname_ As String)
Static Source As BUTTON
Set Source = Bind(Objectname_)
On Event Click From Source Call Click
End Sub
'++LotusScript Development Environment:2:2:Click:1:12
Msgbox "Unable to locate the Notes Help Database", 16, "Error"
End If
End Sub
click the following Help icon:
60606
@ @@ @` @
@@ @@@@@`@@
`@ `@@`@``@
O=Lotus Notes
O=Lotus Notes
PURSAFO
|.:#U
O=Lotus Notes
CN=Lotus Notes Template Development/O=Lotus Notes
PURSAFO
$Info
$Body
Times New Roman
&Arial
About Reports
?_?__
`!b`1
7`^///?
?b___
`bOOO
`<b!R
Welcome to the Reports database. The Reports database allows you to analyze mail usage on this server directly from your Notes workstation. With this database, you can create reports on such information as top mail users, message volume over time, and routing patterns. These reports can be executed immediately or on a scheduled basis. The results can be saved in this database or mailed to one or more mailboxes. You can also view the results of previously executed reports, from one of several views.
Agents stored in this database control the execution of the reports. There is a separate agent for each of the schedule options: one-time, daily, weekly, and monthly.
Choose "Using This Database" from the Help menu for information on using this database.
-------------------
(Close this window to return to the database.)
O=Lotus Notes
O=Lotus Notes
PURSAFO
|.:#U
O=Lotus Notes
CN=Lotus Notes Template Development/O=Lotus Notes
PURSAFO
$Info
$Body
O=Lotus Notes
O=Lotus Notes
PURSAFO
|.:#U
O=Lotus Notes
CN=Lotus Notes Template Development/O=Lotus Notes
PURSAFO
$TITLE
$Flags
$PublicAccess
'++LotusScript Development Environment:2:5:(Options):0:66
Option Public
'++LotusScript Development Environment:2:5:(Forward):0:1
Declare Sub RunReport
Declare Function GetString(StringType)
Declare Function shouldContinue
'++LotusScript Development Environment:2:5:(Declarations):0:2
'++LotusScript Development Environment:2:2:RunReport:1:8
Sub RunReport
Dim aSession As New NotesSession
Dim aWorkspace As New NotesUIWorkspace
Dim aDb As NotesDatabase
Set aDb = aSession.CurrentDatabase
Dim aDoc As New NotesDocument( aDb )
Call aDoc.ReplaceItemValue("Form","faReport")
Call aDoc.Save(True,False)
If Not aWorkspace.DialogBox( "faReport", True, True, False, False, False, False, GetString(1), aDoc ) Then Exit Sub
faReport'++LotusScript Development Environment:2:5:(Options):0:74
Use "reportlib"
'++LotusScript Development Environment:2:5:(Forward):0:1
Declare Sub Queryclose(Source As Notesuidocument, Continue As Variant)
'++LotusScript Development Environment:2:5:(Declarations):0:2
'++LotusScript Development Environment:2:2:BindEvents:1:129
Private Sub BindEvents(Byval Objectname_ As String)
Static Source As NOTESUIDOCUMENT
Set Source = Bind(Objectname_)
On Event Queryclose From Source Call Queryclose
End Sub
'++LotusScript Development Environment:2:2:Queryclose:1:12
Sub Queryclose(Source As Notesuidocument, Continue As Variant)
If (Source.Document.ResultDisposition(0) = "ka_Mailed" And Source.Document.Type(0) = "ka_Request" And Source.Document.CheckedDisposition(0)= 0) Then
Continue = shouldContinue
End If
End Sub
Lotus Product
OBJECT
Top 25 Users By Count
ReportType
Top 25 Users By Count
ReportType
Top 25 Users By Size
ReportType
Top 25 Senders By Count
ReportType
Top 25 Senders By Size
ReportType
Top 25 Receivers By Count
ReportType
Top 25 Receivers By Size
ReportType
Top 25 Most Popular Next Hops
ReportType
Top 25 Most Popular Previous Hops
ReportType
Top 25 Largest Messages
ReportType
Message Volume Summary
ReportType
Message Status Summary
Invalid Report Type
ReportTypeNamez
ReportTypeName
Request
Request | ka_RequestResponse | ka_Responsez
ReportRequestID
ReportRequestID
ReportDates
ReportDates
ka_No
Disabled
Yes | ka_YesNo | ka_Noz
Disabled
CheckedDispositionz
CheckedDisposition
$$Returnz
$$Return
.,$///:
Server_Name
Server_Name
.,$///:
Server_Port
SaveOptions
SaveOptions
hidden
Report Type:
Top 25 Users By Count
ReportType
Top 25 Users By Count | 1Top 25 Users By Size | 2Top 25 Senders By Count | 3Top 25 Senders By Size | 4Top 25 Receivers By Count | 5Top 25 Receivers By Size | 6Top 25 Most Popular "Next Hops" | 7Top 25 Most Popular "Previous Hops" | 8Top 25 Largest Messages | 10Message Volume Summary | 11Message Status Summary | 12
ReportType
Created by:
0S0E
Creator
Creator
Created at:
0S0E
ReportTimez
ReportTime
Created on server:
TempName
1S2S
TempName
Local
TempName
ReportServerz
ReportServer
Description:
ReportDescription
ReportDescription
Time Range:
Over the last week
TimeRange
Today | TYesterday | YOver the last week | LWOver the last two weeks | L2WOver the last month | LMAll available information | ALLz
TimeRange
Execution Interval:
ReportGenInterval
Once | ka_OnceDaily | ka_DailyWeekly | ka_WeeklyMonthly | ka_Monthly
ReportGenInterval
Earliest Message Found:
FirstEntryTimedatez
FirstEntryTimedate
Latest Message Found:
LastEntryTimedate
LastEntryTimedate
Report results should be:
Saved
ResultDisposition
ka_Request
Saved|ka_Saved
ReportServer
Local
ReportServerV
Mailed|ka_Mailed
Saved & Mailed|ka_saved_mailed
Saved|ka_Saved
Mailed|ka_Mailed
Saved & Mailed|ka_saved_mailed
0S0E
ResultDisposition
ResultDisposition
Saved
ResultDisposition
ka_Saved
3S4S
Mail Recipient:
ResultDisposition
Saved
ResultDisposition
ka_Saved
3S4S
Creator
MailRecipient
MailRecipient
Special Conditions:
UseSenderName
Sender's Namez
UseSenderName
Contains
QualifySenderName
Contains | CExactly Matches | EM
QualifySenderName
SenderNameTextz
SenderNameText
UseRecipName
Recipient's Namez
UseRecipName
Contains
QualifyRecipName
Contains | CExactly Matches | EMz
QualifyRecipName
RecipNameText
RecipNameText
UseDeliveryStatus
Delivery Statusz
UseDeliveryStatus
QualifyDeliveryStatus
Is | ISIs Not | NOTz
QualifyDeliveryStatus
Delivered
DeliveryStatus
Delivered | DNot Delivered | NDBeing Processed | BP
(.txt)