Resource Manager Semantic Model

Friday, 05 May 2006 by Michel Roth

Alexander Ervik Johnsen has put up a Resource Manager Semantic Model for free download on his website.

This package contains a Semantic Model (Report Model) of the Citrix Resource Manager Summary Database and some simple example report definitions. The Semantic Model may be used to create reports and charts using the SQL Server 2005 Report Builder. Reports can be created on an ad hoc basis, or saved to an SQL Server Report Server for future use. Saved reports can be managed with the full range of Reporting Services facilities.

The Summary Database is highly normalized, leading to a confusing number of relations and complex queries to extract meaningful data. The Semantic Model groups data into objects more meaningful to the administrator of a Presentation Server deployment. It also adds brief descriptions of objects and fields.

Download here.