RSS Reporter description
Generate standard RSS feeds for SQL Server job status, ad-hoc queries, database size and space usage

RSS Reporter for SQL Server is a simple, yet extremely useful, tool that generates standard RSS feeds containing information regarding SQL Server jobs like the current status of the job, job details, historical status.

RSS Reporter can also make feeds containing information generated by ad-hoc queries and feeds that contain database size and space allocation information.

The RSS Reporter is installed on a server that is running IIS – any user that has credentials to connect to certain SQL Server instances and view job information can create a profile on the RSS Reporter.

The profile for each user contains a list of SQL Server instances, the authentication method, necessary credentials for connecting to each instance, and basic configuration settings.

RSS Reporter automatically generates a set of predefined RSS feeds and supports SQL Server 2000 and SQL Server 2005.

Here are some key features of "RSS

Reporter":

SQL Server Job RSS feeds
· It is very easy to install and configure and it only needs to be installed in one machine regardless of how many servers you need to monitor
· Predefined feeds are automatically generated, no need to go through lengthy configuration process
· All job information from multiple servers is aggregated in one single feed
· Feeds can be read from any connected device and are always there when you need them – no need to delete or archive
· Feeds can be filtered and sorted making it significantly easier and faster to get the information you need

Ad-hoc query RSS feeds
· Feed item title – ability to choose a field from the query output to be used as the feed item title
· Feed layout – you can decide on the feed layout by select the number of the output fields to be displayed in each row of the feed item
· Number of items – you can limit the number of the output rows that will included in the feed
· Sorting the feed items - the generated feed can be sorted by any of the output fields.

Database info RSS feeds
· A summary item for the database itself reporting database size, data file size, log size space allocated etc.
· A feed item for each database data file reporting autogrowth mode and growth factor, file size, space used etc. If your database has, for example, three filegroups and each filegroup has two files, the feed contains six items.
· A feed item for each database log file reporting autogrowth mode, growth factor, file size, space used and space available for the log file.


Requirements:

· IIS 5.0 or higher
· .NET Framework 2.0


Note
Free for one SQL Server.