huttonhenry@gmailcom

Hello Pete,

I think all the servers were rebooted as the Estate was patched/updated
during the month but it is a good point to note.

I will not be back onsite until the end of the month, when the next set
of data is available. Thanks for your information and I will take a
look in December. Hutton

h_henry

Apologies for not replying sooner, I have not been back onsite since
the last post (and yet to visit).

I spoke to the client this morning and they wondered if the
availability reports could be changed so that they show all servers in
their listings (e.g. many reports show the "top ten" or "bottom ten"
machines for availbility). He would like to see all 50 servers listed
instead - is there a way of achieving this or will a custom report need
to be developed? Has anyone else ben able to manage this?

Many thanks, Hutton.

anders bengtsson

Hi Hutton

There is a exchange report showing someting like top 100 mailboxes.
That report you can download, and remove the TOP 100 from "SELECT..." and
upload it as a new report.
Then it will show all mailboxes instead of only top 100. You should be enabe
to do something like
that on other reports too. Maybe not the most optimized way, but it works in
the exchange report

--


Regards
Anders Bengtsson [MCSE, MCSE: Messaging] | anders AT contoso.se |
http://www.contoso.se [ENG]

pete zerger

Hello h_henry@yahoo.com,

There are instructions for this in the Availability Reporting Manual actually.
Check this from the Q&A section of the manual and see if this resolves your
issue:

Problem:
When viewing an Availability Reporting report the Availability section of
the report detailing Top Server Availability and Bottom Server Availability
display only ten servers in each category rather than all servers.

Answer:
Limiting the Top and Bottom Server Availability sections of the report to
ten servers is by design. However, the number of servers displayed can be
increased or decreased by changing the default value in a SQL Server Stored
Procedure. Once the report is then regenerated, or a new report created,
the number of servers displayed will change to the new value. Note: Changing
the value in the SQL Server Stored Procedure affects Availability Reporting
reports globally.

Use the following procedure to change the default value for the display of
Top Server Availability and Bottom Server Availability:
1. On the MOM Reporting database server use either SQL Server Query ****yzer
(SQL Server 2000) or Microsoft SQL Server Management Studio (SQL Server 2005)
to modify the stored procedure MRAS_pcGenerateMRASReport located within the
SystemCenterReporting database
2. The stored procedure has a number of parameters which can be supplied.
The eleventh parameter listed is @NumRows INT = 10 . Change the value 10
to a new value required. For example, if there are 200 monitored servers
within your organization and you wish to display all on the Top and Bottom
Server Availability sections, increase the value to 200. The value set to
a higher value if required to cater for new monitored servers that may be
introduced.
3. Once the value has been modified, taking care not to remove the comma
separator after the value, press F5 to alter the stored procedure.
4. Upon creating a new Availability Reporting report and allowing it to be
generated on its schedule, or allowing existing reports to be re-generated,
the new value will take effect.


Regards,

Pete Zerger, MCSE(Messaging), MVP - MOM
URL:http://www.momresources.org
BLOG: http://www.it-jedi.net/
Books on MOM: http://www.it-jedi.net/books/

pavelfl

Hello,
We have about 60 servers monitoring via mom.
I’m changed the @NumRows INT to 100. But not all servers are in
Availability Reporting Report In section "Availability".
But servers are visible in section "Maintenance mode periods of selected
Servers".

Could you help me?

Many thanks Pavel

pavelfl

Hello,
We have about 60 servers monitoring via mom.
I’m changed the @NumRows INT to 100. But not all servers are in
Availability Reporting Report In section "Availability".
But servers are visible in section "Maintenance mode periods of selected
Servers".

Could you help me?

Many thanks Pavel