This setting allows you to control how soon events marked for
deletion are actually removed from the system, and limits the
number of records in the database. . Specifically it means that
events marked with a 'Deleted' status for longer than the threshold
should be purged from the system. The default threshold value is 24
hours.
Open Internet Explorer to Advisor
Open
'Tools' menu
Select the
'Options...' menu item
Select the 'Data' tab
In the 'Delete events with a 'Deleted' status more than
N hours' field, set N to the maximum number of hours that an event
can be marked as 'Deleted' before it is deleted.
This setting allows you to control how soon events marked as 'By
Design' are actually removed from the system, and limits the number
of records in the database. . Specifically it means that events
marked with a 'By Design' status for longer than the threshold
should be purged from the system. The default threshold value is 72
hours.
Open Internet Explorer to Advisor
Open
'Tools' menu
Select the
'Options...' menu item
Select the 'Data' tab
In the 'Delete events with a 'Deleted' status more than
N hours' field, set N to the maximum number of hours that an event
can be marked as 'Deleted' before it is deleted.
Advisor leverages Intercept Studio security, i.e. it uses the
same value for the restricted mode option as in SE-Viewer (if you
change this option in SE-Viewer it will be changed in Advisor and
vice versa), and has the same users as in SE-Viewer (the user list
can only be managed via SE-Viewer). Only administrators can access
Advisor.
Advisor application leverages Intercept Studio security
model.
There are two types of Intercept Studio users: Administrators
and normal users. Administrators have access to all Advisor
functionality. Normal users don’t have access to Advisor
application.
Four (4) security modes for the Advisor web site are supported:
Anonymous, Basic, Integrated and Custom.
Anonymous windows authentication set on Advisor in IIS without
any Custom Advisor authentication will allow any user with access
to Advisor to use all functionality.
The other 3 authentication methods will allow you to restrict
user access. For Custom Advisor authentication, the Windows
authentication remains as Anonymous, and Advisor uses user names
from the SE-Viewer database. For Windows Basic and Integrated
authentication, Advisor uses windows domain accounts that have to
be also stored in SE-Viewer database with names in format
[Domainname]\username..
To enable Advisor security, you must first enable Anonymous,
Basic (with Anonymous disabled) or Integrated (with Anonymous
access disabled) authentication for Advisor in IIS.
Anonymous Authentication Mode: Enabling Anonymous Authentication
in IIS will allow all users to access Advisor as long as the
'Restricted' checkbox is not checked on this 'Security Mode'
tab.
Basic Authentication mode: Enabling Basic Authentication in IIS
will allow only administrators added through the Users tab in
SE-Viewer to use Advisor when the 'Restricted' checkbox is checked
on this 'Security Mode' tab.
Integrated Authentication mode: Enabling Integrated
Authentication in IIS will allow only administrators added through
the Users tab in SE-Viewer to use Advisor when the 'Restricted'
checkbox is checked on this 'Security Mode' tab.
Custom Authentication mode: Enabling Anonymous Authentication in
IIS and checking the 'Restricted' checkbox on this 'Security Mode'
tab enables Custom Authentication, whereby only administrators
added through the Users tab in SE-Viewer will have access to
Advisor. By default, there is an authentication timeout for custom
authentication sessions that are longer than 30 minutes. See the
section on Advanced Configuration for instructions to change this
default.
Advisor is installed without any predefined users but it
leverages list of users from SE-Viewer and restricted mode value
itself. If user switches on restricted mode via Advisor, he should
specify administrative account and its password in Options dialog.
Be aware that switching on restricted mode via Advisor will also
switch on restricted mode in SE-Viewer with the same
administrator.
However, it is recommended to use only SE-Viewer for user
management.
Select the 'Security mode' checkbox, which will cause the
'Administrator login name' and 'Password' fields to appear
Enter the administrator login name in the field provided. If
you plan to use Windows authentication for the SE-Viewer web site,
you must use a valid network user name ([Domainname]\[UserName]) for the administrator
login.
Enter the administrator password
Confirm the administrator password >
Enabling
restricted security for Advisor on this tab when the Advisor
web site is set for Basic, Integrated or Custom authentication
modes in IIS will redirect you to log in using a valid user
account. Once you are logged in, a new field will appear in the
upper right-hand portion of the header bar that displays the user
name and provides a button () so that you can log out.
Intercept Reporting Services synchronizes the addition, but not
the deletion, of application groups between SE-Viewer and the
Reporting databases. Therefore the "Remove Application Groups"
wizard must be used to remove Application Groups from the Advisor
database. The wizard only deletes Application Groups and does not
delete events or performance counters from the reporting
database.The ‘All’ application group cannot be delete.
Open Internet Explorer to Advisor
Open the 'Tools' menu
Select the 'Remove
Application Groups wizard...' menu item
Click Next
Select from the list of available application groups.
Click Next
If you are sure that you want to delete the application group
that you selected on the previous screen, click Next
Click Finish
Schedule Management
Schedule management allows users to subscribe to a specified
report and create schedule for it. The user will receive the report
by email according to this schedule, and in the format selected by
user. The schedule can be temporary deactivated or deleted, and
users can modify any schedule.
The following conditions must be met in order to use the
scheduler and to ensure the correct email delivery of reports:
You must specify a user account that has
permission to send mail from the SMTP server under
StartAll ProgramsMicrosoft SQL Server xxxConfiguration ToolsReporting Services
Configuration Manager.exe.
The SQL Server Agent must be started
An external (not containing localhost or
127.0.0.1) address must be set for the Advisor Console Address
under
ToolsOptionsDataAdvisor Console Address
Advisor must be running with Microsoft SQL
Server and not with SQL Express
The instructions below all open the Schedule
wizard from the tools menu. The Schedule wizard may also be
accessed via the option on the toolbar when a report has
been run. Note that when the scheduler is selected from the toolbar
when a report has been run, that the wizard will assume the
scheduler is running for the selected report and will skip over the
report selection screen.
Create a new schedule
Open Internet Explorer to Advisor
Open the 'Tools' menu
Select the 'Schedule wizard...' menu item
Select the 'Create new' option
Click Next
Select the report to schedule. Reports are listed under the
standard categories of problem analysis reports, resource
utilization analysis, etc. This screen will be skipped if the user
has called the wizard from the toolbar.
Click Next
Select the report settings for events to be included in the
report. Some of parameters are dependent and can be selected
after selection of primary parameter. For example, user can select
arbitrary value of the "Group By" parameter only if he selects
appropriate "Period":
Start Date: The start date may be set (using the 'Absolute'
radio button) to an exact start date using the calendar selection
tool, or the start date may be set (using the 'Relative' radio
button) to a relative start date of Today, Yesterday, This Month:
First Day, This Month: Last Day, This Week: First Day, This week:
Last Day, Previous Month: First Day, Previous Month: Last Day,
Previous Week: First Day, or Previous Week: Last Day
End Date: The end date may be set (using the 'Absolute' radio
button) to an exact end date using the calendar selection tool, or
the end date may be set (using the 'Relative' radio button) to a
relative end date of Today, Yesterday, This Month: First Day, This
Month: Last Day, This Week: First Day, This week: Last Day,
Previous Month: First Day, Previous Month: Last Day, Previous Week:
First Day, or Previous Week: Last Day
Source: The name of the web application(s) from which the
events were received. Note that the 'Source' and 'Computer'
parameters are filtered by Application groups
Computer: The name of the computer(s) from which the events
were received. Note that the 'Source' and 'Computer'
parameters are filtered by Application groups
Application Count: The maximum count of applications thereport
will be created for. For example, if the Application Count = 5,
data from only 5 sources will be available
Click Next
Select the delivery settings:
Method: Email
Name: The name of the selected report, or modify to use a
custom name
E-mail addresses: List the email addresses of all recipients.
Separate addresses with a semi-colon (;)
Format: XML, CSV, TIFF, PDF, Web-archive or Excel
Active: Select the checkbox to make this schedule active, or
deselect to deactivate the schedule
Click Next
Create the schedule to run and deliver the report:
Method:
Once: Report will be received only one time, selected by the
user.
Hourly: Report will be received with the selected time interval
(should be at least 1 minute), beginning at the time selected in
the ‘Time’ property
Daily / Weekly: Report will be received once a day at the
selected time. User can choose the “Every workday” option or select
one or more days from a list.
Monthly: The user should first select months from the list.
After that, he should choose one of 2 options:
On Week of the month: The user should choose a week (First,
Second, Third, Fourth, Last) and day(s) of week, which will set the
days of the month when the report will be received.
In days: The user should directly enter dates (separated by a
comma if more than one is selected) when he want receive
report.
Execute: Select the 'Choose day' checkbox and one or more days
of the week to run and send the report, or 'Every workday' to
run and send the report.
Time: Select the time of day to run and send the report. Note
that this is a 24-hour clock.
Click Next
Confirm the selected options, then click Back to make corrections or click Next
Click Finish
Modify a schedule
Open Internet Explorer to Advisor
Open the 'Tools' menu
Select the 'Schedule wizard...' menu item
Select the 'Modify' option
Click Next
Select the report settings for events to be included in the
report. Some of parameters are dependent and can be selected
after selection of primary parameter. For example, user can select
computers only if he selects an application. :
Start Date: The start date may be set (using the 'Absolute'
radio button) to an exact start date using the calendar selection
tool, or the start date may be set (using the 'Relative' radio
button) to a relative start date of Today, Yesterday, This Month:
First Day, This Month: Last Day, This Week: First Day, This week:
Last Day, Previous Month: First Day, Previous Month: Last Day,
Previous Week: First Day, or Previous Week: Last Day
End Date: The end date may be set (using the 'Absolute' radio
button) to an exact end date using the calendar selection tool, or
the end date may be set (using the 'Relative' radio button) to a
relative end date of Today, Yesterday, This Month: First Day, This
Month: Last Day, This Week: First Day, This week: Last Day,
Previous Month: First Day, Previous Month: Last Day, Previous Week:
First Day, or Previous Week: Last Day
Source: The name of the web application(s) from which the
events were received. Note that the 'Source' and 'Computer'
parameters are filtered by Application groups
Computer: The name of the computer(s) from which the events
were received. Note that the 'Source' and 'Computer'
parameters are filtered by Application groups
Application Count: The maximum count of applications the report
will be created for. For example, if the Application Count = 5,
data from only 5 sources will be available
Click Next
Select the delivery settings:
Method: Email
Name: The name of the selected report, or modify to use a
custom name
E-mail addresses: List the email addresses of all recipients.
Separate addresses with a semi-colon (;)
Format: XML, CSV, TIFF, PDF, Web-archive or Excel
Active: Select the checkbox to make this schedule active, or
deselect to deactivate the schedule
Click Next
Create the schedule to run and deliver the report:
Method:
Once: Report will be received only one time, selected by the
user.
Hourly: Report will be received with the selected time interval
(should be at least 1 minute), beginning at the time selected in
the ‘Time’ property
Daily / Weekly: Report will be received once a day at the
selected time. User can choose the “Every workday” option or select
one or more days from a list.
Monthly: The user should first select months from the list.
After that, he should choose one of 2 options:
On Week of the month: The user should choose a week (First,
Second, Third, Fourth, Last) and day(s) of week, which will set the
days of the month when the report will be received.
In days: The user should directly enter dates (separated by a
comma if more than one is selected) when he want receive
report.
Execute: Select the 'Choose day' checkbox and one or more days
of the week to run and send the report, or 'Every workday' to
run and send the report.
Time: Select the time of day to run and send the report. Note
that this is a 24-hour clock.
Click Next
Confirm the selected options, then click Back to make corrections or click Next
Click Finish
Delete a schedule
Open Internet Explorer to Advisor
Open the 'Tools' menu
Select the 'Schedule wizard...' menu item
Select the 'Delete' option
Click Next
Confirm the selected options, then click Back to make corrections or click Next
Click Finish
Favorites Wizard
Favorite management allows users to save any report with all
parameters as a Favorite and access it quickly at any time. User
can add new favorite, modify or delete existing ones. The
instructions below all open the Favorites wizard from the tools
menu. The Favorites wizard may also be accessed via the
option on the toolbar when a report has been run. Note that when
the Favorites wizard is selected from the toolbar when a report has
been run, that the wizard will assume that it is running for the
selected report and will skip over the report selection screen.
Create a Favorite
Open Internet Explorer to Advisor
Open the 'Tools' menu
Select the 'Favorites wizard...' menu item
Select the 'Create new' option
Click Next
Select the report to add as a favorite. Reports are listed
under the standard categories of problem analysis reports, resource
utilization analysis, etc. This screen will be skipped if the user
has called the wizard from the toolbar.
Click Next
Select the report settings for events to be included in the
report. Some of parameters are dependent and can be selected
after selection of primary parameter. For example, a user can
select a value for the "Group By" parameter only if he selects an
appropriate "Period":
Start Date: The start date may be set (using the 'Absolute'
radio button) to an exact start date using the calendar selection
tool, or the start date may be set (using the 'Relative' radio
button) to a relative start date of Today, Yesterday, This Month:
First Day, This Month: Last Day, This Week: First Day, This week:
Last Day, Previous Month: First Day, Previous Month: Last Day,
Previous Week: First Day, or Previous Week: Last Day
End Date: The end date may be set (using the 'Absolute' radio
button) to an exact end date using the calendar selection tool, or
the end date may be set (using the 'Relative' radio button) to a
relative end date of Today, Yesterday, This Month: First Day, This
Month: Last Day, This Week: First Day, This week: Last Day,
Previous Month: First Day, Previous Month: Last Day, Previous Week:
First Day, or Previous Week: Last Day
Source: The name of the web application(s) from which the
events were received. Note that the 'Source' and 'Computer'
parameters are filtered by Application groups
Computer: The name of the computer(s) from which the events
were received. Note that the 'Source' and 'Computer'
parameters are filtered by Application groups
Application Count: The maximum count of applications thereport
will be created for. For example, if the Application Count = 5,
data from only 5 sources will be available
Click Next
Select the favorite name and description:
Name: The name of the selected report, or modify to use a
custom name
Description: A useful description for the favorite. The
description length must be less than 4000 characters
Use cache: If selected, the favorite report will be pre-cached
automatically at the specified time (at night by default)
Click Next
Confirm the selected options, then click Back to make corrections or click Next
Click Finish
Modify a Favorite
Open Internet Explorer to Advisor
Open the 'Tools' menu
Select the 'Favorites wizard...' menu item
Select the 'Modify' option
Click Next
Select the Favorite to modify.
Click Next
Select the report settings for events to be included in the
report. Some of parameters are dependent and can be selected
after selection of primary parameter. For example, user can select
computers only if he selects an application. :
Start Date: The start date may be set (using the 'Absolute'
radio button) to an exact start date using the calendar selection
tool, or the start date may be set (using the 'Relative' radio
button) to a relative start date of Today, Yesterday, This Month:
First Day, This Month: Last Day, This Week: First Day, This week:
Last Day, Previous Month: First Day, Previous Month: Last Day,
Previous Week: First Day, or Previous Week: Last Day
End Date: The end date may be set (using the 'Absolute' radio
button) to an exact end date using the calendar selection tool, or
the end date may be set (using the 'Relative' radio button) to a
relative end date of Today, Yesterday, This Month: First Day, This
Month: Last Day, This Week: First Day, This week: Last Day,
Previous Month: First Day, Previous Month: Last Day, Previous Week:
First Day, or Previous Week: Last Day
Source: The name of the web application(s) from which the
events were received. Note that the 'Source' and 'Computer'
parameters are filtered by Application groups
Computer: The name of the computer(s) from which the events
were received. Note that the 'Source' and 'Computer'
parameters are filtered by Application groups
Application Count: The maximum count of applications thereport
will be created for. For example, if the Application Count = 5,
data from only 5 sources will be available
Click Next
Select the favorite name and description:
Name: The name of the selected report, or modify to use a
custom name
Description: A useful description for the favorite. The
description length must be less than 4000 characters
Use cache: If selected, the favorite report will be pre-cached
automatically at the specified time (at night by default)
Favorite reports are always cached after the
first execution, and that cache will be cleared at the end of the
day (at 00:00). If the user selects ‘Use cache’, the reporting
server will automatically generate this favorite at the specified
time without any user interaction (by default this will happen in
the morning at at 00:05 or later). This allows a favorite report to
be generated quickly. If caching is disabled, the the report will
be generated from the selected parameters at the time the favorite
is selected.
The favoriteCacheConfiguration section
in SEViewer allows users to configure the time when the Reporting
Server will start to automatically generate the favorite reports
that have to be cached, and to configure the offset between
generations (to avoid possible server overload if, for example, if
hundreds of favorites need to be executed simultaneously). If the
configuration section is absent in the SEViewer configuration file
the values 00:05:00 and 180 seconds will be used respectively.
From your management server, open the
SE-Viewer Configuration file. You may edit the
configuration file via Microsoft Visual Studio .NET, or by using a
text editor:
Start
Programs
AVIcode Intercept Studio
Intercept Configuration
SE-Viewer Configuration
Locate the <favoriteCacheConfiguration> section
Modify the "startTime" (the time in the RS
server local time which will be used as the base point for the
favorite report cache configuration and the subscription execution)
and/or "offset" (the offset value (in seconds) which will be used
to calculate the next favorite subscription execution time) as
desired
...
<favoriteCacheConfiguration>
<!-- The time on the server side (server timezone)
which is used as start point for favorite cache creation -->
<add type="startTime" value="00:00:00" />
<!-- The offset between two cache creation
operation in seconds -->
<add type="offset" value="180" />
</favoriteCacheConfiguration>
</reporting>
Click Next
Confirm the selected options, then click Back to make corrections or click Next
Click Finish
Delete a Favorite
Open Internet Explorer to Advisor
Open the 'Tools' menu
Select the 'Favorites wizard...' menu item
Select the 'Delete' option
Click Next
Select the Favorite to delete.
Click Next
Confirm the selected options, then click Back to make corrections or click Next
Click Finish
Last update:
Thursday,
December 09, 2010 02:42:45 PM
'Tools' menu
'Options...' menu item
Enabling
restricted security for Advisor on this tab when the Advisor
web site is set for Basic, Integrated or Custom authentication
modes in IIS will redirect you to log in using a valid user
account. Once you are logged in, a new field will appear in the
upper right-hand portion of the header bar that displays the user
name and provides a button (
) so that you can log out.
'Remove
Application Groups wizard...' menu item
The following conditions must be met in order to use the
scheduler and to ensure the correct email delivery of reports:
All Programs
option on the toolbar when a report has
been run. Note that when the scheduler is selected from the toolbar
when a report has been run, that the wizard will assume the
scheduler is running for the selected report and will skip over the
report selection screen.
option on the toolbar when a report has been run. Note that when
the Favorites wizard is selected from the toolbar when a report has
been run, that the wizard will assume that it is running for the
selected report and will skip over the report selection screen.