Share via

Reporting Views

  • Article

The HPCReporting SQL database that Windows HPC Server 2008 R2 provides contains several views that you can query to obtain data for custom reports. This section provides reference information about those SQL views.

View name Description

AllocationHistoryView

Lists the allocations of tasks or subtasks in high-performance computing (HPC) jobs to cores on the nodes in the HPC cluster.

DailyNodeStatView

Provides statistics about the availability and use of nodes to run jobs on a daily basis. Contains one row per combination of node and date.

JobHistoryView

Lists each queued instance of a job on an HPC cluster that finished, failed, or was canceled. Includes statistics and information about the properties and results, and tasks for the jobs.

NodeEventHistoryView

Lists the events that occurred on the nodes of an HPC cluster. Events include the addition or removal of nodes and changes to the node state.

NodeGroupMembershipView

Indicates the node groups to which the nodes in an HPC cluster belong. Contains one row for each combination of node and node group for which the node is a member of the node group.

NodeGroupView

Lists the node groups for the HPC cluster.

NodeView

Lists the nodes in an HPC cluster.