<?xml version="1.0" encoding="utf-8" standalone="no"?>
<ReportCollection xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="urn:momx-reporting">
  <ReportItem>
    <Name>Microsoft SQL Server</Name>
    <Type>Folder</Type>
    <Path>/Microsoft Operations Manager Reporting/Microsoft SQL Server</Path>
  </ReportItem>
  <ReportItem>
    <Name>All Failed Logins by Count</Name>
    <Type>Report</Type>
    <Path>/Microsoft Operations Manager Reporting/Microsoft SQL Server/All Failed Logins by Count</Path>
    <ReportDefinition><![CDATA[<?xml version='1.0' encoding='utf-8'?><Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"><rd:GridSpacing xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">0.05in</rd:GridSpacing><RightMargin>1in</RightMargin><Body><ReportItems><Textbox Name="textboxRightLogo"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/2Inch_Logo.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>6</ZIndex><Height>0.5625in</Height><Value /><Left>4.5in</Left></Textbox><Textbox Name="textboxReportTitle_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/4.5Inch_Banner.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>5</ZIndex><Height>0.5625in</Height><Width>4.5in</Width><Value>All Failed Logins (by Count)</Value></Textbox><Textbox Name="textboxExecutionTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>4</ZIndex><Top>0.5625in</Top><Height>0.25in</Height><Value>=Globals.ExecutionTime</Value><Left>4.5in</Left></Textbox><Textbox Name="textboxParameterValue_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.375in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>=Parameters!Instance.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterValue_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.25in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>=Parameters!Computer.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterName_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.375in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>SQL Instance :</Value></Textbox><Textbox Name="textboxParameterName_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.25in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>Server :</Value></Textbox><Textbox Name="textboxDescription_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>GhostWhite</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.8125in</Top><ToggleImage><InitialState>true</InitialState></ToggleImage><Height>0.375in</Height><Visibility><ToggleItem>textboxDescriptionHeading_tmp</ToggleItem><Hidden>true</Hidden></Visibility><CanGrow>true</CanGrow><Value>= "This report displays a total of failed logins for each SQL Server instances installed on a specified server.  Audit data is collected from SQL Server login auditing and totaled for each user.  The rule is dependent on SQL Server auditing and SQL Server audit report collection rules."  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "To enable SQL Server auditing, the following steps should be followed:"  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "Using the SQL Server Enterprise Manager:"  &amp; VbCrLf &amp;  "–       Expand a server group."  &amp; VbCrLf &amp;  "–       Right-click a server, and then click Properties."  &amp; VbCrLf &amp;  "–       Select the Security tab"  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "Under Audit level, select the level at which user accesses to Microsoft® SQL Server™ are recorded in the SQL Server error log:"  &amp; VbCrLf &amp;  "–       None causes no auditing to be performed."  &amp; VbCrLf &amp;  "–       Success causes only successful login attempts to be audited."  &amp; VbCrLf &amp;  "–       Failure causes only failed login attempts to be audited."  &amp; VbCrLf &amp;  "–       All causes successful and failed login attempts to be audited."  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "The following rule needs to be enabled for data to be collected:"  &amp; VbCrLf &amp;  "–       Report Collection - SQL Server 2000 Failed Logins" </Value></Textbox><Textbox Name="textboxDescriptionHeading_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><Top>0.5625in</Top><Height>0.25in</Height><Width>4.5in</Width><CanGrow>true</CanGrow><Value>Description</Value></Textbox><Table Name="table1"><Style /><Top>1.75in</Top><ZIndex>9</ZIndex><NoRows>= "There is no data available for this report. This can occur when there is no relevant data available for collection, the reports’ dependent rules are not enabled or when none of the relevant data has been copied to the Reporting database." </NoRows><DataSetName>SQLSuccessfulLogins</DataSetName><TableColumns><TableColumn><Width>2.125in</Width></TableColumn><TableColumn><Width>0.875in</Width></TableColumn><TableColumn><Width>3.5in</Width></TableColumn></TableColumns><Header><TableRows><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox2"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox2</DefaultName><ZIndex>5</ZIndex><Value>User Name</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox3"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><TextAlign>Center</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox3</DefaultName><ZIndex>4</ZIndex><Value>Count</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox5"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox5</DefaultName><ZIndex>3</ZIndex><Value>Reason</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow></TableRows><RepeatOnNewPage>true</RepeatOnNewPage></Header><TableGroups><TableGroup><Grouping Name="table1_Group1"><GroupExpressions><GroupExpression>=Code.GetUserName(Fields!Message.Value)</GroupExpression></GroupExpressions></Grouping><Header><TableRows><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox1"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox1</DefaultName><ZIndex>2</ZIndex><Value>=Code.GetUserName(Fields!Message.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox4"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextAlign>Center</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox4</DefaultName><ZIndex>1</ZIndex><Value>=Sum(Fields!count.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox6"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox6</DefaultName><Value>=Code.GetReason(Fields!Message.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow></TableRows></Header></TableGroup></TableGroups></Table></ReportItems><Style><BorderWidth><Default>0.5pt</Default></BorderWidth></Style><Height>2.375in</Height><ColumnSpacing>0.25in</ColumnSpacing></Body><TopMargin>1in</TopMargin><DataSources><DataSource Name="SCDW"><rd:DataSourceID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">fb44cba7-75a7-4314-b2a5-1fce44701d23</rd:DataSourceID><DataSourceReference>SCDW</DataSourceReference></DataSource></DataSources><Code>public function CurrentTimeZone() as string 
	CurrentTimeZone = System.TimeZone.CurrentTimeZone.StandardName
end function

public function FormatNumber(fieldValue, formatString) as string 
	if (fieldValue is Nothing)
		FormatNumber = "Not Available"
	else
		FormatNumber = Format(fieldValue,formatString)
	end if
end function

public function GetUserName(message as string) as string 
Dim positionFound
Dim userName = "Not Found"

positionFound = Instr(1, message, "Login failed for user", 1)
If positionFound &gt; 0 Then
	Dim startPos, endPos
	startPos = Instr(positionFound, message, "'", 1)
	If startPos &gt; 0 Then
		endPos = Instr(startPos + 1, message, "'", 1)
		If endPos &gt; 0 Then
			userName = Mid(message, startPos+1, endPos - (startPos+1))
		End If
	End If
End If

	GetUserName = userName
end function


public function GetReason(message as string) as string 
Dim positionFound
Dim reason = "Not Found"

positionFound = Instr(1, message, "Reason:", 1)
If positionFound &gt; 0 Then
	Dim startPos, endPos
	startPos = Instr(positionFound, message, ":", 1) + 1

		endPos = Instr(startPos + 1, message, ".", 1)
		If endPos &gt; 0 Then
			reason = Mid(message, startPos+1, endPos - (startPos+1))
		End If
End If

	GetReason = reason
end function



</Code><Width>6.5in</Width><DataSets><DataSet Name="ComputerList"><Fields><Field Name="Computer"><DataField>Computer</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="ComputerID"><DataField>ComputerID</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Guid</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT DISTINCT SourceClassInstanceKeyValue AS Computer, SourceClassInstanceID AS ComputerID
FROM         [SC_Class_Rel_Computer-SQLInstance_View]
ORDER BY SourceClassInstanceKeyValue</CommandText><Timeout>0</Timeout></Query></DataSet><DataSet Name="SQLSuccessfulLogins"><Fields><Field Name="Instance"><DataField>Instance</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Message"><DataField>Message</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="count"><DataField>count</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Int32</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT     Instance, Message, COUNT(*) AS [count]
FROM         (SELECT     CASE WHEN substring(EDD.EventSource_PK, 1, 6) = 'MSSQL$' THEN substring(EDD.EventSource_PK, 7, 199) 
                                              ELSE EDD.EventSource_PK END AS [Instance], EF.EventMessage AS [Message], EF.LocalDateTimeGenerated AS [Time]
                       FROM          dbo.SC_EventFact_View EF INNER JOIN
                                              dbo.SC_EventTypeDimension_View ETD ON ETD.SMC_InstanceID = EF.EventType_FK INNER JOIN
                                              dbo.SC_EventDetailDimension_View EDD ON EDD.SMC_InstanceID = EF.EventDetail_FK INNER JOIN
                                              dbo.SC_ProviderDetailDimension_View PDD ON PDD.SMC_InstanceID = EF.ProviderDetail_FK INNER JOIN
                                              dbo.SC_ComputerDimension_View CD ON CD.SMC_InstanceID = EF.Computer_FK
                       WHERE      EDD.EventID_PK IN (17055) AND EF.LocalDateTimeGenerated BETWEEN @BeginDate AND @EndDate AND (PATINDEX('%18452%', 
                                              EF.EventMessage) &lt;&gt; 0) AND CD.FullComputerName = @Computer
                       GROUP BY EDD.EventSource_PK, CD.FullComputerName, EF.LocalDateTimeGenerated, EF.EventMessage) TMP
WHERE     (Instance = @Instance)
GROUP BY Instance, Message</CommandText><QueryParameters><QueryParameter Name="@BeginDate"><Value>=Parameters!BeginDate.Value</Value></QueryParameter><QueryParameter Name="@EndDate"><Value>=Parameters!EndDate.Value</Value></QueryParameter><QueryParameter Name="@Computer"><Value>=Parameters!Computer.Value</Value></QueryParameter><QueryParameter Name="@Instance"><Value>=Parameters!Instance.Value</Value></QueryParameter></QueryParameters><Timeout>3000000</Timeout></Query></DataSet><DataSet Name="DateQuery"><Fields><Field Name="BeginDate"><DataField>BeginDate</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field><Field Name="EndDate"><DataField>EndDate</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT     *
FROM         fn_GetDateRange(7) fn_GetDateRange</CommandText><Timeout>300000</Timeout></Query></DataSet><DataSet Name="SQLINstance"><Fields><Field Name="Instance"><DataField>Instance</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT DISTINCT TargetClassInstanceKeyValue AS [Instance]
FROM         [SC_Class_Rel_Computer-SQLInstance_View]
WHERE     (SourceClassInstanceKeyValue = @Computer)
order by TargetClassInstanceKeyValue</CommandText><QueryParameters><QueryParameter Name="@Computer"><Value>=Parameters!Computer.Value</Value></QueryParameter></QueryParameters><Timeout>300000</Timeout><UseGenericDesigner xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</UseGenericDesigner></Query></DataSet></DataSets><LeftMargin>1in</LeftMargin><rd:SnapToGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:SnapToGrid><rd:DrawGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:DrawGrid><Description /><rd:ReportID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">212d782b-9718-4b8d-a1c1-2bd72afd7b82</rd:ReportID><PageFooter><ReportItems><Textbox Name="textboxPageNumber_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.25in</Top><Height>0.25in</Height><Value>="Page " &amp; Globals.PageNumber &amp; "/" &amp; Globals.TotalPages</Value><Left>4in</Left></Textbox><Textbox Name="textbox1DateTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><Top>0.25in</Top><Height>0.25in</Height><Width>4in</Width><Value>="All dates and  times shown in " &amp; Code.CurrentTimeZone()</Value></Textbox></ReportItems><PrintOnLastPage>true</PrintOnLastPage><PrintOnFirstPage>true</PrintOnFirstPage><Style /><Height>0.55in</Height></PageFooter><BottomMargin>1in</BottomMargin><ReportParameters><ReportParameter Name="BeginDate"><DataType>DateTime</DataType><DefaultValue><DataSetReference><DataSetName>DateQuery</DataSetName><ValueField>BeginDate</ValueField></DataSetReference></DefaultValue><Prompt>Begin Date</Prompt></ReportParameter><ReportParameter Name="EndDate"><DataType>DateTime</DataType><DefaultValue><DataSetReference><DataSetName>DateQuery</DataSetName><ValueField>EndDate</ValueField></DataSetReference></DefaultValue><Prompt>End Date</Prompt></ReportParameter><ReportParameter Name="Computer"><DataType>String</DataType><Prompt>Computer</Prompt><ValidValues><DataSetReference><DataSetName>ComputerList</DataSetName><ValueField>Computer</ValueField><LabelField>Computer</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="Instance"><DataType>String</DataType><DefaultValue><DataSetReference><DataSetName>SQLINstance</DataSetName><ValueField>Instance</ValueField></DataSetReference></DefaultValue><Prompt>SQL Instance</Prompt><ValidValues><DataSetReference><DataSetName>SQLINstance</DataSetName><ValueField>Instance</ValueField><LabelField>Instance</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="SortBy"><DataType>String</DataType><DefaultValue><Values><Value>count</Value></Values></DefaultValue><Prompt>Sort By</Prompt><ValidValues><ParameterValues><ParameterValue><Value>USerName</Value><Label>User Name</Label></ParameterValue><ParameterValue><Value>Reason</Value></ParameterValue><ParameterValue><Value>count</Value><Label>Count</Label></ParameterValue></ParameterValues></ValidValues></ReportParameter><ReportParameter Name="Direction"><DataType>String</DataType><DefaultValue><Values><Value>Descending</Value></Values></DefaultValue><Prompt>Sort Order</Prompt><ValidValues><ParameterValues><ParameterValue><Value>Ascending</Value></ParameterValue><ParameterValue><Value>Descending</Value></ParameterValue></ParameterValues></ValidValues></ReportParameter></ReportParameters></Report>]]></ReportDefinition>
  </ReportItem>
  <ReportItem>
    <Name>All Successful Logins by Count</Name>
    <Type>Report</Type>
    <Path>/Microsoft Operations Manager Reporting/Microsoft SQL Server/All Successful Logins by Count</Path>
    <ReportDefinition><![CDATA[<?xml version='1.0' encoding='utf-8'?><Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"><rd:GridSpacing xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">0.05in</rd:GridSpacing><RightMargin>1in</RightMargin><Body><ReportItems><Textbox Name="textboxRightLogo"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/2Inch_Logo.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>6</ZIndex><Height>0.5625in</Height><Value /><Left>4.5in</Left></Textbox><Textbox Name="textboxReportTitle_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/4.5Inch_Banner.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>5</ZIndex><Height>0.5625in</Height><Width>4.5in</Width><Value>All Successful Logins (by Count)</Value></Textbox><Textbox Name="textboxExecutionTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>4</ZIndex><Top>0.5625in</Top><Height>0.25in</Height><Value>=Globals.ExecutionTime</Value><Left>4.5in</Left></Textbox><Textbox Name="textboxParameterValue_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.375in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>=Parameters!Instance.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterValue_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.25in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>=Parameters!Computer.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterName_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.375in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>SQL Instance :</Value></Textbox><Textbox Name="textboxParameterName_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.25in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>Server :</Value></Textbox><Textbox Name="textboxDescription_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>GhostWhite</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.8125in</Top><ToggleImage><InitialState>true</InitialState></ToggleImage><Height>0.375in</Height><Visibility><ToggleItem>textboxDescriptionHeading_tmp</ToggleItem><Hidden>true</Hidden></Visibility><CanGrow>true</CanGrow><Value>= "This report displays a total of successful logins for the specified SQL Server instance installed on a specified server.  Audit data is collected from SQL Server login auditing and totaled for each user."  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "To enable SQL Server auditing, the following steps should be followed:"  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "Using the SQL Server Enterprise Manager:"  &amp; VbCrLf &amp;  "–       Expand a server group."  &amp; VbCrLf &amp;  "–       Right-click a server, and then click Properties."  &amp; VbCrLf &amp;  "–       Select the Security tab"  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "Under Audit level, select the level at which user accesses to Microsoft® SQL Server™ are recorded in the SQL Server error log:"  &amp; VbCrLf &amp;  "–       None causes no auditing to be performed."  &amp; VbCrLf &amp;  "–       Success causes only successful login attempts to be audited."  &amp; VbCrLf &amp;  "–       Failure causes only failed login attempts to be audited."  &amp; VbCrLf &amp;  "–       All causes successful and failed login attempts to be audited."  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "The following rule needs to be enabled for data to be collected:"  &amp; VbCrLf &amp;  "–        Report Collection - SQL Server 2000 Successful Logins (Non-Trusted)"  &amp; VbCrLf &amp;  "–        Report Collection - SQL Server 2000 Successful Logins (Trusted)" </Value></Textbox><Textbox Name="textboxDescriptionHeading_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><Top>0.5625in</Top><Height>0.25in</Height><Width>4.5in</Width><CanGrow>true</CanGrow><Value>Description</Value></Textbox><Table Name="table1"><Style /><Top>1.75in</Top><Height>0.5in</Height><ZIndex>9</ZIndex><NoRows>= "There is no data available for this report. This can occur when there is no relevant data available for collection, the reports’ dependent rules are not enabled or when none of the relevant data has been copied to the Reporting database." </NoRows><DataSetName>SQLSuccessfulLogins</DataSetName><TableColumns><TableColumn><Width>3in</Width></TableColumn><TableColumn><Width>0.91in</Width></TableColumn><TableColumn><Width>2.625in</Width></TableColumn></TableColumns><Header><TableRows><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox2"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox2</DefaultName><ZIndex>5</ZIndex><Value>User Name</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox3"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><TextAlign>Center</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox3</DefaultName><ZIndex>4</ZIndex><Value>Count</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox5"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox5</DefaultName><ZIndex>3</ZIndex><Value>Connection</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow></TableRows><RepeatOnNewPage>true</RepeatOnNewPage></Header><TableGroups><TableGroup><Grouping Name="table1_Group1"><GroupExpressions><GroupExpression>=Code.GetUserName(Fields!Message.Value)</GroupExpression></GroupExpressions></Grouping><Header><TableRows><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox1"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox1</DefaultName><ZIndex>2</ZIndex><Value>=Code.GetUserName(Fields!Message.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox4"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextAlign>Center</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox4</DefaultName><ZIndex>1</ZIndex><Value>=Sum(Fields!count.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox6"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox6</DefaultName><Value>=Code.GetConnection(Fields!Message.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow></TableRows></Header></TableGroup></TableGroups></Table></ReportItems><Style><BorderWidth><Default>0.5pt</Default></BorderWidth></Style><Height>11in</Height><ColumnSpacing>0.25in</ColumnSpacing></Body><TopMargin>1in</TopMargin><DataSources><DataSource Name="SCDW"><rd:DataSourceID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">fb44cba7-75a7-4314-b2a5-1fce44701d23</rd:DataSourceID><DataSourceReference>SCDW</DataSourceReference></DataSource></DataSources><Code>public function CurrentTimeZone() as string 
	CurrentTimeZone = System.TimeZone.CurrentTimeZone.StandardName
end function

public function FormatNumber(fieldValue, formatString) as string 
	if (fieldValue is Nothing)
		FormatNumber = "Not Available"
	else
		FormatNumber = Format(fieldValue,formatString)
	end if
end function

public function GetUserName(message as string) as string 
Dim positionFound
Dim userName = "Not Found"

positionFound = Instr(1, message, "Login succeeded for user", 1)
If positionFound &gt; 0 Then
	Dim startPos, endPos
	startPos = Instr(positionFound, message, "'", 1)
	If startPos &gt; 0 Then
		endPos = Instr(startPos + 1, message, "'", 1)
		If endPos &gt; 0 Then
			userName = Mid(message, startPos+1, endPos - (startPos+1))
		End If
	End If
End If

	GetUserName = userName
end function


public function GetConnection(message as string) as string 
Dim positionFound
Dim connection = "Not Found"

positionFound = Instr(1, message, "Connection:", 1)
If positionFound &gt; 0 Then
	Dim startPos, endPos
	startPos = Instr(positionFound, message, ":", 1) + 1

		endPos = Instr(startPos + 1, message, ".", 1)
		If endPos &gt; 0 Then
			connection = Mid(message, startPos+1, endPos - (startPos+1))
		End If
End If

	GetConnection = connection
end function
</Code><Width>6.535in</Width><DataSets><DataSet Name="ComputerList"><Fields><Field Name="Computer"><DataField>Computer</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="ComputerID"><DataField>ComputerID</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Guid</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT DISTINCT SourceClassInstanceKeyValue AS Computer, SourceClassInstanceID AS ComputerID
FROM         [SC_Class_Rel_Computer-SQLInstance_View]
ORDER BY SourceClassInstanceKeyValue</CommandText><Timeout>0</Timeout></Query></DataSet><DataSet Name="SQLSuccessfulLogins"><Fields><Field Name="Instance"><DataField>Instance</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Message"><DataField>Message</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="count"><DataField>count</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Int32</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT     Instance, Message, COUNT(*) AS [count]
FROM         (SELECT     CASE WHEN substring(EDD.EventSource_PK, 1, 6) = 'MSSQL$' THEN substring(EDD.EventSource_PK, 7, 199) 
                                              ELSE EDD.EventSource_PK END AS [Instance], EF.EventMessage AS [Message], EF.LocalDateTimeGenerated AS [Time]
                       FROM          dbo.SC_EventFact_View EF INNER JOIN
                                              dbo.SC_EventTypeDimension_View ETD ON ETD.SMC_InstanceID = EF.EventType_FK INNER JOIN
                                              dbo.SC_EventDetailDimension_View EDD ON EDD.SMC_InstanceID = EF.EventDetail_FK INNER JOIN
                                              dbo.SC_ProviderDetailDimension_View PDD ON PDD.SMC_InstanceID = EF.ProviderDetail_FK INNER JOIN
                                              dbo.SC_ComputerDimension_View CD ON CD.SMC_InstanceID = EF.Computer_FK
                       WHERE      EDD.EventID_PK IN (17055) AND EF.LocalDateTimeGenerated BETWEEN @BeginDate AND @EndDate AND (PATINDEX('%18453%', 
                                              EF.EventMessage) &lt;&gt; 0) AND CD.FullComputerName = @Computer
                       GROUP BY EDD.EventSource_PK, CD.FullComputerName, EF.LocalDateTimeGenerated, EF.EventMessage) TMP
WHERE     (Instance = @Instance)
GROUP BY Instance, Message</CommandText><QueryParameters><QueryParameter Name="@BeginDate"><Value>=Parameters!BeginDate.Value</Value></QueryParameter><QueryParameter Name="@EndDate"><Value>=Parameters!EndDate.Value</Value></QueryParameter><QueryParameter Name="@Computer"><Value>=Parameters!Computer.Value</Value></QueryParameter><QueryParameter Name="@Instance"><Value>=Parameters!Instance.Value</Value></QueryParameter></QueryParameters><Timeout>3000000</Timeout></Query></DataSet><DataSet Name="DateQuery"><Fields><Field Name="BeginDate"><DataField>BeginDate</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field><Field Name="EndDate"><DataField>EndDate</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT     *
FROM         fn_GetDateRange(7) fn_GetDateRange</CommandText><Timeout>300000</Timeout></Query></DataSet><DataSet Name="SQLINstance"><Fields><Field Name="Instance"><DataField>Instance</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT DISTINCT TargetClassInstanceKeyValue AS [Instance]
FROM         [SC_Class_Rel_Computer-SQLInstance_View]
WHERE     (SourceClassInstanceKeyValue = @Computer)
order by TargetClassInstanceKeyValue</CommandText><QueryParameters><QueryParameter Name="@Computer"><Value>=Parameters!Computer.Value</Value></QueryParameter></QueryParameters><Timeout>300000</Timeout><UseGenericDesigner xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</UseGenericDesigner></Query></DataSet></DataSets><LeftMargin>1in</LeftMargin><rd:SnapToGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:SnapToGrid><rd:DrawGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:DrawGrid><Description /><rd:ReportID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">212d782b-9718-4b8d-a1c1-2bd72afd7b82</rd:ReportID><PageFooter><ReportItems><Textbox Name="textboxPageNumber_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.25in</Top><Height>0.25in</Height><Value>="Page " &amp; Globals.PageNumber &amp; "/" &amp; Globals.TotalPages</Value><Left>4in</Left></Textbox><Textbox Name="textbox1DateTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><Top>0.25in</Top><Height>0.25in</Height><Width>4in</Width><Value>="All dates and  times shown in " &amp; Code.CurrentTimeZone()</Value></Textbox></ReportItems><PrintOnLastPage>true</PrintOnLastPage><PrintOnFirstPage>true</PrintOnFirstPage><Style /><Height>0.55in</Height></PageFooter><BottomMargin>1in</BottomMargin><ReportParameters><ReportParameter Name="BeginDate"><DataType>DateTime</DataType><DefaultValue><DataSetReference><DataSetName>DateQuery</DataSetName><ValueField>BeginDate</ValueField></DataSetReference></DefaultValue><Prompt>Begin Date</Prompt></ReportParameter><ReportParameter Name="EndDate"><DataType>DateTime</DataType><DefaultValue><DataSetReference><DataSetName>DateQuery</DataSetName><ValueField>EndDate</ValueField></DataSetReference></DefaultValue><Prompt>End Date</Prompt></ReportParameter><ReportParameter Name="Computer"><DataType>String</DataType><Prompt>Computer</Prompt><ValidValues><DataSetReference><DataSetName>ComputerList</DataSetName><ValueField>Computer</ValueField><LabelField>Computer</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="Instance"><DataType>String</DataType><DefaultValue><DataSetReference><DataSetName>SQLINstance</DataSetName><ValueField>Instance</ValueField></DataSetReference></DefaultValue><Prompt>SQL Instance</Prompt><ValidValues><DataSetReference><DataSetName>SQLINstance</DataSetName><ValueField>Instance</ValueField><LabelField>Instance</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="SortBy"><DataType>String</DataType><DefaultValue><Values><Value>count</Value></Values></DefaultValue><Prompt>Sort By</Prompt><ValidValues><ParameterValues><ParameterValue><Value>USerName</Value><Label>User Name</Label></ParameterValue><ParameterValue><Value>count</Value><Label>Count</Label></ParameterValue><ParameterValue><Value>Reason</Value><Label>Connection</Label></ParameterValue></ParameterValues></ValidValues></ReportParameter><ReportParameter Name="Direction"><DataType>String</DataType><DefaultValue><Values><Value>Descending</Value></Values></DefaultValue><Prompt>Sort Order</Prompt><ValidValues><ParameterValues><ParameterValue><Value>Ascending</Value></ParameterValue><ParameterValue><Value>Descending</Value></ParameterValue></ParameterValues></ValidValues></ReportParameter></ReportParameters></Report>]]></ReportDefinition>
  </ReportItem>
  <ReportItem>
    <Name>SQL Server Backup History</Name>
    <Type>Report</Type>
    <Path>/Microsoft Operations Manager Reporting/Microsoft SQL Server/SQL Server Backup History</Path>
    <ReportDefinition><![CDATA[<?xml version='1.0' encoding='utf-8'?><Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"><rd:GridSpacing xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">0.05in</rd:GridSpacing><RightMargin>1in</RightMargin><Body><ReportItems><Textbox Name="textboxRightLogo"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/2Inch_Logo.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>6</ZIndex><Height>0.5625in</Height><Value /><Left>9in</Left></Textbox><Textbox Name="textboxReportTitle_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/9Inch_Banner.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>5</ZIndex><Height>0.5625in</Height><Width>9in</Width><CanGrow>true</CanGrow><Value>SQL Server Backup History</Value></Textbox><Textbox Name="textboxExecutionTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>4</ZIndex><Top>0.5625in</Top><Height>0.25in</Height><Value>=Globals.ExecutionTime</Value><Left>9in</Left></Textbox><Textbox Name="textboxParameterValue_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.375in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>= Parameters!Computer.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterValue_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.25in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>=Parameters!BeginDate.Value &amp; " - " &amp; Parameters!EndDate.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterName_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.375in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>Computer :</Value></Textbox><Textbox Name="textboxParameterName_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.25in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>Date Range :</Value></Textbox><Textbox Name="textboxDescription_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>GhostWhite</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.8125in</Top><ToggleImage><InitialState>true</InitialState></ToggleImage><Height>0.375in</Height><Visibility><ToggleItem>textboxDescriptionHeading_tmp</ToggleItem><Hidden>true</Hidden></Visibility><CanGrow>true</CanGrow><Value>= "This report displays a history of SQL Server total, failed and successful backups for each instance installed on a specified SQL Server.  By default this report will display data for all SQL Servers."  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "The report is dependent on the following Report Collection rules"  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "–       Report Collection – Failed Backups"  &amp; VbCrLf &amp;  "–       Report Collection – Successful Backups" </Value></Textbox><Textbox Name="textboxDescriptionHeading_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><Top>0.5625in</Top><Height>0.25in</Height><Width>9in</Width><CanGrow>true</CanGrow><Value>Description</Value></Textbox><Table Name="table3"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle></Style><Top>1.75in</Top><Height>1.25in</Height><ZIndex>9</ZIndex><NoRows>= "There is no data available for this report. This can occur when there is no relevant data available for collection, the reports’ dependent rules are not enabled or when none of the relevant data has been copied to the Reporting database." </NoRows><DataSetName>SQLBackupLevel</DataSetName><TableColumns><TableColumn><Width>3.5in</Width></TableColumn><TableColumn><Width>3in</Width></TableColumn><TableColumn><Width>1.5in</Width></TableColumn><TableColumn><Width>1.5in</Width></TableColumn><TableColumn><Width>1.5in</Width></TableColumn></TableColumns><Header><TableRows><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox5"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox5</DefaultName><ZIndex>10</ZIndex><Value>Server Name</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox6"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox6</DefaultName><ZIndex>9</ZIndex><Value>SQL Instance Name</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox13"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><TextAlign>Right</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox13</DefaultName><ZIndex>8</ZIndex><Value>Total Backups</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox23"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><TextAlign>Right</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox23</DefaultName><ZIndex>7</ZIndex><Value>Failed Backups</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox34"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><TextAlign>Right</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox34</DefaultName><ZIndex>6</ZIndex><Value>Successful Backups</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow></TableRows><RepeatOnNewPage>true</RepeatOnNewPage></Header><TableGroups><TableGroup><Grouping Name="table3_Group1"><GroupExpressions><GroupExpression>=Fields!Server.Value</GroupExpression><GroupExpression>=Fields!Instance.Value</GroupExpression></GroupExpressions></Grouping><Sorting><SortBy><SortExpression>=iif(Parameters!Direction.Value="Ascending",Fields(Parameters!SortBy.Value).Value,0)</SortExpression><Direction>Ascending</Direction></SortBy><SortBy><SortExpression>=iif(Parameters!Direction.Value="Descending",Fields(Parameters!SortBy.Value).Value,0) </SortExpression><Direction>Descending</Direction></SortBy></Sorting><Header><TableRows><TableRow><TableCells><TableCell><ReportItems><Textbox Name="Server_1"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Server_1</DefaultName><ZIndex>5</ZIndex><Value>=Fields!Server.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Instance_1"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Instance_1</DefaultName><ZIndex>4</ZIndex><Value>=Fields!Instance.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Failed_Backups_2"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Failed_Backups_2</DefaultName><ZIndex>3</ZIndex><Value>=Sum(Fields!TotalBackups.Value
)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Failed_Backups_3"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Failed_Backups_3</DefaultName><ZIndex>2</ZIndex><Value>=Sum(Fields!Failed_Backups.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Successful_Backups_1"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Successful_Backups_1</DefaultName><ZIndex>1</ZIndex><Value>=Sum(Fields!Successful_Backups.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow></TableRows></Header></TableGroup><TableGroup><Grouping Name="table3_Group2"><GroupExpressions><GroupExpression>=Fields!Server.Value</GroupExpression><GroupExpression>=Fields!Instance.Value</GroupExpression></GroupExpressions></Grouping><Sorting><SortBy><SortExpression>=iif(Parameters!Direction.Value="Ascending",Fields(Parameters!SortBy.Value).Value,0)</SortExpression><Direction>Ascending</Direction></SortBy><SortBy><SortExpression>=iif(Parameters!Direction.Value="Descending",Fields(Parameters!SortBy.Value).Value,0)</SortExpression><Direction>Descending</Direction></SortBy></Sorting><Header><TableRows><TableRow><TableCells><TableCell><ReportItems><Rectangle Name="rectangle3"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle></Style><ReportItems><Table Name="table5"><Style /><DataSetName>SQLBackupLevel</DataSetName><TableColumns><TableColumn><Width>1.8in</Width></TableColumn><TableColumn><Width>1.7in</Width></TableColumn><TableColumn><Width>3in</Width></TableColumn><TableColumn><Width>1.5in</Width></TableColumn><TableColumn><Width>3in</Width></TableColumn></TableColumns><Header><TableRows><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox1"><Style><BorderColor><Default>LightGrey</Default></BorderColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox1</DefaultName><ZIndex>14</ZIndex><Value /><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox2"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox2</DefaultName><ZIndex>13</ZIndex><Value>Time</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox3"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox3</DefaultName><ZIndex>12</ZIndex><Value>Database</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox14"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox14</DefaultName><ZIndex>11</ZIndex><Value>Backup Type</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox15"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox15</DefaultName><ZIndex>10</ZIndex><Value>Backup Name (if available)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow></TableRows></Header><TableGroups><TableGroup><Grouping Name="table5_Group1"><GroupExpressions><GroupExpression>=Fields!FailedSuccessful.Value</GroupExpression></GroupExpressions></Grouping><Header><TableRows><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox70"><Style><BorderColor><Default>LightGrey</Default></BorderColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><ZIndex>9</ZIndex><Value>=Fields!FailedSuccessful.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox71"><Style><BorderColor><Default>LightGrey</Default></BorderColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><TextAlign>Left</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><ZIndex>8</ZIndex><Value /><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox72"><Style><BorderColor><Default>LightGrey</Default></BorderColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><TextAlign>Left</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><ZIndex>7</ZIndex><Value /><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox73"><Style><BorderColor><Default>LightGrey</Default></BorderColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><ZIndex>6</ZIndex><Value /><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox74"><Style><BorderColor><Default>LightGrey</Default></BorderColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><ZIndex>5</ZIndex><Value /><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow></TableRows></Header></TableGroup></TableGroups><Details><TableRows><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox60"><Style><BorderColor><Default>LightGrey</Default></BorderColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><ZIndex>4</ZIndex><Value /><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox61"><Style><BorderColor><Default>LightGrey</Default></BorderColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><ZIndex>3</ZIndex><Value>=Fields!Time.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox62"><Style><BorderColor><Default>LightGrey</Default></BorderColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><ZIndex>2</ZIndex><Value>=Fields!Database.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox63"><Style><BorderColor><Default>LightGrey</Default></BorderColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><ZIndex>1</ZIndex><Value>=Fields!Backup_Type.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox64"><Style><BorderColor><Default>LightGrey</Default></BorderColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><Value>=Fields!Backup_Name.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height><Visibility><Hidden>true</Hidden><ToggleItem>textbox70</ToggleItem></Visibility></TableRow></TableRows></Details></Table></ReportItems></Rectangle></ReportItems><ColSpan>5</ColSpan></TableCell></TableCells><Height>0.75in</Height><Visibility><Hidden>true</Hidden><ToggleItem>Server_1</ToggleItem></Visibility></TableRow></TableRows></Header></TableGroup></TableGroups></Table></ReportItems><Style><BorderWidth><Default>0.5pt</Default></BorderWidth></Style><Height>11in</Height><ColumnSpacing>0.25in</ColumnSpacing></Body><TopMargin>1in</TopMargin><DataSources><DataSource Name="SCDW"><rd:DataSourceID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">fb44cba7-75a7-4314-b2a5-1fce44701d23</rd:DataSourceID><DataSourceReference>SCDW</DataSourceReference></DataSource></DataSources><Code>public function CurrentTimeZone() as string 
	CurrentTimeZone = System.TimeZone.CurrentTimeZone.StandardName
end function

public function FormatNumber(fieldValue, formatString) as string 
	if (fieldValue is Nothing)
		FormatNumber = "Not Available"
	else
		FormatNumber = Format(fieldValue,formatString)
	end if
end function
</Code><Width>11in</Width><DataSets><DataSet Name="DateQuery"><Fields><Field Name="BeginDate"><DataField>BeginDate</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field><Field Name="EndDate"><DataField>EndDate</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT     *
FROM         fn_GetDateRange(7) fn_GetDateRange</CommandText><Timeout>0</Timeout></Query></DataSet><DataSet Name="ComputerList"><Fields><Field Name="Computer"><DataField>Computer</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT   Computer
FROM         fn_GetComputersInGroup('Microsoft SQL Server 2000') fn_GetComputersInGroup
UNION
SELECT     '&lt;ALL&gt;'
order by Computer</CommandText><Timeout>3000000</Timeout><UseGenericDesigner xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</UseGenericDesigner></Query></DataSet><DataSet Name="SQLInstance"><Fields><Field Name="Instance"><DataField>Instance</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT DISTINCT TargetClassInstanceKeyValue AS [Instance]
FROM         [SC_Class_Rel_Computer-SQLInstance_View]
WHERE     (SourceClassInstanceKeyValue = @Computer)
order by TargetClassInstanceKeyValue</CommandText><QueryParameters><QueryParameter Name="@Computer"><Value>=Parameters!Computer.Value</Value></QueryParameter></QueryParameters><Timeout>3000000</Timeout><UseGenericDesigner xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</UseGenericDesigner></Query></DataSet><DataSet Name="SQLBackupLevel"><Fields><Field Name="Server"><DataField>Server</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Instance"><DataField>Instance</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Failed_Backups"><DataField>Failed Backups</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Int32</TypeName></Field><Field Name="Successful_Backups"><DataField>Successful Backups</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Int32</TypeName></Field><Field Name="TotalBackups"><DataField>TotalBackups</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Int32</TypeName></Field><Field Name="Time"><DataField>Time</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field><Field Name="Backup_Type"><DataField>Backup Type</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Backup_Name"><DataField>Backup Name</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="FailedSuccessful"><DataField>FailedSuccessful</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Database"><DataField>Database</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandType>StoredProcedure</CommandType><CommandText>p_SQLBackupHistoryReport</CommandText><QueryParameters><QueryParameter Name="@Computer"><Value>=Parameters!Computer.Value</Value></QueryParameter><QueryParameter Name="@BeginDate"><Value>=Parameters!BeginDate.Value</Value></QueryParameter><QueryParameter Name="@EndDate"><Value>=Parameters!EndDate.Value</Value></QueryParameter></QueryParameters><Timeout>30000000</Timeout></Query></DataSet></DataSets><LeftMargin>1in</LeftMargin><rd:SnapToGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:SnapToGrid><rd:DrawGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:DrawGrid><Description /><PageWidth>13in</PageWidth><rd:ReportID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">212d782b-9718-4b8d-a1c1-2bd72afd7b82</rd:ReportID><PageFooter><ReportItems><Textbox Name="textboxPageNumber_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.2in</Top><Height>0.25in</Height><Value>="Page " &amp; Globals.PageNumber &amp; "/" &amp; Globals.TotalPages</Value><Left>4in</Left></Textbox><Textbox Name="textbox1DateTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><Top>0.2in</Top><Height>0.25in</Height><Width>4in</Width><Value>="All dates and  times shown in " &amp; Code.CurrentTimeZone()</Value></Textbox></ReportItems><PrintOnLastPage>true</PrintOnLastPage><PrintOnFirstPage>true</PrintOnFirstPage><Style /><Height>0.5in</Height></PageFooter><BottomMargin>1in</BottomMargin><ReportParameters><ReportParameter Name="BeginDate"><DataType>DateTime</DataType><DefaultValue><DataSetReference><DataSetName>DateQuery</DataSetName><ValueField>BeginDate</ValueField></DataSetReference></DefaultValue><Prompt>Begin Date</Prompt></ReportParameter><ReportParameter Name="EndDate"><DataType>DateTime</DataType><DefaultValue><DataSetReference><DataSetName>DateQuery</DataSetName><ValueField>EndDate</ValueField></DataSetReference></DefaultValue><Prompt>End Date</Prompt></ReportParameter><ReportParameter Name="Computer"><DataType>String</DataType><Prompt>Computer</Prompt><ValidValues><DataSetReference><DataSetName>ComputerList</DataSetName><ValueField>Computer</ValueField><LabelField>Computer</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="SortBy"><DataType>String</DataType><DefaultValue><Values><Value>Instance</Value></Values></DefaultValue><Prompt>Sort By</Prompt><ValidValues><ParameterValues><ParameterValue><Value>Server</Value><Label>Server Name</Label></ParameterValue><ParameterValue><Value>Instance</Value><Label>SQL Instance Name</Label></ParameterValue></ParameterValues></ValidValues></ReportParameter><ReportParameter Name="Direction"><DataType>String</DataType><DefaultValue><Values><Value>Ascending</Value></Values></DefaultValue><Prompt>Sort Order</Prompt><ValidValues><ParameterValues><ParameterValue><Value>Ascending</Value></ParameterValue><ParameterValue><Value>Descending</Value></ParameterValue></ParameterValues></ValidValues></ReportParameter></ReportParameters></Report>]]></ReportDefinition>
  </ReportItem>
  <ReportItem>
    <Name>SQL Server Block Analysis</Name>
    <Type>Report</Type>
    <Path>/Microsoft Operations Manager Reporting/Microsoft SQL Server/SQL Server Block Analysis</Path>
    <ReportDefinition><![CDATA[<?xml version='1.0' encoding='utf-8'?><Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"><rd:GridSpacing xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">0.05in</rd:GridSpacing><RightMargin>1in</RightMargin><Body><ReportItems><Textbox Name="textboxRightLogo"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/2Inch_Logo.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>6</ZIndex><Height>0.5625in</Height><Value /><Left>9in</Left></Textbox><Textbox Name="textboxReportTitle_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/9Inch_Banner.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>5</ZIndex><Height>0.5625in</Height><Width>9in</Width><CanGrow>true</CanGrow><Value>SQL Server Block Analysis</Value></Textbox><Textbox Name="textboxExecutionTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>4</ZIndex><Top>0.5625in</Top><Height>0.25in</Height><Value>=Globals.ExecutionTime</Value><Left>9in</Left></Textbox><Textbox Name="textboxParameterValue_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.375in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>= Parameters!Computer.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterValue_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.25in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>=Parameters!BeginDate.Value &amp; " - " &amp; Parameters!EndDate.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterName_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.375in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>Server :</Value></Textbox><Textbox Name="textboxParameterName_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.25in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>Date Range :</Value></Textbox><Textbox Name="textboxDescription_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>GhostWhite</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.8125in</Top><ToggleImage><InitialState>true</InitialState></ToggleImage><Height>0.375in</Height><Visibility><ToggleItem>textboxDescriptionHeading_tmp</ToggleItem><Hidden>true</Hidden></Visibility><CanGrow>true</CanGrow><Value>= "This report displays SQL Server block analysis by displaying alert data from historical SQL Server block situations.  This report displays blocking statistics including blocked applications, users and average wait time."  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "Note - this report displays a snap shot of blocking alerts for a point in time.  If you have blocking conditions which continued after an alert was raised, the initial blocking value will be displayed." </Value></Textbox><Textbox Name="textboxDescriptionHeading_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><Top>0.5625in</Top><Height>0.25in</Height><Width>9in</Width><CanGrow>true</CanGrow><Value>Description</Value></Textbox><Table Name="table1"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle></Style><Top>1.75in</Top><Height>0.75in</Height><ZIndex>2</ZIndex><NoRows>= "There is no data available for this report. This can occur when there is no relevant data available for collection, the reports’ dependent rules are not enabled or when none of the relevant data has been copied to the Reporting database." </NoRows><DataSetName>BlockedAnalysis</DataSetName><TableColumns><TableColumn><Width>2.83871in</Width></TableColumn><TableColumn><Width>2.83871in</Width></TableColumn><TableColumn><Width>2.83871in</Width></TableColumn><TableColumn><Width>1.24194in</Width></TableColumn><TableColumn><Width>1.24193in</Width></TableColumn></TableColumns><Header><TableRows><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox3"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox3</DefaultName><ZIndex>11</ZIndex><Value>Instance Name</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Server"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Server</DefaultName><ZIndex>10</ZIndex><Value>Database Name</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox2"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox2</DefaultName><ZIndex>9</ZIndex><Value>Program Name</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox1"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><TextAlign>Right</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox1</DefaultName><ZIndex>8</ZIndex><Value># Blocks</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox6"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><TextAlign>Right</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox6</DefaultName><ZIndex>7</ZIndex><Value>Average Block Time</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow></TableRows><RepeatOnNewPage>true</RepeatOnNewPage></Header><TableGroups><TableGroup><Grouping Name="table1_Group1"><GroupExpressions><GroupExpression>=Fields!BlockedInstance.Value</GroupExpression></GroupExpressions></Grouping><Header><TableRows><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox5"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Left>Solid</Left><Top>Solid</Top><Bottom>Solid</Bottom></BorderStyle><BackgroundColor>GhostWhite</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextDecoration>Underline</TextDecoration><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><Action><Drillthrough><ReportName>SQL Server Block Analysis Detail</ReportName><Parameters><Parameter Name="Computer"><Value>=Fields!Server.Value</Value></Parameter><Parameter Name="Instance"><Value>=Fields!BlockedInstance.Value</Value></Parameter><Parameter Name="BeginDate"><Value>=Parameters!BeginDate.Value</Value></Parameter><Parameter Name="EndDate"><Value>=Parameters!EndDate.Value</Value></Parameter></Parameters></Drillthrough></Action><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox5</DefaultName><ZIndex>6</ZIndex><Value>=Fields!BlockedInstance.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox7"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Right>Solid</Right><Top>Solid</Top><Bottom>Solid</Bottom></BorderStyle><BackgroundColor>GhostWhite</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox7</DefaultName><ZIndex>5</ZIndex><Value /><CanGrow>true</CanGrow></Textbox></ReportItems><ColSpan>4</ColSpan></TableCell></TableCells><Height>0.25in</Height></TableRow></TableRows></Header></TableGroup></TableGroups><Details><TableRows><TableRow><TableCells><TableCell><ReportItems><Textbox Name="BlockedInstance"><Style><BorderColor><Default>LightGrey</Default></BorderColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">BlockedInstance</DefaultName><ZIndex>4</ZIndex><Value /><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="BlockedDB"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextDecoration>Underline</TextDecoration><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><Action><Drillthrough><ReportName>SQL Server Block Analysis Detail</ReportName><Parameters><Parameter Name="Computer"><Value>=Fields!Server.Value</Value></Parameter><Parameter Name="Instance"><Value>=Fields!BlockedInstance.Value</Value></Parameter><Parameter Name="Database"><Value>=Fields!BlockedDB.Value</Value></Parameter><Parameter Name="Program"><Value>=Fields!ProgramName.Value</Value></Parameter><Parameter Name="BeginDate"><Value>=Parameters!BeginDate.Value</Value></Parameter><Parameter Name="EndDate"><Value>=Parameters!EndDate.Value</Value></Parameter></Parameters></Drillthrough></Action><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">BlockedDB</DefaultName><ZIndex>3</ZIndex><Value>=Fields!BlockedDB.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Instance"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextDecoration>Underline</TextDecoration><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><Action><Drillthrough><ReportName>SQL Server Block Analysis Detail</ReportName><Parameters><Parameter Name="Computer"><Value>=Fields!Server.Value</Value></Parameter><Parameter Name="Instance"><Value>=Fields!BlockedInstance.Value</Value></Parameter><Parameter Name="Database"><Value>=Fields!BlockedDB.Value</Value></Parameter><Parameter Name="Program"><Value>=Fields!ProgramName.Value</Value></Parameter><Parameter Name="BeginDate"><Value>=Parameters!BeginDate.Value</Value></Parameter><Parameter Name="EndDate"><Value>=Parameters!EndDate.Value</Value></Parameter></Parameters></Drillthrough></Action><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Instance</DefaultName><ZIndex>2</ZIndex><Value>=Fields!ProgramName.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="TotalBlocks"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><Action><Drillthrough><ReportName>SQL Server Block Analysis Detail</ReportName><Parameters><Parameter Name="Computer"><Value>=Fields!Server.Value</Value></Parameter><Parameter Name="Instance"><Value>=Fields!BlockedInstance.Value</Value></Parameter></Parameters></Drillthrough></Action><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">TotalBlocks</DefaultName><ZIndex>1</ZIndex><Value>=Fields!TotalBlocks.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="AvgBlockTime"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">AvgBlockTime</DefaultName><Value>=Fields!AvgBlockTime.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow></TableRows><Sorting><SortBy><SortExpression>=iif(Parameters!SortDirection.Value="Ascending",Fields(Parameters!SortBy.Value).Value,0) </SortExpression><Direction>Ascending</Direction></SortBy><SortBy><SortExpression>=iif(Parameters!SortDirection.Value="Descending",Fields(Parameters!SortBy.Value).Value,0) </SortExpression><Direction>Descending</Direction></SortBy></Sorting></Details></Table></ReportItems><Style><BorderWidth><Default>0.5pt</Default></BorderWidth></Style><Height>11in</Height><ColumnSpacing>0.25in</ColumnSpacing></Body><TopMargin>1in</TopMargin><DataSources><DataSource Name="SCDW"><rd:DataSourceID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">fb44cba7-75a7-4314-b2a5-1fce44701d23</rd:DataSourceID><DataSourceReference>SCDW</DataSourceReference></DataSource></DataSources><Code>public function CurrentTimeZone() as string 
	CurrentTimeZone = System.TimeZone.CurrentTimeZone.StandardName
end function

public function FormatNumber(fieldValue, formatString) as string 
	if (fieldValue is Nothing)
		FormatNumber = "Not Available"
	else
		FormatNumber = Format(fieldValue,formatString)
	end if
end function
</Code><Width>11in</Width><DataSets><DataSet Name="ComputerList"><Fields><Field Name="Computer"><DataField>Computer</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="ComputerID"><DataField>ComputerID</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Guid</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT DISTINCT SourceClassInstanceKeyValue AS Computer, SourceClassInstanceID AS ComputerID
FROM         [SC_Class_Rel_Computer-SQLInstance_View]
ORDER BY SourceClassInstanceKeyValue</CommandText><Timeout>0</Timeout><UseGenericDesigner xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</UseGenericDesigner></Query></DataSet><DataSet Name="BlockedAnalysis"><Fields><Field Name="Server"><DataField>Server</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="ProgramName"><DataField>ProgramName</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="BlockedDB"><DataField>BlockedDB</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="BlockedInstance"><DataField>BlockedInstance</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="TotalBlocks"><DataField>TotalBlocks</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Int32</TypeName></Field><Field Name="AvgBlockTime"><DataField>AvgBlockTime</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Int32</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandType>StoredProcedure</CommandType><CommandText>p_SQLBlockAnalysisReport</CommandText><QueryParameters><QueryParameter Name="@Computer"><Value>=Parameters!Computer.Value</Value></QueryParameter><QueryParameter Name="@BeginDate"><Value>=Parameters!BeginDate.Value</Value></QueryParameter><QueryParameter Name="@EndDate"><Value>=Parameters!EndDate.Value</Value></QueryParameter></QueryParameters><Timeout>90000000</Timeout></Query></DataSet><DataSet Name="CurrentDate"><Fields><Field Name="BeginDate"><DataField>BeginDate</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field><Field Name="EndDate"><DataField>EndDate</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT     *
FROM         fn_GetDateRange(7) fn_GetDateRange</CommandText><Timeout>30000000</Timeout><UseGenericDesigner xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</UseGenericDesigner></Query></DataSet></DataSets><LeftMargin>1in</LeftMargin><rd:SnapToGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:SnapToGrid><rd:DrawGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:DrawGrid><Description /><PageWidth>13in</PageWidth><rd:ReportID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">212d782b-9718-4b8d-a1c1-2bd72afd7b82</rd:ReportID><PageFooter><ReportItems><Textbox Name="textboxPageNumber_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.2in</Top><Height>0.25in</Height><Value>="Page " &amp; Globals.PageNumber &amp; "/" &amp; Globals.TotalPages</Value><Left>4in</Left></Textbox><Textbox Name="textbox1DateTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><Top>0.2in</Top><Height>0.25in</Height><Width>4in</Width><Value>="All dates and  times shown in " &amp; Code.CurrentTimeZone()</Value></Textbox></ReportItems><PrintOnLastPage>true</PrintOnLastPage><PrintOnFirstPage>true</PrintOnFirstPage><Style /><Height>0.5in</Height></PageFooter><BottomMargin>1in</BottomMargin><ReportParameters><ReportParameter Name="BeginDate"><DataType>DateTime</DataType><DefaultValue><DataSetReference><DataSetName>CurrentDate</DataSetName><ValueField>BeginDate</ValueField></DataSetReference></DefaultValue><Prompt>Begin Date</Prompt></ReportParameter><ReportParameter Name="EndDate"><DataType>DateTime</DataType><DefaultValue><DataSetReference><DataSetName>CurrentDate</DataSetName><ValueField>EndDate</ValueField></DataSetReference></DefaultValue><Prompt>End Date</Prompt></ReportParameter><ReportParameter Name="Computer"><DataType>String</DataType><Prompt>Server </Prompt><ValidValues><DataSetReference><DataSetName>ComputerList</DataSetName><ValueField>Computer</ValueField><LabelField>Computer</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="SortBy"><DataType>String</DataType><DefaultValue><Values><Value>BlockedDB</Value></Values></DefaultValue><Prompt>Sort By</Prompt><ValidValues><ParameterValues><ParameterValue><Value>Instance</Value><Label>Instance Name</Label></ParameterValue><ParameterValue><Value>BlockedDB</Value><Label>Database Name</Label></ParameterValue><ParameterValue><Value>ProgramName</Value><Label>Program Name</Label></ParameterValue><ParameterValue><Value>TotalBlocks</Value><Label># Blocks</Label></ParameterValue><ParameterValue><Value>AvgBlockTime</Value><Label>Average Block Time</Label></ParameterValue></ParameterValues></ValidValues></ReportParameter><ReportParameter Name="SortDirection"><DataType>String</DataType><DefaultValue><Values><Value>Ascending</Value></Values></DefaultValue><Prompt>Sort Order</Prompt><ValidValues><ParameterValues><ParameterValue><Value>Ascending</Value></ParameterValue><ParameterValue><Value>Descending</Value></ParameterValue></ParameterValues></ValidValues></ReportParameter></ReportParameters></Report>]]></ReportDefinition>
  </ReportItem>
  <ReportItem>
    <Name>SQL Server Block Analysis Detail</Name>
    <Type>Report</Type>
    <Path>/Microsoft Operations Manager Reporting/Microsoft SQL Server/SQL Server Block Analysis Detail</Path>
    <ReportDefinition><![CDATA[<?xml version='1.0' encoding='utf-8'?><Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"><rd:GridSpacing xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">0.05in</rd:GridSpacing><RightMargin>1in</RightMargin><Body><ReportItems><Textbox Name="textboxRightLogo"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/2Inch_Logo.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>6</ZIndex><Height>0.5625in</Height><Value /><Left>9in</Left></Textbox><Textbox Name="textboxReportTitle_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/9Inch_Banner.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>5</ZIndex><Height>0.5625in</Height><Width>9in</Width><CanGrow>true</CanGrow><Value>SQL Server Block Analysis Detail</Value></Textbox><Textbox Name="textboxExecutionTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>4</ZIndex><Top>0.5625in</Top><Height>0.25in</Height><Value>=Globals.ExecutionTime</Value><Left>9in</Left></Textbox><Textbox Name="textboxParameterValue_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.375in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>= Parameters!Computer.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterValue_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.25in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>=Parameters!BeginDate.Value &amp; " - " &amp; Parameters!EndDate.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterName_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.375in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>Server :</Value></Textbox><Textbox Name="textboxParameterName_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.25in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>Date Range :</Value></Textbox><Textbox Name="textboxDescription_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>GhostWhite</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.8125in</Top><ToggleImage><InitialState>true</InitialState></ToggleImage><Height>0.375in</Height><Visibility><ToggleItem>textboxDescriptionHeading_tmp</ToggleItem><Hidden>true</Hidden></Visibility><CanGrow>true</CanGrow><Value>= "This report displays SQL Server block analysis by displaying alert data from historical SQL Server block situations.  This report displays blocking statistics including blocked applications, users and average wait time."  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "Note - this report displays a snap shot of blocking alerts for a point in time.  If you have blocking conditions which continued after an alert was raised, the initial blocking value will be displayed." </Value></Textbox><Textbox Name="textboxDescriptionHeading_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><Top>0.5625in</Top><Height>0.25in</Height><Width>9in</Width><CanGrow>true</CanGrow><Value>Description</Value></Textbox><Table Name="table1"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle></Style><Top>1.75in</Top><Height>1in</Height><ZIndex>2</ZIndex><NoRows>= "There is no data available for this report. This can occur when there is no relevant data available for collection, the reports’ dependent rules are not enabled or when none of the relevant data has been copied to the Reporting database." </NoRows><DataSetName>BlockedAnalysis</DataSetName><TableColumns><TableColumn><Width>1.875in</Width></TableColumn><TableColumn><Width>1.5in</Width></TableColumn><TableColumn><Width>1.375in</Width></TableColumn><TableColumn><Width>1.5in</Width></TableColumn><TableColumn><Width>0.75in</Width></TableColumn><TableColumn><Width>1.375in</Width></TableColumn><TableColumn><Width>1.125in</Width></TableColumn><TableColumn><Width>0.75in</Width></TableColumn><TableColumn><Width>0.75in</Width></TableColumn></TableColumns><Header><TableRows><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox11"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox11</DefaultName><ZIndex>19</ZIndex><Value>Instance Name </Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Server"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><TextAlign>Left</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Server</DefaultName><ZIndex>18</ZIndex><Value>Date</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox4"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox4</DefaultName><ZIndex>17</ZIndex><Value>Database Name</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox2"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox2</DefaultName><ZIndex>16</ZIndex><Value>Program Name</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox3"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><TextAlign>Right</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox3</DefaultName><ZIndex>15</ZIndex><Value>Blocked Duration(Minutes)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox1"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox1</DefaultName><ZIndex>14</ZIndex><Value>Login Name</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox6"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox6</DefaultName><ZIndex>13</ZIndex><Value>Resource</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox5"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><TextAlign>Right</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox5</DefaultName><ZIndex>12</ZIndex><Value>Blocked SPID</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox8"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><TextAlign>Right</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox8</DefaultName><ZIndex>11</ZIndex><Value>Blocking SPID</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.5in</Height></TableRow></TableRows><RepeatOnNewPage>true</RepeatOnNewPage></Header><TableGroups><TableGroup><Grouping Name="table1_Group1"><GroupExpressions><GroupExpression>=Fields!BlockedInstance.Value</GroupExpression></GroupExpressions></Grouping><Header><TableRows><TableRow><TableCells><TableCell><ReportItems><Textbox Name="BlockedInstance"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Left>Solid</Left><Top>Solid</Top><Bottom>Solid</Bottom></BorderStyle><BackgroundColor>GhostWhite</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">BlockedInstance</DefaultName><ZIndex>10</ZIndex><Value>=Fields!BlockedInstance.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox15"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Right>Solid</Right><Top>Solid</Top><Bottom>Solid</Bottom></BorderStyle><BackgroundColor>GhostWhite</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox15</DefaultName><ZIndex>9</ZIndex><Value /><CanGrow>true</CanGrow></Textbox></ReportItems><ColSpan>8</ColSpan></TableCell></TableCells><Height>0.25in</Height></TableRow></TableRows></Header></TableGroup></TableGroups><Details><TableRows><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox13"><Style><BorderColor><Default>LightGrey</Default></BorderColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox13</DefaultName><ZIndex>8</ZIndex><Value /><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="LocalDateTimeRaised"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">LocalDateTimeRaised</DefaultName><ZIndex>7</ZIndex><Value>=Fields!LocalDateTimeRaised.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox7"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox7</DefaultName><ZIndex>6</ZIndex><Value>=Fields!BlockedDB.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Instance"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Instance</DefaultName><ZIndex>5</ZIndex><Value>=Fields!ProgramName.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="BlockedDuration"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">BlockedDuration</DefaultName><ZIndex>4</ZIndex><Value>=Fields!BlockedDuration.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="LoginName"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">LoginName</DefaultName><ZIndex>3</ZIndex><Value>=Fields!LoginName.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="ResourceGUID"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">ResourceGUID</DefaultName><ZIndex>2</ZIndex><Value>=Fields!ResourceGUID.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="BlockedSPID"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">BlockedSPID</DefaultName><ZIndex>1</ZIndex><Value>=Fields!BlockedSPID.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="BlockedbySPID"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">BlockedbySPID</DefaultName><Value>=Fields!BlockedbySPID.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow></TableRows><Sorting><SortBy><SortExpression>=iif(Parameters!SortDirection.Value="Ascending",Fields(Parameters!SortBy.Value).Value,0) </SortExpression><Direction>Ascending</Direction></SortBy><SortBy><SortExpression>=iif(Parameters!SortDirection.Value="Descending",Fields(Parameters!SortBy.Value).Value,0) </SortExpression><Direction>Descending</Direction></SortBy></Sorting></Details></Table></ReportItems><Style><BorderWidth><Default>0.5pt</Default></BorderWidth></Style><Height>11in</Height><ColumnSpacing>0.25in</ColumnSpacing></Body><TopMargin>1in</TopMargin><DataSources><DataSource Name="SCDW"><rd:DataSourceID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">fb44cba7-75a7-4314-b2a5-1fce44701d23</rd:DataSourceID><DataSourceReference>SCDW</DataSourceReference></DataSource></DataSources><Code>public function CurrentTimeZone() as string 
	CurrentTimeZone = System.TimeZone.CurrentTimeZone.StandardName
end function

public function FormatNumber(fieldValue, formatString) as string 
	if (fieldValue is Nothing)
		FormatNumber = "Not Available"
	else
		FormatNumber = Format(fieldValue,formatString)
	end if
end function
</Code><Width>11in</Width><DataSets><DataSet Name="ComputerList"><Fields><Field Name="Computer"><DataField>Computer</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="ComputerID"><DataField>ComputerID</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Guid</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT DISTINCT SourceClassInstanceKeyValue AS Computer, SourceClassInstanceID AS ComputerID
FROM         [SC_Class_Rel_Computer-SQLInstance_View]
ORDER BY SourceClassInstanceKeyValue</CommandText><Timeout>0</Timeout><UseGenericDesigner xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</UseGenericDesigner></Query></DataSet><DataSet Name="SQLInstance"><Fields><Field Name="Instance"><DataField>Instance</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="TargetClassInstanceID"><DataField>TargetClassInstanceID</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Guid</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT DISTINCT TargetClassInstanceKeyValue AS [Instance],TargetClassInstanceID
FROM         [SC_Class_Rel_Computer-SQLInstance_View]
WHERE     (SourceClassInstanceKeyValue = @Computer)
order by TargetClassInstanceKeyValue</CommandText><QueryParameters><QueryParameter Name="@Computer"><Value>=Parameters!Computer.Value</Value></QueryParameter></QueryParameters><Timeout>300000000</Timeout><UseGenericDesigner xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</UseGenericDesigner></Query></DataSet><DataSet Name="BlockedApplication"><Fields><Field Name="Program"><DataField>Program</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>Select '&lt;ALL&gt;' as Program
union
Select 	Distinct substring(AF.AlertDescription,CHARINDEX('The program ',AF.AlertDescription)+13,case when CHARINDEX(' has been blocked',AF.AlertDescription)-CHARINDEX('The program ',AF.AlertDescription)-14 &gt; 0 then CHARINDEX(' has been blocked',AF.AlertDescription)-CHARINDEX('The program ',AF.AlertDescription)-14 else 10 end ) as ProgramName
from 
	dbo.SC_AlertFact_View AF 
where   AF.AlertName Like 'SQL Server 2000 Block Analysis%' and AF.AlertDescription Like 'The Program%'</CommandText><Timeout>3000000</Timeout><UseGenericDesigner xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</UseGenericDesigner></Query></DataSet><DataSet Name="BlockedDatabase"><Fields><Field Name="Database"><DataField>Database</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>Select '&lt;ALL&gt;' as [Database]
union
Select 	Distinct 
	substring(AF.AlertDescription,CHARINDEX('database',AF.AlertDescription)+9,

case when CHARINDEX('in the SQL',AF.AlertDescription)-CHARINDEX('database',AF.AlertDescription)-9 &gt; 0 then CHARINDEX('in the SQL',AF.AlertDescription)-CHARINDEX('database',AF.AlertDescription)-9 else 10 end ) as BlockedDB
	
from 
	dbo.SC_AlertFact_View AF 
where   AF.AlertName Like 'SQL Server 2000 Block Analysis%' and AF.AlertDescription Like 'The Program%'</CommandText><Timeout>30000000</Timeout><UseGenericDesigner xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</UseGenericDesigner></Query></DataSet><DataSet Name="BlockedAnalysis"><Fields><Field Name="Server"><DataField>Server</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="LocalDateTimeRaised"><DataField>LocalDateTimeRaised</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field><Field Name="ProgramName"><DataField>ProgramName</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="BlockedDB"><DataField>BlockedDB</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="BlockedInstance"><DataField>BlockedInstance</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="BlockedDuration"><DataField>BlockedDuration</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Int32</TypeName></Field><Field Name="LoginName"><DataField>LoginName</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="BlockedSPID"><DataField>BlockedSPID</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="BlockedbySPID"><DataField>BlockedbySPID</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="ResourceGUID"><DataField>ResourceGUID</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandType>StoredProcedure</CommandType><CommandText>p_SQLBlockAnalysisDetailReport</CommandText><QueryParameters><QueryParameter Name="@Computer"><Value>=Parameters!Computer.Value</Value></QueryParameter><QueryParameter Name="@Program"><Value>=Parameters!Program.Value</Value></QueryParameter><QueryParameter Name="@Instance"><Value>=Parameters!Instance.Value</Value></QueryParameter><QueryParameter Name="@Database"><Value>=Parameters!Database.Value</Value></QueryParameter><QueryParameter Name="@BeginDate"><Value>=Parameters!BeginDate.Value</Value></QueryParameter><QueryParameter Name="@EndDate"><Value>=Parameters!EndDate.Value</Value></QueryParameter></QueryParameters><Timeout>90000000</Timeout></Query></DataSet><DataSet Name="CurrentDate"><Fields><Field Name="BeginDate"><DataField>BeginDate</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field><Field Name="EndDate"><DataField>EndDate</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT     *
FROM         fn_GetDateRange(7) fn_GetDateRange</CommandText><Timeout>30000000</Timeout><UseGenericDesigner xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</UseGenericDesigner></Query></DataSet></DataSets><LeftMargin>1in</LeftMargin><rd:SnapToGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:SnapToGrid><rd:DrawGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:DrawGrid><Description /><PageWidth>13in</PageWidth><rd:ReportID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">212d782b-9718-4b8d-a1c1-2bd72afd7b82</rd:ReportID><PageFooter><ReportItems><Textbox Name="textboxPageNumber_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.2in</Top><Height>0.25in</Height><Value>="Page " &amp; Globals.PageNumber &amp; "/" &amp; Globals.TotalPages</Value><Left>4in</Left></Textbox><Textbox Name="textbox1DateTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><Top>0.2in</Top><Height>0.25in</Height><Width>4in</Width><Value>="All dates and  times shown in " &amp; Code.CurrentTimeZone()</Value></Textbox></ReportItems><PrintOnLastPage>true</PrintOnLastPage><PrintOnFirstPage>true</PrintOnFirstPage><Style /><Height>0.5in</Height></PageFooter><BottomMargin>1in</BottomMargin><ReportParameters><ReportParameter Name="BeginDate"><DataType>DateTime</DataType><DefaultValue><DataSetReference><DataSetName>CurrentDate</DataSetName><ValueField>BeginDate</ValueField></DataSetReference></DefaultValue><AllowBlank>true</AllowBlank><Prompt>Begin Date</Prompt></ReportParameter><ReportParameter Name="EndDate"><DataType>DateTime</DataType><DefaultValue><DataSetReference><DataSetName>CurrentDate</DataSetName><ValueField>EndDate</ValueField></DataSetReference></DefaultValue><AllowBlank>true</AllowBlank><Prompt>End Date</Prompt></ReportParameter><ReportParameter Name="Computer"><DataType>String</DataType><Prompt>Server </Prompt><ValidValues><DataSetReference><DataSetName>ComputerList</DataSetName><ValueField>Computer</ValueField><LabelField>Computer</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="Instance"><DataType>String</DataType><DefaultValue><DataSetReference><DataSetName>SQLInstance</DataSetName><ValueField>Instance</ValueField></DataSetReference></DefaultValue><Prompt>Instance</Prompt><ValidValues><DataSetReference><DataSetName>SQLInstance</DataSetName><ValueField>Instance</ValueField><LabelField>Instance</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="Database"><DataType>String</DataType><DefaultValue><DataSetReference><DataSetName>BlockedDatabase</DataSetName><ValueField>Database</ValueField></DataSetReference></DefaultValue><Prompt>Database</Prompt><ValidValues><DataSetReference><DataSetName>BlockedDatabase</DataSetName><ValueField>Database</ValueField><LabelField>Database</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="Program"><DataType>String</DataType><DefaultValue><Values><Value>&lt;ALL&gt;</Value></Values></DefaultValue><Prompt>Application Name</Prompt><ValidValues><DataSetReference><DataSetName>BlockedApplication</DataSetName><ValueField>Program</ValueField><LabelField>Program</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="SortBy"><DataType>String</DataType><DefaultValue><Values><Value>BlockedDB</Value></Values></DefaultValue><Prompt>Sort By</Prompt><ValidValues><ParameterValues><ParameterValue><Value>Instance</Value><Label>Instance Name</Label></ParameterValue><ParameterValue><Value>BlockedDB</Value><Label>Database Name</Label></ParameterValue><ParameterValue><Value>ProgramName</Value><Label>Program Name</Label></ParameterValue><ParameterValue><Value>BlockedDuration</Value><Label>Blocked Duration</Label></ParameterValue><ParameterValue><Value>LoginName</Value><Label>Login Name</Label></ParameterValue><ParameterValue><Value>ResourceGUID</Value><Label>Resource</Label></ParameterValue><ParameterValue><Value>BlockedSPID</Value><Label>Blocked SPID</Label></ParameterValue><ParameterValue><Value>BlockingSPID</Value><Label>Blocking SPID</Label></ParameterValue></ParameterValues></ValidValues></ReportParameter><ReportParameter Name="SortDirection"><DataType>String</DataType><DefaultValue><Values><Value>Ascending</Value></Values></DefaultValue><Prompt>Sort Order</Prompt><ValidValues><ParameterValues><ParameterValue><Value>Ascending</Value></ParameterValue><ParameterValue><Value>Descending</Value></ParameterValue></ParameterValues></ValidValues></ReportParameter></ReportParameters></Report>]]></ReportDefinition>
  </ReportItem>
  <ReportItem>
    <Name>SQL Server Configuration</Name>
    <Type>Report</Type>
    <Path>/Microsoft Operations Manager Reporting/Microsoft SQL Server/SQL Server Configuration</Path>
    <ReportDefinition><![CDATA[<?xml version='1.0' encoding='utf-8'?><Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"><rd:GridSpacing xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">0.05in</rd:GridSpacing><RightMargin>1in</RightMargin><Body><ReportItems><Textbox Name="textboxRightLogo"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/2Inch_Logo.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>6</ZIndex><Height>0.5625in</Height><Value /><Left>9in</Left></Textbox><Textbox Name="textboxReportTitle_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/9Inch_Banner.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>5</ZIndex><Height>0.5625in</Height><Width>9in</Width><CanGrow>true</CanGrow><Value>SQL Server Configuration</Value></Textbox><Textbox Name="textboxExecutionTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>4</ZIndex><Top>0.5625in</Top><Height>0.25in</Height><Value>=Globals.ExecutionTime</Value><Left>9in</Left></Textbox><Textbox Name="textboxParameterValue_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.375in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>=Parameters!InstanceID.Label</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterValue_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.25in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>=Parameters!Computer.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterName_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.375in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>SQL Instance :</Value></Textbox><Textbox Name="textboxParameterName_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.25in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>Server :</Value></Textbox><Textbox Name="textboxDescription_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>GhostWhite</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.8125in</Top><ToggleImage><InitialState>true</InitialState></ToggleImage><Height>0.375in</Height><Visibility><ToggleItem>textboxDescriptionHeading_tmp</ToggleItem><Hidden>true</Hidden></Visibility><CanGrow>true</CanGrow><Value>= "This report displays the configuration of SQL Server instances installed on a specified server."  &amp; VbCrLf &amp;  "The rule is dependent on SQL Server service discovery."  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "The following rule needs to be enabled and running successfully for service discovery data to be collected:"  &amp; VbCrLf &amp;  "–         SQL Server 2000 Service Discovery"  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "" </Value></Textbox><Textbox Name="textboxDescriptionHeading_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><Top>0.5625in</Top><Height>0.25in</Height><Width>9in</Width><CanGrow>true</CanGrow><Value>Description</Value></Textbox><Table Name="table2"><Style /><Top>1.75in</Top><Height>3.5in</Height><Width>9.125in</Width><ZIndex>9</ZIndex><NoRows>= "There is no data available for this report. This can occur when there is no relevant data available for collection, the reports’ dependent rules are not enabled or when none of the relevant data has been copied to the Reporting database." </NoRows><DataSetName>SQLInstanceAttributes</DataSetName><TableColumns><TableColumn><Width>3.65in</Width></TableColumn><TableColumn><Width>5.475in</Width></TableColumn></TableColumns><Header><TableRows><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox7"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox7</DefaultName><ZIndex>27</ZIndex><Value>SQL Server Property</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox11"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox11</DefaultName><ZIndex>26</ZIndex><Value>Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox17"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox17</DefaultName><ZIndex>25</ZIndex><Value>Version</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Version_1"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Version_1</DefaultName><ZIndex>24</ZIndex><Value>=First(Fields!Version.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox18"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox18</DefaultName><ZIndex>23</ZIndex><Value>Service Pack Level</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Service_Pack_Level"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Service_Pack_Level</DefaultName><ZIndex>22</ZIndex><Value>=First(Fields!Service_Pack_Level.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox20"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox20</DefaultName><ZIndex>21</ZIndex><Value>Language</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Language"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Language</DefaultName><ZIndex>20</ZIndex><Value>=First(Fields!Language.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox22"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox22</DefaultName><ZIndex>19</ZIndex><Value>Authentication Mode</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Authentication_Mode"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Authentication_Mode</DefaultName><ZIndex>18</ZIndex><Value>=First(Fields!Authentication_Mode.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox19"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox19</DefaultName><ZIndex>17</ZIndex><Value>Clustered</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Clustered"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Clustered</DefaultName><ZIndex>16</ZIndex><Value>=First(Fields!Clustered.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox29"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox29</DefaultName><ZIndex>15</ZIndex><Value>Master Database Location</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Master_Database_Location"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Master_Database_Location</DefaultName><ZIndex>14</ZIndex><Value>=First(Fields!Master_Database_Location.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox32"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox32</DefaultName><ZIndex>13</ZIndex><Value>Master Database Log Location</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Master_Database_Log_Location"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Master_Database_Log_Location</DefaultName><ZIndex>12</ZIndex><Value>=First(Fields!Master_Database_Log_Location.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox21"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox21</DefaultName><ZIndex>11</ZIndex><Value>Error Log Location</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Error_Log_Location"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Error_Log_Location</DefaultName><ZIndex>10</ZIndex><Value>=First(Fields!Error_Log_Location.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox26"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox26</DefaultName><ZIndex>9</ZIndex><Value>Audit Level</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Audit_Level"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Audit_Level</DefaultName><ZIndex>8</ZIndex><Value>=First(Fields!Audit_Level.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox36"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox36</DefaultName><ZIndex>7</ZIndex><Value>Enable Error Reporting</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Enable_Error_Logging"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Enable_Error_Logging</DefaultName><ZIndex>6</ZIndex><Value>=First(Fields!Enable_Error_Reporting.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox24"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox24</DefaultName><ZIndex>5</ZIndex><Value>Replication Installed</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Replication_Enabled"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Replication_Enabled</DefaultName><ZIndex>4</ZIndex><Value>=First(Fields!Replication_Enabled.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox40"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox40</DefaultName><ZIndex>3</ZIndex><Value>Replication Working Directory</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Replication_Working_Directory"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Replication_Working_Directory</DefaultName><ZIndex>2</ZIndex><Value>=First(Fields!Replication_Working_Directory.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox38"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox38</DefaultName><ZIndex>1</ZIndex><Value>Replication Distribution Database</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Replication_Distribution_Database"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Replication_Distribution_Database</DefaultName><Value>=First(Fields!Replication_Distribution_Database.Value)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow></TableRows><RepeatOnNewPage>true</RepeatOnNewPage></Header></Table><Table Name="table3"><Style /><Top>5.625in</Top><Height>0.5in</Height><Width>9in</Width><ZIndex>10</ZIndex><DataSetName>SQLDatabase</DataSetName><TableColumns><TableColumn><Width>3.625in</Width></TableColumn><TableColumn><Width>1in</Width></TableColumn><TableColumn><Width>1in</Width></TableColumn><TableColumn><Width>1in</Width></TableColumn><TableColumn><Width>1in</Width></TableColumn><TableColumn><Width>1.375in</Width></TableColumn></TableColumns><Header><TableRows><TableRow><TableCells><TableCell><ReportItems><Textbox Name="textbox58"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><TextAlign>Center</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><ZIndex>11</ZIndex><Value>Databases</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox59"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><TextAlign>Center</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><ZIndex>10</ZIndex><Value>DB Size(MB)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox60"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><TextAlign>Center</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><ZIndex>9</ZIndex><Value>Autogrow(DB)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox61"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><TextAlign>Center</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><ZIndex>8</ZIndex><Value>DB Log Size(MB)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox62"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><TextAlign>Center</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><ZIndex>7</ZIndex><Value>Autogrow (LOG)</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox63"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><TextAlign>Center</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><ZIndex>6</ZIndex><Value>Recovery Model</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow></TableRows></Header><Details><TableRows><TableRow><TableCells><TableCell><ReportItems><Textbox Name="SQLDatabase"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">SQLDatabase</DefaultName><ZIndex>5</ZIndex><Value>=Fields!SQLDatabase.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Database_Size"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextAlign>Center</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Database_Size</DefaultName><ZIndex>4</ZIndex><Value>=Fields!Database_Size.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Database_Autogrow"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextAlign>Center</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Database_Autogrow</DefaultName><ZIndex>3</ZIndex><Value>=Fields!Database_Autogrow.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Log_Size"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextAlign>Center</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Log_Size</DefaultName><ZIndex>2</ZIndex><Value>=Format(Fields!Log_Size.Value,"######0.00")</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Log_Autogrow"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextAlign>Center</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Log_Autogrow</DefaultName><ZIndex>1</ZIndex><Value>=Fields!Database_Autogrow.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Recovery_Model"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><TextAlign>Center</TextAlign><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Recovery_Model</DefaultName><Value>=Fields!Recovery_Model.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow></TableRows><Sorting><SortBy><SortExpression>=iif(Parameters!Direction.Value="Ascending",Fields(Parameters!SortBy.Value).Value,0) </SortExpression><Direction>Ascending</Direction></SortBy><SortBy><SortExpression>=iif(Parameters!Direction.Value="Descending",Fields(Parameters!SortBy.Value).Value,0)</SortExpression><Direction>Descending</Direction></SortBy></Sorting></Details></Table></ReportItems><Style><BorderWidth><Default>0.5pt</Default></BorderWidth></Style><Height>11in</Height><ColumnSpacing>0.25in</ColumnSpacing></Body><TopMargin>1in</TopMargin><DataSources><DataSource Name="SCDW"><rd:DataSourceID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">fb44cba7-75a7-4314-b2a5-1fce44701d23</rd:DataSourceID><DataSourceReference>SCDW</DataSourceReference></DataSource></DataSources><Code>public function CurrentTimeZone() as string 
	CurrentTimeZone = System.TimeZone.CurrentTimeZone.StandardName
end function

public function FormatNumber(fieldValue, formatString) as string 
	if (fieldValue is Nothing)
		FormatNumber = "Not Available"
	else
		FormatNumber = Format(fieldValue,formatString)
	end if
end function
</Code><Width>11in</Width><DataSets><DataSet Name="ComputerList"><Fields><Field Name="Computer"><DataField>Computer</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="ComputerID"><DataField>ComputerID</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Guid</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT DISTINCT SourceClassInstanceKeyValue AS Computer, SourceClassInstanceID AS ComputerID
FROM         [SC_Class_Rel_Computer-SQLInstance_View]
ORDER BY SourceClassInstanceKeyValue</CommandText><Timeout>0</Timeout></Query></DataSet><DataSet Name="SQLDatabase"><Fields><Field Name="DatabaseID"><DataField>DatabaseID</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Guid</TypeName></Field><Field Name="SQLDatabase"><DataField>SQLDatabase</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Database_Size"><DataField>Database Size</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Int32</TypeName></Field><Field Name="Database_Autogrow"><DataField>Database Autogrow</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Log_Size"><DataField>Log Size</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Double</TypeName></Field><Field Name="Log_Autogrow"><DataField>Log Autogrow</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Last_Updated_Time"><DataField>Last Updated Time</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field><Field Name="Recovery_Model"><DataField>Recovery Model</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT     C_DB.ClassInstanceID AS DatabaseID, C_DB.[Database Name] AS SQLDatabase, CAST(C_DB.[Database Size] AS integer) AS [Database Size], 
                      C_DB.[Database Autogrow] AS [Database Autogrow], CAST(C_DB.[Log Size] AS Float) AS [Log Size], C_DB.[Log Autogrow] AS [Log Autogrow], 
                      dbo.fn_ConvertToLocalDate(C_DB.[Last Updated Time]) AS [Last Updated Time], C_DB.[Recovery Model] AS [Recovery Model]
FROM         SC_Class_SQLDatabase_View C_DB INNER JOIN
                      [SC_Class_Rel_SQL-SQLDatabase_View] R_SDB ON R_SDB.TargetClassInstanceID = C_DB.ClassInstanceID
WHERE     (R_SDB.SourceClassInstanceID LIKE @InstanceID)
ORDER BY CAST(C_DB.[Database Size] AS integer)</CommandText><QueryParameters><QueryParameter Name="@InstanceID"><Value>=Parameters!InstanceID.Value</Value></QueryParameter></QueryParameters><Timeout>3000000</Timeout></Query></DataSet><DataSet Name="SQLInstanceAttributes"><Fields><Field Name="Server"><DataField>Server</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="SQLInstance"><DataField>SQLInstance</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Version"><DataField>Version</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Service_Pack_Level"><DataField>Service Pack Level</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Language"><DataField>Language</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Authentication_Mode"><DataField>Authentication Mode</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Clustered"><DataField>Clustered</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Cluster_VIP"><DataField>Cluster VIP</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Master_Database_Location"><DataField>Master Database Location</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Master_Database_Log_Location"><DataField>Master Database Log Location</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Error_Log_Location"><DataField>Error Log Location</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Audit_Level"><DataField>Audit Level</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Enable_Error_Reporting"><DataField>Enable Error Reporting</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Replication_Enabled"><DataField>Replication Enabled</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Replication_Working_Directory"><DataField>Replication Working Directory</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Replication_Distribution_Database"><DataField>Replication Distribution Database</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT     CD.FullComputerName AS Server, C_SQL.[SQL Server Instance Name] AS SQLInstance, C_SQL.[SQL Server Version] AS Version, 
                      C_SQL.[Service Pack Version] AS [Service Pack Level], C_SQL.Language AS Language, C_SQL.[Authentication Mode] AS [Authentication Mode], 
                      C_SQL.Cluster AS [Clustered], C_CLS.VIP AS [Cluster VIP], C_SQL.[Master Database Location] AS [Master Database Location], 
                      C_SQL.[Master Database Log Location] AS [Master Database Log Location], C_SQL.[Error Log Location] AS [Error Log Location], 
                      C_SQL.[Audit Level] AS [Audit Level], C_SQL.[Enable Error Reporting] AS [Enable Error Reporting], C_SQL.[Replication] AS [Replication Enabled], 
                      C_SQL.[Replication Working Directory] AS [Replication Working Directory], 
                      C_SQL.[Replication Distribution Database] AS [Replication Distribution Database]
FROM         SC_Class_SQL_View C_SQL INNER JOIN
                      [SC_Class_Rel_Computer-SQLInstance_View] R_CSQL ON R_CSQL.TargetClassInstanceID = C_SQL.ClassInstanceID INNER JOIN
                      SC_ComputerDimension_View CD ON CD.ComputerID = R_CSQL.SourceClassInstanceID LEFT OUTER JOIN
                      [SC_Class_Rel_SQLCluster-SQL_View] R_ClsSQL ON R_ClsSQL.TargetClassInstanceID = C_SQL.ClassInstanceID LEFT OUTER JOIN
                      SC_Class_SQLCluster_View C_CLS ON C_CLS.ClassInstanceID = R_ClsSQL.SourceClassInstanceID
WHERE     (R_CSQL.TargetClassInstanceID = @InstanceID)</CommandText><QueryParameters><QueryParameter Name="@InstanceID"><Value>=Parameters!InstanceID.Value</Value></QueryParameter></QueryParameters><Timeout>300000</Timeout></Query></DataSet><DataSet Name="SQLInstanceList"><Fields><Field Name="Instance_Name"><DataField>Instance Name</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="InstanceID"><DataField>InstanceID</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Guid</TypeName></Field><Field Name="SourceClassInstanceKeyValue"><DataField>SourceClassInstanceKeyValue</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT DISTINCT TargetClassInstanceKeyValue AS [Instance Name], TargetClassInstanceID AS InstanceID, SourceClassInstanceKeyValue
FROM         [SC_Class_Rel_Computer-SQLInstance_View]
WHERE     (SourceClassInstanceKeyValue = @Computer)
ORDER BY TargetClassInstanceKeyValue</CommandText><QueryParameters><QueryParameter Name="@Computer"><Value>=Parameters!Computer.Value</Value></QueryParameter></QueryParameters><Timeout>300000</Timeout></Query></DataSet></DataSets><LeftMargin>1in</LeftMargin><rd:SnapToGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:SnapToGrid><rd:DrawGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:DrawGrid><Description /><PageWidth>13in</PageWidth><rd:ReportID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">212d782b-9718-4b8d-a1c1-2bd72afd7b82</rd:ReportID><PageFooter><ReportItems><Textbox Name="textboxPageNumber_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.2in</Top><Height>0.25in</Height><Value>="Page " &amp; Globals.PageNumber &amp; "/" &amp; Globals.TotalPages</Value><Left>4in</Left></Textbox><Textbox Name="textbox1DateTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><Top>0.2in</Top><Height>0.25in</Height><Width>4in</Width><Value>="All dates and  times shown in " &amp; Code.CurrentTimeZone()</Value></Textbox></ReportItems><PrintOnLastPage>true</PrintOnLastPage><PrintOnFirstPage>true</PrintOnFirstPage><Style /><Height>0.5in</Height></PageFooter><BottomMargin>1in</BottomMargin><ReportParameters><ReportParameter Name="Computer"><DataType>String</DataType><Prompt>Computer</Prompt><ValidValues><DataSetReference><DataSetName>ComputerList</DataSetName><ValueField>Computer</ValueField><LabelField>Computer</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="InstanceID"><DataType>String</DataType><DefaultValue><DataSetReference><DataSetName>SQLInstanceList</DataSetName><ValueField>InstanceID</ValueField></DataSetReference></DefaultValue><Prompt>SQL Instance</Prompt><ValidValues><DataSetReference><DataSetName>SQLInstanceList</DataSetName><ValueField>InstanceID</ValueField><LabelField>Instance_Name</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="SortBy"><DataType>String</DataType><DefaultValue><Values><Value>Database_Size</Value></Values></DefaultValue><Prompt>Sort by</Prompt><ValidValues><ParameterValues><ParameterValue><Value>SQLDatabase</Value><Label>Databases</Label></ParameterValue><ParameterValue><Value>Database_Size</Value><Label>DB Size</Label></ParameterValue><ParameterValue><Value>Log_Size</Value><Label>DB Log Size</Label></ParameterValue></ParameterValues></ValidValues></ReportParameter><ReportParameter Name="Direction"><DataType>String</DataType><DefaultValue><Values><Value>Ascending</Value></Values></DefaultValue><Prompt>Sort Order</Prompt><ValidValues><ParameterValues><ParameterValue><Value>Ascending</Value></ParameterValue><ParameterValue><Value>Descending</Value></ParameterValue></ParameterValues></ValidValues></ReportParameter></ReportParameters></Report>]]></ReportDefinition>
  </ReportItem>
  <ReportItem>
    <Name>SQL Server Lock Analysis</Name>
    <Type>Report</Type>
    <Path>/Microsoft Operations Manager Reporting/Microsoft SQL Server/SQL Server Lock Analysis</Path>
    <ReportDefinition><![CDATA[<?xml version='1.0' encoding='utf-8'?><Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"><rd:GridSpacing xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">0.05in</rd:GridSpacing><RightMargin>1in</RightMargin><Body><ReportItems><Textbox Name="textboxRightLogo"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/2Inch_Logo.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>6</ZIndex><Height>0.5625in</Height><Value /><Left>9in</Left></Textbox><Textbox Name="textboxReportTitle_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/9Inch_Banner.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>5</ZIndex><Height>0.5625in</Height><Width>9in</Width><CanGrow>true</CanGrow><Value>SQL Server Lock Analysis</Value></Textbox><Textbox Name="textboxExecutionTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>4</ZIndex><Top>0.5625in</Top><Height>0.25in</Height><Value>=Globals.ExecutionTime</Value><Left>9in</Left></Textbox><Textbox Name="textboxParameterValue_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.375in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>= Parameters!Computer.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterValue_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.25in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>=Parameters!BeginDate.Value &amp; " - " &amp; Parameters!EndDate.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterName_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.375in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>Computer :</Value></Textbox><Textbox Name="textboxParameterName_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.25in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>Date Range :</Value></Textbox><Textbox Name="textboxDescription_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>GhostWhite</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.8125in</Top><ToggleImage><InitialState>true</InitialState></ToggleImage><Height>0.375in</Height><Visibility><ToggleItem>textboxDescriptionHeading_tmp</ToggleItem><Hidden>true</Hidden></Visibility><CanGrow>true</CanGrow><Value>= "This report displays SQL Server lock analysis by comparing Lock Requests, Lock Waits and the Number of Deadlocks.  By default this report will display data for the specified SQL Server and Instance."  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "The following rule needs to be enabled for data to be collected:"  &amp; VbCrLf &amp;  "–        Report Collection - Number of Deadlocks/sec"  &amp; VbCrLf &amp;  "–        Report Collection - Lock Waits/sec"  &amp; VbCrLf &amp;  "–        Report Collection - Lock Requests/sec" </Value></Textbox><Textbox Name="textboxDescriptionHeading_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><Top>0.5625in</Top><Height>0.25in</Height><Width>9in</Width><CanGrow>true</CanGrow><Value>Description</Value></Textbox><Chart Name="chart1"><Type>Line</Type><Subtype>Plain</Subtype><Style><BorderColor><Default>LightGrey</Default></BorderColor><BackgroundColor>White</BackgroundColor><BackgroundGradientEndColor>White</BackgroundGradientEndColor></Style><Top>1.75in</Top><Height>5in</Height><ZIndex>9</ZIndex><NoRows>= "There is no data available for this report. This can occur when there is no relevant data available for collection, the reports’ dependent rules are not enabled or when none of the relevant data has been copied to the Reporting database." </NoRows><DataSetName>SQLLockPerformance</DataSetName><SeriesGroupings><SeriesGrouping><DynamicSeries><Grouping Name="chart1_SeriesGroup1"><GroupExpressions><GroupExpression>=Fields!server.Value</GroupExpression></GroupExpressions></Grouping><Label>=Fields!server.Value</Label></DynamicSeries></SeriesGrouping><SeriesGrouping><StaticSeries><StaticMember><Label>Lock Requests</Label></StaticMember><StaticMember><Label>Lock Waits</Label></StaticMember><StaticMember><Label>Number of Deadlocks</Label></StaticMember></StaticSeries></SeriesGrouping></SeriesGroupings><CategoryGroupings><CategoryGrouping><DynamicCategories><Grouping Name="chart1_CategoryGroup1"><GroupExpressions><GroupExpression>=Fields!time.Value</GroupExpression></GroupExpressions></Grouping><Label>=Fields!time.Value</Label></DynamicCategories></CategoryGrouping></CategoryGroupings><ChartData><ChartSeries><DataPoints><DataPoint><DataValues><DataValue><Value>=Sum(Fields!Lock_Requests.Value)</Value></DataValue></DataValues><DataLabel /><Marker /></DataPoint></DataPoints></ChartSeries><ChartSeries><DataPoints><DataPoint><DataValues><DataValue><Value>=Sum(Fields!Lock_Waits.Value)</Value></DataValue></DataValues><DataLabel /><Marker /></DataPoint></DataPoints></ChartSeries><ChartSeries><DataPoints><DataPoint><DataValues><DataValue><Value>=Sum(Fields!Number_of_Deadlocks.Value)</Value></DataValue></DataValues><DataLabel /><Marker /></DataPoint></DataPoints></ChartSeries></ChartData><Legend><Visible>true</Visible><Style><BorderStyle><Default>Solid</Default></BorderStyle></Style><Position>TopCenter</Position><Layout>Table</Layout></Legend><CategoryAxis><Axis><Visible>true</Visible><Style><Format>d</Format></Style><Title><Caption>Day</Caption></Title><MajorTickMarks>Outside</MajorTickMarks><MajorGridLines><ShowGridLines>true</ShowGridLines><Style><BorderColor><Default>Silver</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle></Style></MajorGridLines><MinorGridLines><ShowGridLines>true</ShowGridLines><Style><BorderColor><Default>Silver</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BorderWidth><Default>0.75pt</Default></BorderWidth></Style></MinorGridLines><Scalar>true</Scalar></Axis></CategoryAxis><ValueAxis><Axis><Visible>true</Visible><Title><Caption>Count</Caption></Title><Margin>true</Margin><MajorGridLines><ShowGridLines>true</ShowGridLines><Style><BorderStyle><Default>Solid</Default></BorderStyle></Style></MajorGridLines><MinorGridLines><ShowGridLines>true</ShowGridLines><Style><BorderColor><Default>Silver</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BorderWidth><Default>0.75pt</Default></BorderWidth></Style></MinorGridLines><Scalar>true</Scalar><Min>0</Min></Axis></ValueAxis><Title /><Palette>Default</Palette><ThreeDProperties><Rotation>30</Rotation><Inclination>30</Inclination><Shading>Simple</Shading><WallThickness>50</WallThickness></ThreeDProperties><PlotArea><Style><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><BackgroundGradientType>TopBottom</BackgroundGradientType><BackgroundGradientEndColor>LightGrey</BackgroundGradientEndColor></Style></PlotArea></Chart></ReportItems><Style><BorderWidth><Default>0.5pt</Default></BorderWidth></Style><Height>11in</Height><ColumnSpacing>0.25in</ColumnSpacing></Body><TopMargin>1in</TopMargin><DataSources><DataSource Name="SCDW"><rd:DataSourceID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">fb44cba7-75a7-4314-b2a5-1fce44701d23</rd:DataSourceID><DataSourceReference>SCDW</DataSourceReference></DataSource></DataSources><Code>public function CurrentTimeZone() as string 
	CurrentTimeZone = System.TimeZone.CurrentTimeZone.StandardName
end function

public function FormatNumber(fieldValue, formatString) as string 
	if (fieldValue is Nothing)
		FormatNumber = "Not Available"
	else
		FormatNumber = Format(fieldValue,formatString)
	end if
end function
</Code><Width>11in</Width><DataSets><DataSet Name="ComputerList"><Fields><Field Name="Computer"><DataField>Computer</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="ComputerID"><DataField>ComputerID</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Guid</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT DISTINCT SourceClassInstanceKeyValue AS Computer, SourceClassInstanceID AS ComputerID
FROM         [SC_Class_Rel_Computer-SQLInstance_View]
ORDER BY SourceClassInstanceKeyValue</CommandText><Timeout>0</Timeout></Query></DataSet><DataSet Name="DateQuery"><Fields><Field Name="BeginDate"><DataField>BeginDate</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field><Field Name="EndDate"><DataField>EndDate</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT     *
FROM         fn_GetDateRange(7) fn_GetDateRange</CommandText><Timeout>3000000</Timeout></Query></DataSet><DataSet Name="SQLLockPerformance"><Fields><Field Name="server"><DataField>Server</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Instance"><DataField>Instance</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="InstanceName"><DataField>InstanceName</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="time"><DataField>Time</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field><Field Name="Lock_Requests"><DataField>Lock Requests</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Decimal</TypeName></Field><Field Name="Lock_Waits"><DataField>Lock Waits</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Decimal</TypeName></Field><Field Name="Number_of_Deadlocks"><DataField>Number of Deadlocks</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Decimal</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT     Server, Instance, InstanceName, Time, CAST(AVG([Lock Requests]) AS Decimal(15, 2)) AS [Lock Requests], CAST(AVG([Lock Waits]) AS Decimal(15, 2)) 
                      AS [Lock Waits], CAST(AVG([Number of Deadlocks]) AS Decimal(15, 2)) AS [Number of Deadlocks]
FROM         (SELECT     [Server] = CD.FullComputerName, [Instance] = CASE WHEN (CDD.ObjectName_PK LIKE 'SQLServer%') 
                                              THEN 'MS' + substring(ObjectName_PK, CHARINDEX('S', ObjectName_PK, 1), CHARINDEX(':', ObjectName_PK, 1) - CHARINDEX('S', 
                                              ObjectName_PK, 1)) ELSE CASE WHEN (CDD.ObjectName_PK LIKE 'MSSQL$%') THEN substring(ObjectName_PK, CHARINDEX('$', 
                                              ObjectName_PK, 1) + 1, CHARINDEX(':', ObjectName_PK, 1) - (CHARINDEX('$', ObjectName_PK, 1) + 1)) END END, 
                                              [InstanceName] = CDD.InstanceName_PK, [time] = DD.Date, 
                                              [Lock Requests] = CASE WHEN (CDD.ObjectName_PK LIKE '%SQL%Server:Locks' AND CDD.CounterName_PK = 'Lock Requests/sec') 
                                              THEN SND.SampleValue END, [Lock Waits] = CASE WHEN (CDD.ObjectName_PK LIKE '%SQL%Server:Locks' AND 
                                              CDD.CounterName_PK = 'Lock Waits/sec') THEN SND.SampleValue END, 
                                              [Number Of Deadlocks] = CASE WHEN (CDD.ObjectName_PK LIKE '%SQL%Server:Locks' AND 
                                              CDD.CounterName_PK = 'Number of Deadlocks/sec') THEN SND.SampleValue END
                       FROM          dbo.SC_SampledNumericDataFact_View SND INNER JOIN
                                              dbo.SC_DateDimension_View DD ON DD.SMC_InstanceID = SND.LocalDatesampled_FK INNER JOIN
                                              dbo.SC_TimeDimension_View TD ON TD.SMC_InstanceID = SND.LocalTimeSampled_FK INNER JOIN
                                              dbo.SC_CounterDetailDimension_View CDD ON CDD.SMC_InstanceID = SND.CounterDetail_FK INNER JOIN
                                              dbo.SC_ComputerDimension_View CD ON CD.SMC_InstanceID = SND.Computer_FK
                       WHERE      CDD.ObjectName_PK LIKE ('%SQL%Server:Locks') AND CDD.CounterName_PK IN ('Lock Requests/sec', 'Lock Waits/sec', 
                                              'Number of Deadlocks/sec') AND CDD.InstanceName_PK IN ('_Total') AND DD.Date BETWEEN @BeginDate AND @EndDate AND 
                                              CD.FullComputerName = @Computer) TMP
WHERE     (Instance = @Instance)
GROUP BY Server, Instance, InstanceName, time
ORDER BY Server, Instance, InstanceName, time</CommandText><QueryParameters><QueryParameter Name="@BeginDate"><Value>=Parameters!BeginDate.Value</Value></QueryParameter><QueryParameter Name="@EndDate"><Value>=Parameters!EndDate.Value</Value></QueryParameter><QueryParameter Name="@Computer"><Value>=Parameters!Computer.Value</Value></QueryParameter><QueryParameter Name="@Instance"><Value>=Parameters!Instance.Value</Value></QueryParameter></QueryParameters><Timeout>3000000</Timeout></Query></DataSet><DataSet Name="SQLInstance"><Fields><Field Name="Instance"><DataField>Instance</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT DISTINCT TargetClassInstanceKeyValue AS Instance
FROM         [SC_Class_Rel_Computer-SQLInstance_View]
WHERE     (SourceClassInstanceKeyValue = @Computer)
ORDER BY TargetClassInstanceKeyValue</CommandText><QueryParameters><QueryParameter Name="@Computer"><Value>=Parameters!Computer.Value</Value></QueryParameter></QueryParameters><Timeout>400000000</Timeout></Query></DataSet></DataSets><LeftMargin>1in</LeftMargin><rd:SnapToGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:SnapToGrid><rd:DrawGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:DrawGrid><Description /><PageWidth>13in</PageWidth><rd:ReportID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">212d782b-9718-4b8d-a1c1-2bd72afd7b82</rd:ReportID><PageFooter><ReportItems><Textbox Name="textboxPageNumber_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.2in</Top><Height>0.25in</Height><Value>="Page " &amp; Globals.PageNumber &amp; "/" &amp; Globals.TotalPages</Value><Left>4in</Left></Textbox><Textbox Name="textbox1DateTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><Top>0.2in</Top><Height>0.25in</Height><Width>4in</Width><Value>="All dates and  times shown in " &amp; Code.CurrentTimeZone()</Value></Textbox></ReportItems><PrintOnLastPage>true</PrintOnLastPage><PrintOnFirstPage>true</PrintOnFirstPage><Style /><Height>0.5in</Height></PageFooter><BottomMargin>1in</BottomMargin><ReportParameters><ReportParameter Name="BeginDate"><DataType>DateTime</DataType><DefaultValue><DataSetReference><DataSetName>DateQuery</DataSetName><ValueField>BeginDate</ValueField></DataSetReference></DefaultValue><Prompt>Begin Date</Prompt></ReportParameter><ReportParameter Name="EndDate"><DataType>DateTime</DataType><DefaultValue><DataSetReference><DataSetName>DateQuery</DataSetName><ValueField>EndDate</ValueField></DataSetReference></DefaultValue><Prompt>End Date</Prompt></ReportParameter><ReportParameter Name="Computer"><DataType>String</DataType><Prompt>Computer</Prompt><ValidValues><DataSetReference><DataSetName>ComputerList</DataSetName><ValueField>Computer</ValueField><LabelField>Computer</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="Instance"><DataType>String</DataType><DefaultValue><DataSetReference><DataSetName>SQLInstance</DataSetName><ValueField>Instance</ValueField></DataSetReference></DefaultValue><Prompt>SQL Instance</Prompt><ValidValues><DataSetReference><DataSetName>SQLInstance</DataSetName><ValueField>Instance</ValueField><LabelField>Instance</LabelField></DataSetReference></ValidValues></ReportParameter></ReportParameters></Report>]]></ReportDefinition>
  </ReportItem>
  <ReportItem>
    <Name>SQL Server Service Pack Report</Name>
    <Type>Report</Type>
    <Path>/Microsoft Operations Manager Reporting/Microsoft SQL Server/SQL Server Service Pack Report</Path>
    <ReportDefinition><![CDATA[<?xml version='1.0' encoding='utf-8'?><Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"><rd:GridSpacing xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">0.05in</rd:GridSpacing><RightMargin>1in</RightMargin><Body><ReportItems><Textbox Name="textboxRightLogo"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/2Inch_Logo.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>6</ZIndex><Height>0.5625in</Height><Value /><Left>9in</Left></Textbox><Textbox Name="textboxReportTitle_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/9Inch_Banner.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>5</ZIndex><Height>0.5625in</Height><Width>9in</Width><CanGrow>true</CanGrow><Value>SQL Server Service Pack Report</Value></Textbox><Textbox Name="textboxExecutionTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>4</ZIndex><Top>0.5625in</Top><Height>0.25in</Height><Value>=Globals.ExecutionTime</Value><Left>9in</Left></Textbox><Textbox Name="textboxDescription_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>GhostWhite</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.8125in</Top><ToggleImage><InitialState>true</InitialState></ToggleImage><Height>0.375in</Height><Visibility><ToggleItem>textboxDescriptionHeading_tmp</ToggleItem><Hidden>true</Hidden></Visibility><CanGrow>true</CanGrow><Value>= "This report displays the version, build number and service pack version for all SQL Server instances installed on a specified server.  By default this report will display data for all SQL Servers.  The rule is dependent on SQL Server service discovery."  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "The following rule needs to be enabled for data to be collected:"  &amp; VbCrLf &amp;  "–        SQL Server 2000 Service Discovery" </Value></Textbox><Textbox Name="textboxDescriptionHeading_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><Top>0.5625in</Top><Height>0.25in</Height><Width>9in</Width><CanGrow>true</CanGrow><Value>Description</Value></Textbox><Table Name="table1"><Style /><Top>1.5in</Top><Height>0.5in</Height><ZIndex>2</ZIndex><NoRows>= "There is no data available for this report. This can occur when there is no relevant data available for collection, the reports’ dependent rules are not enabled or when none of the relevant data has been copied to the Reporting database." </NoRows><DataSetName>SQLServicePackLevel</DataSetName><TableColumns><TableColumn><Width>3.03821in</Width></TableColumn><TableColumn><Width>3.40448in</Width></TableColumn><TableColumn><Width>1.38701in</Width></TableColumn><TableColumn><Width>1.58515in</Width></TableColumn><TableColumn><Width>1.58515in</Width></TableColumn></TableColumns><Header><TableRows><TableRow><TableCells><TableCell><ReportItems><Textbox Name="Server"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Server</DefaultName><ZIndex>9</ZIndex><Value>Server Name</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox2"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox2</DefaultName><ZIndex>8</ZIndex><Value>SQL Instance Name</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox3"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox3</DefaultName><ZIndex>7</ZIndex><Value>Version</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox1"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox1</DefaultName><ZIndex>6</ZIndex><Value>Build Number</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="textbox6"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">textbox6</DefaultName><ZIndex>5</ZIndex><Value>Service Pack Version</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow></TableRows><RepeatOnNewPage>true</RepeatOnNewPage></Header><Details><TableRows><TableRow><TableCells><TableCell><ReportItems><Textbox Name="Server_1"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Server_1</DefaultName><ZIndex>4</ZIndex><Value>=Fields!Server.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Instance"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Instance</DefaultName><ZIndex>3</ZIndex><Value>=Fields!Instance.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Version"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Version</DefaultName><ZIndex>2</ZIndex><Value>=Fields!Version.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Build_Number"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Build_Number</DefaultName><ZIndex>1</ZIndex><Value>=Fields!Build_Number.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Service_Pack_Version"><Style><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><FontFamily>Verdana</FontFamily><FontSize>8pt</FontSize><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><PaddingBottom>2pt</PaddingBottom></Style><DefaultName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">Service_Pack_Version</DefaultName><Value>=Fields!Service_Pack_Version.Value</Value><CanGrow>true</CanGrow></Textbox></ReportItems></TableCell></TableCells><Height>0.25in</Height></TableRow></TableRows><Sorting><SortBy><SortExpression>=iif(Parameters!SortDirection.Value="Ascending",Fields(Parameters!SortBy.Value).Value,0) </SortExpression><Direction>Ascending</Direction></SortBy><SortBy><SortExpression>=iif(Parameters!SortDirection.Value="Descending",Fields(Parameters!SortBy.Value).Value,0) </SortExpression><Direction>Descending</Direction></SortBy></Sorting></Details></Table></ReportItems><Style><BorderWidth><Default>0.5pt</Default></BorderWidth></Style><Height>11in</Height><ColumnSpacing>0.25in</ColumnSpacing></Body><TopMargin>1in</TopMargin><DataSources><DataSource Name="SCDW"><rd:DataSourceID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">fb44cba7-75a7-4314-b2a5-1fce44701d23</rd:DataSourceID><DataSourceReference>SCDW</DataSourceReference></DataSource></DataSources><Code>public function CurrentTimeZone() as string 
	CurrentTimeZone = System.TimeZone.CurrentTimeZone.StandardName
end function

public function FormatNumber(fieldValue, formatString) as string 
	if (fieldValue is Nothing)
		FormatNumber = "Not Available"
	else
		FormatNumber = Format(fieldValue,formatString)
	end if
end function
</Code><Width>11in</Width><DataSets><DataSet Name="SQLServicePackLevel"><Fields><Field Name="Server"><DataField>Server</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Instance"><DataField>Instance</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="KeyValue"><DataField>KeyValue</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Version"><DataField>Version</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Build_Number"><DataField>Build Number</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Service_Pack_Version"><DataField>Service Pack Version</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT     CD.FullComputerName AS Server, C_SQL.[SQL Server Instance Name] AS Instance, C_SQL.[SQL Server Instance Name] AS KeyValue, 
                      CASE WHEN SUBSTRING(C_SQL.[Sql Server Version], 1, 1)  = '7' THEN 'SQL Server 7.0' WHEN SUBSTRING(C_SQL.[Sql Server Version], 1, 1) 
                      =  '8' THEN 'SQL Server 2000' END AS Version, C_SQL.[SQL Server Version] AS [Build Number], 
                      C_SQL.[Service Pack Version] AS [Service Pack Version]
FROM         SC_Class_SQL_View C_SQL INNER JOIN
                      [SC_Class_Rel_Computer-SQLInstance_View] R_CSQL ON R_CSQL.TargetClassInstanceID = C_SQL.ClassInstanceID INNER JOIN
                      SC_ComputerDimension_View CD ON CD.ComputerID = R_CSQL.SourceClassInstanceID</CommandText><Timeout>0</Timeout></Query></DataSet></DataSets><LeftMargin>1in</LeftMargin><rd:SnapToGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:SnapToGrid><rd:DrawGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:DrawGrid><Description /><PageWidth>13in</PageWidth><rd:ReportID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">212d782b-9718-4b8d-a1c1-2bd72afd7b82</rd:ReportID><PageFooter><ReportItems><Textbox Name="textboxPageNumber_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.2in</Top><Height>0.25in</Height><Value>="Page " &amp; Globals.PageNumber &amp; "/" &amp; Globals.TotalPages</Value><Left>4in</Left></Textbox><Textbox Name="textbox1DateTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><Top>0.2in</Top><Height>0.25in</Height><Width>4in</Width><Value>="All dates and  times shown in " &amp; Code.CurrentTimeZone()</Value></Textbox></ReportItems><PrintOnLastPage>true</PrintOnLastPage><PrintOnFirstPage>true</PrintOnFirstPage><Style /><Height>0.5in</Height></PageFooter><BottomMargin>1in</BottomMargin><ReportParameters><ReportParameter Name="SortBy"><DataType>String</DataType><DefaultValue><Values><Value>Server</Value></Values></DefaultValue><Prompt>Sort By</Prompt><ValidValues><ParameterValues><ParameterValue><Value>Server</Value><Label>Server Name</Label></ParameterValue><ParameterValue><Value>Instance</Value><Label>SQL Instance Name</Label></ParameterValue><ParameterValue><Value>Version</Value></ParameterValue><ParameterValue><Value>Build_Number</Value><Label>Build Number</Label></ParameterValue><ParameterValue><Value>Service_Pack_Version</Value><Label>Service Pack Version</Label></ParameterValue></ParameterValues></ValidValues></ReportParameter><ReportParameter Name="SortDirection"><DataType>String</DataType><DefaultValue><Values><Value>Ascending</Value></Values></DefaultValue><Prompt>Sort Order</Prompt><ValidValues><ParameterValues><ParameterValue><Value>Ascending</Value></ParameterValue><ParameterValue><Value>Descending</Value></ParameterValue></ParameterValues></ValidValues></ReportParameter></ReportParameters></Report>]]></ReportDefinition>
  </ReportItem>
  <ReportItem>
    <Name>Top 25 Percent Failed Logins</Name>
    <Type>Report</Type>
    <Path>/Microsoft Operations Manager Reporting/Microsoft SQL Server/Top 25 Percent Failed Logins</Path>
    <ReportDefinition><![CDATA[<?xml version='1.0' encoding='utf-8'?><Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"><rd:GridSpacing xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">0.05in</rd:GridSpacing><RightMargin>1in</RightMargin><Body><ReportItems><Textbox Name="textboxRightLogo"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/2Inch_Logo.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>6</ZIndex><Height>0.5625in</Height><Value /><Left>9in</Left></Textbox><Textbox Name="textboxReportTitle_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/9Inch_Banner.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>5</ZIndex><Height>0.5625in</Height><Width>9in</Width><CanGrow>true</CanGrow><Value>Top 25 Percent Failed Logins</Value></Textbox><Textbox Name="textboxExecutionTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>4</ZIndex><Top>0.5625in</Top><Height>0.25in</Height><Value>=Globals.ExecutionTime</Value><Left>9in</Left></Textbox><Textbox Name="textboxParameterValue_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.375in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>= Parameters!Instance.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterValue_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.25in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>= Parameters!Computer.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterName_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.375in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>SQL Instance :</Value></Textbox><Textbox Name="textboxParameterName_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.25in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>Computer :</Value></Textbox><Textbox Name="textboxDescription_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>GhostWhite</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.8125in</Top><ToggleImage><InitialState>true</InitialState></ToggleImage><Height>0.375in</Height><Visibility><ToggleItem>textboxDescriptionHeading_tmp</ToggleItem><Hidden>true</Hidden></Visibility><CanGrow>true</CanGrow><Value>= "This report displays the top 25% of failed logins for each SQL Server instances installed on a specified server.  Audit data is collected from SQL Server login auditing and totaled for each user.  The rule is dependent on SQL Server auditing and SQL Server audit report collection rules."  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "To enable SQL Server auditing, the following steps should be followed:"  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "Using the SQL Server Enterprise Manager:"  &amp; VbCrLf &amp;  "–       Expand a server group."  &amp; VbCrLf &amp;  "–       Right-click a server, and then click Properties."  &amp; VbCrLf &amp;  "–       Select the Security tab"  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "Under Audit level, select the level at which user accesses to Microsoft® SQL Server™ are recorded in the SQL Server error log:"  &amp; VbCrLf &amp;  "–       None causes no auditing to be performed."  &amp; VbCrLf &amp;  "–       Success causes only successful login attempts to be audited."  &amp; VbCrLf &amp;  "–       Failure causes only failed login attempts to be audited."  &amp; VbCrLf &amp;  "–       All causes successful and failed login attempts to be audited."  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "The following rule needs to be enabled for data to be collected:"  &amp; VbCrLf &amp;  "–        Report Collection - SQL Server 2000 Failed Logins" </Value></Textbox><Textbox Name="textboxDescriptionHeading_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><Top>0.5625in</Top><Height>0.25in</Height><Width>9in</Width><CanGrow>true</CanGrow><Value>Description</Value></Textbox><Chart Name="chart1"><Type>Column</Type><Subtype>Plain</Subtype><Style><BackgroundColor>White</BackgroundColor></Style><Top>1.75in</Top><Height>5in</Height><ZIndex>9</ZIndex><NoRows>= "There is no data available for this report. This can occur when there is no relevant data available for collection, the reports’ dependent rules are not enabled or when none of the relevant data has been copied to the Reporting database." </NoRows><DataSetName>SQLFailedLogins</DataSetName><SeriesGroupings><SeriesGrouping><DynamicSeries><Grouping Name="chart1_SeriesGroup1"><GroupExpressions><GroupExpression>=Fields!Server.Value</GroupExpression></GroupExpressions></Grouping><Label>=Fields!Server.Value</Label></DynamicSeries></SeriesGrouping></SeriesGroupings><CategoryGroupings><CategoryGrouping><DynamicCategories><Grouping Name="chart1_CategoryGroup1"><GroupExpressions><GroupExpression>=Fields!UserName.Value</GroupExpression></GroupExpressions></Grouping><Label>=Fields!UserName.Value</Label></DynamicCategories></CategoryGrouping></CategoryGroupings><ChartData><ChartSeries><DataPoints><DataPoint><DataValues><DataValue><Value>=Sum(Fields!count.Value)</Value></DataValue></DataValues><DataLabel /><Marker /></DataPoint></DataPoints></ChartSeries></ChartData><Legend><Visible>true</Visible><Style><BorderStyle><Default>Solid</Default></BorderStyle></Style><Position>TopCenter</Position><Layout>Table</Layout></Legend><CategoryAxis><Axis><Visible>true</Visible><Style><Format>g</Format></Style><Title><Caption>User Name</Caption></Title><Margin>true</Margin><MajorTickMarks>Outside</MajorTickMarks><MajorGridLines><ShowGridLines>true</ShowGridLines><Style><BorderColor><Default>Silver</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle></Style></MajorGridLines><MinorGridLines><ShowGridLines>true</ShowGridLines><Style><BorderColor><Default>Silver</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BorderWidth><Default>0.75pt</Default></BorderWidth></Style></MinorGridLines><Min>0</Min></Axis></CategoryAxis><ValueAxis><Axis><Visible>true</Visible><Title><Caption>Count</Caption></Title><Margin>true</Margin><MajorTickMarks>Outside</MajorTickMarks><MajorGridLines><ShowGridLines>true</ShowGridLines><Style><BorderStyle><Default>Solid</Default></BorderStyle></Style></MajorGridLines><MinorGridLines><ShowGridLines>true</ShowGridLines><Style><BorderColor><Default>Silver</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BorderWidth><Default>0.75pt</Default></BorderWidth></Style></MinorGridLines><Scalar>true</Scalar></Axis></ValueAxis><Title /><Palette>Default</Palette><ThreeDProperties><Rotation>30</Rotation><Inclination>30</Inclination><Shading>Simple</Shading><WallThickness>50</WallThickness></ThreeDProperties><PlotArea><Style><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><BackgroundGradientType>TopBottom</BackgroundGradientType><BackgroundGradientEndColor>LightGrey</BackgroundGradientEndColor></Style></PlotArea></Chart></ReportItems><Style><BorderWidth><Default>0.5pt</Default></BorderWidth></Style><Height>11in</Height><ColumnSpacing>0.25in</ColumnSpacing></Body><TopMargin>1in</TopMargin><DataSources><DataSource Name="SCDW"><rd:DataSourceID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">fb44cba7-75a7-4314-b2a5-1fce44701d23</rd:DataSourceID><DataSourceReference>SCDW</DataSourceReference></DataSource></DataSources><Code>public function CurrentTimeZone() as string 
	CurrentTimeZone = System.TimeZone.CurrentTimeZone.StandardName
end function

public function FormatNumber(fieldValue, formatString) as string 
	if (fieldValue is Nothing)
		FormatNumber = "Not Available"
	else
		FormatNumber = Format(fieldValue,formatString)
	end if
end function
</Code><Width>11in</Width><DataSets><DataSet Name="ComputerList"><Fields><Field Name="Computer"><DataField>Computer</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="ComputerID"><DataField>ComputerID</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Guid</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT DISTINCT SourceClassInstanceKeyValue AS Computer, SourceClassInstanceID AS ComputerID
FROM         [SC_Class_Rel_Computer-SQLInstance_View]
ORDER BY SourceClassInstanceKeyValue</CommandText><Timeout>0</Timeout></Query></DataSet><DataSet Name="DateQuery"><Fields><Field Name="BeginDate"><DataField>BeginDate</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field><Field Name="EndDate"><DataField>EndDate</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT     *
FROM         fn_GetDateRange(7) fn_GetDateRange</CommandText><Timeout>300000</Timeout></Query></DataSet><DataSet Name="SQLINstance"><Fields><Field Name="Instance"><DataField>Instance</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT DISTINCT TargetClassInstanceKeyValue AS [Instance]
FROM         [SC_Class_Rel_Computer-SQLInstance_View]
WHERE     (SourceClassInstanceKeyValue = @Computer)
order by TargetClassInstanceKeyValue</CommandText><QueryParameters><QueryParameter Name="@Computer"><Value>=Parameters!Computer.Value</Value></QueryParameter></QueryParameters><Timeout>300000</Timeout><UseGenericDesigner xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</UseGenericDesigner></Query></DataSet><DataSet Name="SQLFailedLogins"><Fields><Field Name="Server"><DataField>Server</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Instance"><DataField>Instance</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="UserName"><DataField>UserName</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Reason"><DataField>Reason</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="count"><DataField>count</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Int32</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandType>StoredProcedure</CommandType><CommandText>p_SQLTop25FailedloginsReport</CommandText><QueryParameters><QueryParameter Name="@Computer"><Value>=Parameters!Computer.Value</Value></QueryParameter><QueryParameter Name="@Instance"><Value>=Parameters!Instance.Value</Value></QueryParameter><QueryParameter Name="@BeginDate"><Value>=Parameters!BeginDate.Value</Value></QueryParameter><QueryParameter Name="@EndDate"><Value>=Parameters!EndDate.Value</Value></QueryParameter></QueryParameters><Timeout>90000000</Timeout></Query></DataSet></DataSets><LeftMargin>1in</LeftMargin><rd:SnapToGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:SnapToGrid><rd:DrawGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:DrawGrid><Description /><PageWidth>13in</PageWidth><rd:ReportID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">212d782b-9718-4b8d-a1c1-2bd72afd7b82</rd:ReportID><PageFooter><ReportItems><Textbox Name="textboxPageNumber_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.2in</Top><Height>0.25in</Height><Value>="Page " &amp; Globals.PageNumber &amp; "/" &amp; Globals.TotalPages</Value><Left>4in</Left></Textbox><Textbox Name="textbox1DateTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><Top>0.2in</Top><Height>0.25in</Height><Width>4in</Width><Value>="All dates and  times shown in " &amp; Code.CurrentTimeZone()</Value></Textbox></ReportItems><PrintOnLastPage>true</PrintOnLastPage><PrintOnFirstPage>true</PrintOnFirstPage><Style /><Height>0.5in</Height></PageFooter><BottomMargin>1in</BottomMargin><ReportParameters><ReportParameter Name="BeginDate"><DataType>DateTime</DataType><DefaultValue><DataSetReference><DataSetName>DateQuery</DataSetName><ValueField>BeginDate</ValueField></DataSetReference></DefaultValue><Prompt>Begin Date</Prompt></ReportParameter><ReportParameter Name="EndDate"><DataType>DateTime</DataType><DefaultValue><DataSetReference><DataSetName>DateQuery</DataSetName><ValueField>EndDate</ValueField></DataSetReference></DefaultValue><Prompt>End Date</Prompt></ReportParameter><ReportParameter Name="Computer"><DataType>String</DataType><Prompt>Computer</Prompt><ValidValues><DataSetReference><DataSetName>ComputerList</DataSetName><ValueField>Computer</ValueField><LabelField>Computer</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="Instance"><DataType>String</DataType><DefaultValue><DataSetReference><DataSetName>SQLINstance</DataSetName><ValueField>Instance</ValueField></DataSetReference></DefaultValue><Prompt>SQL Instance</Prompt><ValidValues><DataSetReference><DataSetName>SQLINstance</DataSetName><ValueField>Instance</ValueField><LabelField>Instance</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="SortBy"><DataType>String</DataType><DefaultValue><Values><Value>Time</Value></Values></DefaultValue><ValidValues><ParameterValues><ParameterValue><Value>Time</Value></ParameterValue><ParameterValue><Value>USerName</Value><Label>User</Label></ParameterValue><ParameterValue><Value>Reason</Value></ParameterValue></ParameterValues></ValidValues></ReportParameter><ReportParameter Name="Direction"><DataType>String</DataType><DefaultValue><Values><Value>Descending</Value></Values></DefaultValue><ValidValues><ParameterValues><ParameterValue><Value>Ascending</Value></ParameterValue><ParameterValue><Value>Descending</Value></ParameterValue></ParameterValues></ValidValues></ReportParameter></ReportParameters></Report>]]></ReportDefinition>
  </ReportItem>
  <ReportItem>
    <Name>Top 25 Percent Successful Logins</Name>
    <Type>Report</Type>
    <Path>/Microsoft Operations Manager Reporting/Microsoft SQL Server/Top 25 Percent Successful Logins</Path>
    <ReportDefinition><![CDATA[<?xml version='1.0' encoding='utf-8'?><Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"><rd:GridSpacing xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">0.05in</rd:GridSpacing><RightMargin>1in</RightMargin><Body><ReportItems><Textbox Name="textboxRightLogo"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/2Inch_Logo.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>6</ZIndex><Height>0.5625in</Height><Value /><Left>9in</Left></Textbox><Textbox Name="textboxReportTitle_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/9Inch_Banner.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>5</ZIndex><Height>0.5625in</Height><Width>9in</Width><CanGrow>true</CanGrow><Value>Top 25 Percent Successful Logins</Value></Textbox><Textbox Name="textboxExecutionTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>4</ZIndex><Top>0.5625in</Top><Height>0.25in</Height><Value>=Globals.ExecutionTime</Value><Left>9in</Left></Textbox><Textbox Name="textboxParameterValue_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.375in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>= Parameters!Instance.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterValue_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.25in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>= Parameters!Computer.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterName_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.375in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>SQL Instance :</Value></Textbox><Textbox Name="textboxParameterName_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.25in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>Computer :</Value></Textbox><Textbox Name="textboxDescription_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>GhostWhite</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.8125in</Top><ToggleImage><InitialState>true</InitialState></ToggleImage><Height>0.375in</Height><Visibility><ToggleItem>textboxDescriptionHeading_tmp</ToggleItem><Hidden>true</Hidden></Visibility><CanGrow>true</CanGrow><Value>= "This report displays the top 25% of successful logins for the specified SQL Server instance installed on a specified server.  Audit data is collected from SQL Server login auditing and totaled for each user.  The rule is dependent on SQL Server auditing and SQL Server audit report collection rules."  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "To enable SQL Server auditing, the following steps should be followed:"  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "Using the SQL Server Enterprise Manager:"  &amp; VbCrLf &amp;  "–       Expand a server group."  &amp; VbCrLf &amp;  "–       Right-click a server, and then click Properties."  &amp; VbCrLf &amp;  "–       Select the Security tab"  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "Under Audit level, select the level at which user accesses to Microsoft® SQL Server™ are recorded in the SQL Server error log:"  &amp; VbCrLf &amp;  "–       None causes no auditing to be performed."  &amp; VbCrLf &amp;  "–       Success causes only successful login attempts to be audited."  &amp; VbCrLf &amp;  "–       Failure causes only failed login attempts to be audited."  &amp; VbCrLf &amp;  "–       All causes successful and failed login attempts to be audited."  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "The following rule needs to be enabled for data to be collected:"  &amp; VbCrLf &amp;  "–        Report Collection - SQL Server 2000 Successful Logins (Non-Trusted)"  &amp; VbCrLf &amp;  "–        Report Collection - SQL Server 2000 Successful Logins (Trusted)" </Value></Textbox><Textbox Name="textboxDescriptionHeading_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><Top>0.5625in</Top><Height>0.25in</Height><Width>9in</Width><CanGrow>true</CanGrow><Value>Description</Value></Textbox><Chart Name="chart1"><Type>Column</Type><Subtype>Plain</Subtype><Style><BackgroundColor>White</BackgroundColor></Style><Top>1.75in</Top><Height>5in</Height><ZIndex>9</ZIndex><NoRows>= "There is no data available for this report. This can occur when there is no relevant data available for collection, the reports’ dependent rules are not enabled or when none of the relevant data has been copied to the Reporting database." </NoRows><DataSetName>SQLSuccessfulLogins</DataSetName><SeriesGroupings><SeriesGrouping><DynamicSeries><Grouping Name="chart1_SeriesGroup1"><GroupExpressions><GroupExpression>=Fields!Server.Value</GroupExpression></GroupExpressions></Grouping><Label>=Fields!Server.Value</Label></DynamicSeries></SeriesGrouping></SeriesGroupings><CategoryGroupings><CategoryGrouping><DynamicCategories><Grouping Name="chart1_CategoryGroup1"><GroupExpressions><GroupExpression>=Fields!UserName.Value</GroupExpression></GroupExpressions></Grouping><Label>=Fields!UserName.Value</Label></DynamicCategories></CategoryGrouping></CategoryGroupings><ChartData><ChartSeries><DataPoints><DataPoint><DataValues><DataValue><Value>=Sum(Fields!count.Value)</Value></DataValue></DataValues><DataLabel /><Marker /></DataPoint></DataPoints></ChartSeries></ChartData><Legend><Visible>true</Visible><Style><BorderStyle><Default>Solid</Default></BorderStyle></Style><Position>TopCenter</Position><Layout>Table</Layout></Legend><CategoryAxis><Axis><Visible>true</Visible><Style><Format>g</Format></Style><Title><Caption>User Name</Caption></Title><Margin>true</Margin><MajorTickMarks>Outside</MajorTickMarks><MajorGridLines><ShowGridLines>true</ShowGridLines><Style><BorderColor><Default>Silver</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle></Style></MajorGridLines><MinorGridLines><ShowGridLines>true</ShowGridLines><Style><BorderColor><Default>Silver</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BorderWidth><Default>0.75pt</Default></BorderWidth></Style></MinorGridLines><Min>0</Min></Axis></CategoryAxis><ValueAxis><Axis><Visible>true</Visible><Title><Caption>Count</Caption></Title><Margin>true</Margin><MajorTickMarks>Outside</MajorTickMarks><MajorGridLines><ShowGridLines>true</ShowGridLines><Style><BorderStyle><Default>Solid</Default></BorderStyle></Style></MajorGridLines><MinorGridLines><ShowGridLines>true</ShowGridLines><Style><BorderColor><Default>Silver</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BorderWidth><Default>0.75pt</Default></BorderWidth></Style></MinorGridLines><Scalar>true</Scalar></Axis></ValueAxis><Title /><Palette>Default</Palette><ThreeDProperties><Rotation>30</Rotation><Inclination>30</Inclination><Shading>Simple</Shading><WallThickness>50</WallThickness></ThreeDProperties><PlotArea><Style><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><BackgroundGradientType>TopBottom</BackgroundGradientType><BackgroundGradientEndColor>LightGrey</BackgroundGradientEndColor></Style></PlotArea></Chart></ReportItems><Style><BorderWidth><Default>0.5pt</Default></BorderWidth></Style><Height>11in</Height><ColumnSpacing>0.25in</ColumnSpacing></Body><TopMargin>1in</TopMargin><DataSources><DataSource Name="SCDW"><rd:DataSourceID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">fb44cba7-75a7-4314-b2a5-1fce44701d23</rd:DataSourceID><DataSourceReference>SCDW</DataSourceReference></DataSource></DataSources><Code>public function CurrentTimeZone() as string 
	CurrentTimeZone = System.TimeZone.CurrentTimeZone.StandardName
end function

public function FormatNumber(fieldValue, formatString) as string 
	if (fieldValue is Nothing)
		FormatNumber = "Not Available"
	else
		FormatNumber = Format(fieldValue,formatString)
	end if
end function
</Code><Width>11in</Width><DataSets><DataSet Name="ComputerList"><Fields><Field Name="Computer"><DataField>Computer</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="ComputerID"><DataField>ComputerID</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Guid</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT DISTINCT SourceClassInstanceKeyValue AS Computer, SourceClassInstanceID AS ComputerID
FROM         [SC_Class_Rel_Computer-SQLInstance_View]
ORDER BY SourceClassInstanceKeyValue</CommandText><Timeout>0</Timeout></Query></DataSet><DataSet Name="DateQuery"><Fields><Field Name="BeginDate"><DataField>BeginDate</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field><Field Name="EndDate"><DataField>EndDate</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT     *
FROM         fn_GetDateRange(7) fn_GetDateRange</CommandText><Timeout>300000</Timeout></Query></DataSet><DataSet Name="SQLINstance"><Fields><Field Name="Instance"><DataField>Instance</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT DISTINCT TargetClassInstanceKeyValue AS [Instance]
FROM         [SC_Class_Rel_Computer-SQLInstance_View]
WHERE     (SourceClassInstanceKeyValue = @Computer)
Order by TargetClassInstanceKeyValue</CommandText><QueryParameters><QueryParameter Name="@Computer"><Value>=Parameters!Computer.Value</Value></QueryParameter></QueryParameters><Timeout>300000</Timeout><UseGenericDesigner xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</UseGenericDesigner></Query></DataSet><DataSet Name="SQLSuccessfulLogins"><Fields><Field Name="Server"><DataField>Server</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Instance"><DataField>Instance</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="UserName"><DataField>UserName</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Reason"><DataField>Reason</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="count"><DataField>count</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Int32</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandType>StoredProcedure</CommandType><CommandText>p_SQLTop25SuccessfulLoginsReport</CommandText><QueryParameters><QueryParameter Name="@Computer"><Value>=Parameters!Computer.Value</Value></QueryParameter><QueryParameter Name="@Instance"><Value>=Parameters!Instance.Value</Value></QueryParameter><QueryParameter Name="@BeginDate"><Value>=Parameters!BeginDate.Value</Value></QueryParameter><QueryParameter Name="@EndDate"><Value>=Parameters!EndDate.Value</Value></QueryParameter></QueryParameters><Timeout>900000000</Timeout></Query></DataSet></DataSets><LeftMargin>1in</LeftMargin><rd:SnapToGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:SnapToGrid><rd:DrawGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:DrawGrid><Description /><PageWidth>13in</PageWidth><rd:ReportID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">212d782b-9718-4b8d-a1c1-2bd72afd7b82</rd:ReportID><PageFooter><ReportItems><Textbox Name="textboxPageNumber_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.2in</Top><Height>0.25in</Height><Value>="Page " &amp; Globals.PageNumber &amp; "/" &amp; Globals.TotalPages</Value><Left>4in</Left></Textbox><Textbox Name="textbox1DateTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><Top>0.2in</Top><Height>0.25in</Height><Width>4in</Width><Value>="All dates and  times shown in " &amp; Code.CurrentTimeZone()</Value></Textbox></ReportItems><PrintOnLastPage>true</PrintOnLastPage><PrintOnFirstPage>true</PrintOnFirstPage><Style /><Height>0.5in</Height></PageFooter><BottomMargin>1in</BottomMargin><ReportParameters><ReportParameter Name="BeginDate"><DataType>DateTime</DataType><DefaultValue><DataSetReference><DataSetName>DateQuery</DataSetName><ValueField>BeginDate</ValueField></DataSetReference></DefaultValue><Prompt>Begin Date</Prompt></ReportParameter><ReportParameter Name="EndDate"><DataType>DateTime</DataType><DefaultValue><DataSetReference><DataSetName>DateQuery</DataSetName><ValueField>EndDate</ValueField></DataSetReference></DefaultValue><Prompt>End Date</Prompt></ReportParameter><ReportParameter Name="Computer"><DataType>String</DataType><Prompt>Computer</Prompt><ValidValues><DataSetReference><DataSetName>ComputerList</DataSetName><ValueField>Computer</ValueField><LabelField>Computer</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="Instance"><DataType>String</DataType><DefaultValue><DataSetReference><DataSetName>SQLINstance</DataSetName><ValueField>Instance</ValueField></DataSetReference></DefaultValue><Prompt>SQL Instance</Prompt><ValidValues><DataSetReference><DataSetName>SQLINstance</DataSetName><ValueField>Instance</ValueField><LabelField>Instance</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="SortBy"><DataType>String</DataType><DefaultValue><Values><Value>Time</Value></Values></DefaultValue><ValidValues><ParameterValues><ParameterValue><Value>Time</Value></ParameterValue><ParameterValue><Value>USerName</Value><Label>User</Label></ParameterValue><ParameterValue><Value>Reason</Value></ParameterValue></ParameterValues></ValidValues></ReportParameter><ReportParameter Name="Direction"><DataType>String</DataType><DefaultValue><Values><Value>Descending</Value></Values></DefaultValue><ValidValues><ParameterValues><ParameterValue><Value>Ascending</Value></ParameterValue><ParameterValue><Value>Descending</Value></ParameterValue></ParameterValues></ValidValues></ReportParameter></ReportParameters></Report>]]></ReportDefinition>
  </ReportItem>
  <ReportItem>
    <Name>User Connections by Day</Name>
    <Type>Report</Type>
    <Path>/Microsoft Operations Manager Reporting/Microsoft SQL Server/User Connections by Day</Path>
    <ReportDefinition><![CDATA[<?xml version='1.0' encoding='utf-8'?><Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"><rd:GridSpacing xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">0.05in</rd:GridSpacing><RightMargin>1in</RightMargin><Body><ReportItems><Textbox Name="textboxRightLogo"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/2Inch_Logo.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>6</ZIndex><Height>0.5625in</Height><Value /><Left>9in</Left></Textbox><Textbox Name="textboxReportTitle_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/9Inch_Banner.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>5</ZIndex><Height>0.5625in</Height><Width>9in</Width><CanGrow>true</CanGrow><Value>User Connections (by Day)</Value></Textbox><Textbox Name="textboxExecutionTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>4</ZIndex><Top>0.5625in</Top><Height>0.25in</Height><Value>=Globals.ExecutionTime</Value><Left>9in</Left></Textbox><Textbox Name="textboxParameterValue_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.375in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>= Parameters!Computer.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterValue_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.25in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>=Parameters!BeginDate.Value &amp; " - " &amp; Parameters!EndDate.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterName_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.375in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>Computer :</Value></Textbox><Textbox Name="textboxParameterName_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.25in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>Date Range :</Value></Textbox><Textbox Name="textboxDescription_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>GhostWhite</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.8125in</Top><ToggleImage><InitialState>true</InitialState></ToggleImage><Height>0.375in</Height><Visibility><ToggleItem>textboxDescriptionHeading_tmp</ToggleItem><Hidden>true</Hidden></Visibility><CanGrow>true</CanGrow><Value>= "This report displays SQL Server user connections by day for each SQL Server instance installed on a server.  By default this report will display data for the specified SQL Server and Instance."  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "The following rule needs to be enabled for data to be collected:"  &amp; VbCrLf &amp;  " –        Report Collection - SQL Server User Connections" </Value></Textbox><Textbox Name="textboxDescriptionHeading_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><Top>0.5625in</Top><Height>0.25in</Height><Width>9in</Width><CanGrow>true</CanGrow><Value>Description</Value></Textbox><Chart Name="chart1"><Type>Line</Type><Subtype>Plain</Subtype><Style><BackgroundColor>White</BackgroundColor></Style><Top>1.75in</Top><Height>5in</Height><ZIndex>2</ZIndex><NoRows>= "There is no data available for this report. This can occur when there is no relevant data available for collection, the reports’ dependent rules are not enabled or when none of the relevant data has been copied to the Reporting database." </NoRows><DataSetName>SQLUserConnections</DataSetName><SeriesGroupings><SeriesGrouping><DynamicSeries><Grouping Name="chart1_SeriesGroup1"><GroupExpressions><GroupExpression>=Fields!server.Value</GroupExpression></GroupExpressions></Grouping><Label>=Fields!server.Value</Label></DynamicSeries></SeriesGrouping><SeriesGrouping><StaticSeries><StaticMember><Label>User Connections</Label></StaticMember></StaticSeries></SeriesGrouping></SeriesGroupings><CategoryGroupings><CategoryGrouping><DynamicCategories><Grouping Name="chart1_CategoryGroup1"><GroupExpressions><GroupExpression>=Fields!time.Value</GroupExpression></GroupExpressions></Grouping><Label>=Fields!time.Value</Label></DynamicCategories></CategoryGrouping></CategoryGroupings><ChartData><ChartSeries><DataPoints><DataPoint><DataValues><DataValue><Value>=Sum(Fields!User_Connections.Value)</Value></DataValue></DataValues><DataLabel /><Marker /></DataPoint></DataPoints></ChartSeries></ChartData><Legend><Visible>true</Visible><Style><BorderStyle><Default>Solid</Default></BorderStyle></Style><Position>TopCenter</Position><Layout>Table</Layout></Legend><CategoryAxis><Axis><Visible>true</Visible><Style><Format>d</Format></Style><Title><Caption>Day</Caption></Title><Margin>true</Margin><MajorTickMarks>Outside</MajorTickMarks><MajorGridLines><ShowGridLines>true</ShowGridLines><Style><BorderColor><Default>Silver</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle></Style></MajorGridLines><MinorGridLines><ShowGridLines>true</ShowGridLines><Style><BorderColor><Default>Silver</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BorderWidth><Default>0.75pt</Default></BorderWidth></Style></MinorGridLines><MajorInterval>1</MajorInterval><Scalar>true</Scalar></Axis></CategoryAxis><ValueAxis><Axis><Visible>true</Visible><Title><Caption># of Users</Caption></Title><Margin>true</Margin><MajorGridLines><ShowGridLines>true</ShowGridLines><Style><BorderStyle><Default>Solid</Default></BorderStyle></Style></MajorGridLines><MinorGridLines><ShowGridLines>true</ShowGridLines><Style><BorderColor><Default>Silver</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BorderWidth><Default>0.75pt</Default></BorderWidth></Style></MinorGridLines><Scalar>true</Scalar></Axis></ValueAxis><Title /><PointWidth>0</PointWidth><Palette>Default</Palette><ThreeDProperties><Rotation>30</Rotation><Inclination>30</Inclination><Shading>Simple</Shading><WallThickness>50</WallThickness></ThreeDProperties><PlotArea><Style><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><BackgroundGradientType>TopBottom</BackgroundGradientType><BackgroundGradientEndColor>LightGrey</BackgroundGradientEndColor></Style></PlotArea></Chart></ReportItems><Style><BorderWidth><Default>0.5pt</Default></BorderWidth></Style><Height>11in</Height><ColumnSpacing>0.25in</ColumnSpacing></Body><TopMargin>1in</TopMargin><DataSources><DataSource Name="SCDW"><rd:DataSourceID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">fb44cba7-75a7-4314-b2a5-1fce44701d23</rd:DataSourceID><DataSourceReference>SCDW</DataSourceReference></DataSource></DataSources><Code>public function CurrentTimeZone() as string 
	CurrentTimeZone = System.TimeZone.CurrentTimeZone.StandardName
end function

public function FormatNumber(fieldValue, formatString) as string 
	if (fieldValue is Nothing)
		FormatNumber = "Not Available"
	else
		FormatNumber = Format(fieldValue,formatString)
	end if
end function

public function GetBeginDate(n as integer) as string 
     dim d as date
     d= dateadd(DateInterval.Day,n,now())
     GetBeginDate=d.tostring("d")
end function
public function GetEndDate(n as integer) as string 
     dim d as date
     d= dateadd(DateInterval.Day,n,now())
     GetEndDate=d.tostring("d")
end function</Code><Width>11in</Width><DataSets><DataSet Name="DateQuery"><Fields><Field Name="BeginDate"><DataField>BeginDate</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field><Field Name="EndDate"><DataField>EndDate</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT     *
FROM         fn_GetDateRange(7) fn_GetDateRange</CommandText><Timeout>0</Timeout></Query></DataSet><DataSet Name="SQLUserConnections"><Fields><Field Name="server"><DataField>Server</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="Instance"><DataField>Instance</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="time"><DataField>time</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.DateTime</TypeName></Field><Field Name="User_Connections"><DataField>User Connections</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Decimal</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT     Server, Instance, time, CAST(AVG([User Connections]) AS Decimal(15, 2)) AS [User Connections]
FROM         (SELECT     CD.FullComputerName AS [Server], [Instance] = CASE WHEN (CDD.ObjectName_PK LIKE 'SQLServer%') 
                                              THEN 'MS' + substring(ObjectName_PK, CHARINDEX('S', ObjectName_PK, 1), CHARINDEX(':', ObjectName_PK, 1) - CHARINDEX('S', 
                                              ObjectName_PK, 1)) ELSE CASE WHEN (CDD.ObjectName_PK LIKE 'MSSQL$%') THEN substring(ObjectName_PK, CHARINDEX('$', 
                                              ObjectName_PK, 1) + 1, CHARINDEX(':', ObjectName_PK, 1) - (CHARINDEX('$', ObjectName_PK, 1) + 1)) END END, 
                                              CDD.InstanceName_PK AS [InstanceName], DD.Date AS [time], CASE WHEN (CDD.ObjectName_PK LIKE '%:General Statistics' AND 
                                              CDD.CounterName_PK = 'User Connections') THEN SND.SampleValue END AS [User Connections]
                       FROM          dbo.SC_SampledNumericDataFact_View SND INNER JOIN
                                              dbo.SC_DateDimension_View DD ON DD.SMC_InstanceID = SND.LocalDatesampled_FK INNER JOIN
                                              dbo.SC_CounterDetailDimension_View CDD ON CDD.SMC_InstanceID = SND.CounterDetail_FK INNER JOIN
                                              dbo.SC_ComputerDimension_View CD ON CD.SMC_InstanceID = SND.Computer_FK
                       WHERE      CDD.ObjectName_PK LIKE ('%:General Statistics') AND CDD.CounterName_PK IN ('User Connections') AND DD.Date BETWEEN 
                                              @BeginDate AND @EndDate AND CD.FullComputerName = @Computer) tmp
WHERE     (Instance = @Instance)
GROUP BY Server, Instance, time</CommandText><QueryParameters><QueryParameter Name="@BeginDate"><Value>=Parameters!BeginDateTime.Value</Value></QueryParameter><QueryParameter Name="@EndDate"><Value>=Parameters!EndDateTime.Value</Value></QueryParameter><QueryParameter Name="@Computer"><Value>=Parameters!Computer.Value</Value></QueryParameter><QueryParameter Name="@Instance"><Value>=Parameters!Instance.Value</Value></QueryParameter></QueryParameters><Timeout>3000000</Timeout></Query></DataSet><DataSet Name="ComputerList"><Fields><Field Name="Computer"><DataField>Computer</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="ComputerID"><DataField>ComputerID</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Guid</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT DISTINCT SourceClassInstanceKeyValue AS Computer, SourceClassInstanceID AS ComputerID
FROM         [SC_Class_Rel_Computer-SQLInstance_View]
ORDER BY SourceClassInstanceKeyValue</CommandText><Timeout>3000000</Timeout></Query></DataSet><DataSet Name="SQLInstance"><Fields><Field Name="Instance"><DataField>Instance</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT DISTINCT TargetClassInstanceKeyValue AS Instance
FROM         [SC_Class_Rel_Computer-SQLInstance_View]
WHERE     (SourceClassInstanceKeyValue = @Computer)
ORDER BY TargetClassInstanceKeyValue</CommandText><QueryParameters><QueryParameter Name="@Computer"><Value>=Parameters!Computer.Value</Value></QueryParameter></QueryParameters><Timeout>40000000</Timeout></Query></DataSet></DataSets><LeftMargin>1in</LeftMargin><rd:SnapToGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:SnapToGrid><rd:DrawGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:DrawGrid><Description /><PageWidth>13in</PageWidth><rd:ReportID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">212d782b-9718-4b8d-a1c1-2bd72afd7b82</rd:ReportID><PageFooter><ReportItems><Textbox Name="textboxPageNumber_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.2in</Top><Height>0.25in</Height><Value>="Page " &amp; Globals.PageNumber &amp; "/" &amp; Globals.TotalPages</Value><Left>4in</Left></Textbox><Textbox Name="textbox1DateTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><Top>0.2in</Top><Height>0.25in</Height><Width>4in</Width><Value>="All dates and  times shown in " &amp; Code.CurrentTimeZone()</Value></Textbox></ReportItems><PrintOnLastPage>true</PrintOnLastPage><PrintOnFirstPage>true</PrintOnFirstPage><Style /><Height>0.5in</Height></PageFooter><BottomMargin>1in</BottomMargin><ReportParameters><ReportParameter Name="BeginDate"><DataType>String</DataType><DefaultValue><Values><Value>=Code.GetBeginDate(-7)</Value></Values></DefaultValue><Prompt>Begin Date</Prompt></ReportParameter><ReportParameter Name="EndDate"><DataType>String</DataType><DefaultValue><Values><Value>=Code.GetEndDate(0)</Value></Values></DefaultValue><Prompt>End Date</Prompt></ReportParameter><ReportParameter Name="BeginDateTime"><DataType>DateTime</DataType><DefaultValue><Values><Value>=System.DateTime.Parse( Parameters!BeginDate.Value)</Value></Values></DefaultValue><AllowBlank>true</AllowBlank></ReportParameter><ReportParameter Name="EndDateTime"><DataType>DateTime</DataType><DefaultValue><Values><Value>=System.DateTime.Parse( Parameters!EndDate.Value)</Value></Values></DefaultValue><AllowBlank>true</AllowBlank></ReportParameter><ReportParameter Name="Computer"><DataType>String</DataType><Prompt>Computer</Prompt><ValidValues><DataSetReference><DataSetName>ComputerList</DataSetName><ValueField>Computer</ValueField><LabelField>Computer</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="Instance"><DataType>String</DataType><DefaultValue><DataSetReference><DataSetName>SQLInstance</DataSetName><ValueField>Instance</ValueField></DataSetReference></DefaultValue><Prompt>SQL Instance</Prompt><ValidValues><DataSetReference><DataSetName>SQLInstance</DataSetName><ValueField>Instance</ValueField><LabelField>Instance</LabelField></DataSetReference></ValidValues></ReportParameter></ReportParameters></Report>]]></ReportDefinition>
  </ReportItem>
  <ReportItem>
    <Name>User Connections by Peak Hour</Name>
    <Type>Report</Type>
    <Path>/Microsoft Operations Manager Reporting/Microsoft SQL Server/User Connections by Peak Hour</Path>
    <ReportDefinition><![CDATA[<?xml version='1.0' encoding='utf-8'?><Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"><rd:GridSpacing xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">0.05in</rd:GridSpacing><RightMargin>1in</RightMargin><Body><ReportItems><Textbox Name="textboxRightLogo"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/2Inch_Logo.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>6</ZIndex><Height>0.5625in</Height><Value /><Left>9in</Left></Textbox><Textbox Name="textboxReportTitle_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderWidth><Default>0.25pt</Default></BorderWidth><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>11pt</FontSize><BackgroundImage><BackgroundRepeat>NoRepeat</BackgroundRepeat><Source>External</Source><Value>/Microsoft Operations Manager Reporting/Images/9Inch_Banner.png</Value></BackgroundImage><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>5</ZIndex><Height>0.5625in</Height><Width>9in</Width><CanGrow>true</CanGrow><Value>User Connections (by Peak Hour)</Value></Textbox><Textbox Name="textboxExecutionTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><Color>#000000</Color><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>4</ZIndex><Top>0.5625in</Top><Height>0.25in</Height><Value>=Globals.ExecutionTime</Value><Left>9in</Left></Textbox><Textbox Name="textboxParameterValue_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.375in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>= Parameters!Computer.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterValue_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Left</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>3</ZIndex><Top>1.25in</Top><Height>0.125in</Height><CanGrow>true</CanGrow><Value>=Parameters!BeginDate.Value &amp; " - " &amp; Parameters!EndDate.Value</Value><Left>3in</Left></Textbox><Textbox Name="textboxParameterName_tmp1"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.375in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>Computer :</Value></Textbox><Textbox Name="textboxParameterName_tmp0"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><ZIndex>2</ZIndex><Top>1.25in</Top><Height>0.125in</Height><Width>3in</Width><CanGrow>true</CanGrow><Value>Date Range :</Value></Textbox><Textbox Name="textboxDescription_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>GhostWhite</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.8125in</Top><ToggleImage><InitialState>true</InitialState></ToggleImage><Height>0.375in</Height><Visibility><ToggleItem>textboxDescriptionHeading_tmp</ToggleItem><Hidden>true</Hidden></Visibility><CanGrow>true</CanGrow><Value>= "This report displays SQL Server user connections by peak hours for each SQL Server instance installed on a server.  By default this report will display data for specified SQL Server and Instance."  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  ""  &amp; VbCrLf &amp;  "The following rule needs to be enabled for data to be collected:"  &amp; VbCrLf &amp;  " –        Report Collection - SQL Server User Connections" </Value></Textbox><Textbox Name="textboxDescriptionHeading_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight><FontWeight>700</FontWeight></Style><Top>0.5625in</Top><Height>0.25in</Height><Width>9in</Width><CanGrow>true</CanGrow><Value>Description</Value></Textbox><Chart Name="chart1"><Type>Line</Type><Subtype>Plain</Subtype><Style><BackgroundColor>White</BackgroundColor></Style><Top>1.75in</Top><Height>5in</Height><ZIndex>7</ZIndex><NoRows>= "There is no data available for this report. This can occur when there is no relevant data available for collection, the reports’ dependent rules are not enabled or when none of the relevant data has been copied to the Reporting database." </NoRows><DataSetName>SQLUserConnections</DataSetName><SeriesGroupings><SeriesGrouping><DynamicSeries><Grouping Name="chart1_SeriesGroup1"><GroupExpressions><GroupExpression>=Fields!ComputerName_PK.Value</GroupExpression></GroupExpressions></Grouping><Label>=Fields!ComputerName_PK.Value</Label></DynamicSeries></SeriesGrouping><SeriesGrouping><StaticSeries><StaticMember><Label>User Connections</Label></StaticMember></StaticSeries></SeriesGrouping></SeriesGroupings><CategoryGroupings><CategoryGrouping><DynamicCategories><Grouping Name="chart1_CategoryGroup1"><GroupExpressions><GroupExpression>=Fields!ComputerName_PK.Value</GroupExpression><GroupExpression>=Fields!time.Value</GroupExpression></GroupExpressions></Grouping><Label>=Fields!timename.Value</Label></DynamicCategories></CategoryGrouping></CategoryGroupings><ChartData><ChartSeries><DataPoints><DataPoint><DataValues><DataValue><Value>=Sum(Fields!User_Connections.Value)</Value></DataValue></DataValues><DataLabel /><Marker><Type>Auto</Type><Size>6pt</Size></Marker></DataPoint></DataPoints></ChartSeries></ChartData><Legend><Visible>true</Visible><Style><BorderStyle><Default>Solid</Default></BorderStyle></Style><Position>TopCenter</Position><Layout>Table</Layout></Legend><CategoryAxis><Axis><Visible>true</Visible><Style><Format>g</Format></Style><Title><Caption>Time</Caption></Title><Margin>true</Margin><MajorTickMarks>Outside</MajorTickMarks><MajorGridLines><ShowGridLines>true</ShowGridLines><Style><BorderColor><Default>Silver</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BorderWidth><Default>0.75pt</Default></BorderWidth></Style></MajorGridLines><MinorGridLines><Style><BorderStyle><Default>Solid</Default></BorderStyle></Style></MinorGridLines></Axis></CategoryAxis><ValueAxis><Axis><Visible>true</Visible><Title><Caption>Number of Users</Caption></Title><Margin>true</Margin><MajorGridLines><ShowGridLines>true</ShowGridLines><Style><BorderStyle><Default>Solid</Default></BorderStyle></Style></MajorGridLines><MinorGridLines><ShowGridLines>true</ShowGridLines><Style><BorderColor><Default>Silver</Default></BorderColor><BorderStyle><Default>Solid</Default></BorderStyle><BorderWidth><Default>0.75pt</Default></BorderWidth></Style></MinorGridLines><Scalar>true</Scalar></Axis></ValueAxis><Title /><PointWidth>0</PointWidth><Palette>Default</Palette><ThreeDProperties><Rotation>30</Rotation><Inclination>30</Inclination><Shading>Simple</Shading><WallThickness>50</WallThickness></ThreeDProperties><PlotArea><Style><BorderStyle><Default>Solid</Default></BorderStyle><BackgroundColor>WhiteSmoke</BackgroundColor><BackgroundGradientType>TopBottom</BackgroundGradientType><BackgroundGradientEndColor>LightGrey</BackgroundGradientEndColor></Style></PlotArea></Chart></ReportItems><Style><BorderWidth><Default>0.5pt</Default></BorderWidth></Style><Height>11in</Height><ColumnSpacing>0.25in</ColumnSpacing></Body><TopMargin>1in</TopMargin><DataSources><DataSource Name="SCDW"><rd:DataSourceID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">fb44cba7-75a7-4314-b2a5-1fce44701d23</rd:DataSourceID><DataSourceReference>SCDW</DataSourceReference></DataSource></DataSources><Code>public function CurrentTimeZone() as string 
	CurrentTimeZone = System.TimeZone.CurrentTimeZone.StandardName
end function

public function FormatNumber(fieldValue, formatString) as string 
	if (fieldValue is Nothing)
		FormatNumber = "Not Available"
	else
		FormatNumber = Format(fieldValue,formatString)
	end if
end function

public function GetBeginDate(n as integer) as string 
     dim d as date
     d= dateadd(DateInterval.Day,n,now())
     GetBeginDate=d.tostring("d")
end function
public function GetEndDate(n as integer) as string 
     dim d as date
     d= dateadd(DateInterval.Day,n,now())
     GetEndDate=d.tostring("d")
end function</Code><Width>11in</Width><DataSets><DataSet Name="ComputerList"><Fields><Field Name="Computer"><DataField>Computer</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="ComputerID"><DataField>ComputerID</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Guid</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT DISTINCT SourceClassInstanceKeyValue AS Computer, SourceClassInstanceID AS ComputerID
FROM         [SC_Class_Rel_Computer-SQLInstance_View]
ORDER BY SourceClassInstanceKeyValue</CommandText><Timeout>0</Timeout></Query></DataSet><DataSet Name="SQLUserConnections"><Fields><Field Name="ComputerName_PK"><DataField>ComputerName_PK</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="time"><DataField>time</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Int32</TypeName></Field><Field Name="timename"><DataField>timename</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="User_Connections"><DataField>User Connections</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Decimal</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT     ComputerName_PK, Hour_PK AS time, MAX(CASE WHEN Hour_PK = 0 THEN '12pm' WHEN Hour_PK &lt; 12 THEN CAST(Hour_PK AS nvarchar(2)) 
                      + 'am' WHEN Hour_PK = 12 THEN '12pm' ELSE CAST(Hour_PK - 12 AS nvarchar(2)) + 'pm' END) AS timename, CAST(AVG(SampleValue) AS Decimal(15, 
                      2)) AS [User Connections]
FROM         (SELECT     CD.FullComputerName AS ComputerName_PK, TD.Hour_PK, TD.Hour_PK AS Time, 
                                              [Instance] = CASE WHEN (CDD.ObjectName_PK LIKE 'SQLServer%') THEN 'MS' + substring(ObjectName_PK, CHARINDEX('S', 
                                              ObjectName_PK, 1), CHARINDEX(':', ObjectName_PK, 1) - CHARINDEX('S', ObjectName_PK, 1)) 
                                              ELSE CASE WHEN (CDD.ObjectName_PK LIKE 'MSSQL$%') THEN substring(ObjectName_PK, CHARINDEX('$', ObjectName_PK, 1) + 1, 
                                              CHARINDEX(':', ObjectName_PK, 1) - (CHARINDEX('$', ObjectName_PK, 1) + 1)) END END, CDD.ScaleFactor, SND.SampleValue
                       FROM          SC_SampledNumericDataFact_View SND INNER JOIN
                                              SC_DateDimension_View DD ON DD.SMC_InstanceID = SND.LocalDateSampled_FK INNER JOIN
                                              SC_TimeDimension_View TD ON TD.SMC_InstanceID = SND.LocalTimeSampled_FK INNER JOIN
                                              SC_ComputerDimension_View CD ON SND.Computer_FK = CD.SMC_InstanceID INNER JOIN
                                              SC_CounterDetailDimension_View CDD ON CDD.SMC_InstanceID = SND.CounterDetail_FK
                       WHERE      CD.FullComputerName = @Computer AND (CDD.ObjectName_PK LIKE '%:General Statistics') AND 
                                              (CDD.CounterName_PK IN ('User Connections')) AND (DD.Date BETWEEN @BeginDate AND @EndDate) AND (TD.Hour_PK BETWEEN 
                                              @BeginTime AND @EndTime)) TEMP
WHERE     ([Instance] = @Instance)
GROUP BY ComputerName_PK, [Instance], Hour_PK
ORDER BY Hour_PK</CommandText><QueryParameters><QueryParameter Name="@Computer"><Value>=Parameters!Computer.Value</Value></QueryParameter><QueryParameter Name="@BeginDate"><Value>=Parameters!BeginDateTime.Value</Value></QueryParameter><QueryParameter Name="@EndDate"><Value>=Parameters!EndDateTime.Value</Value></QueryParameter><QueryParameter Name="@BeginTime"><Value>=Parameters!BeginTime.Value</Value></QueryParameter><QueryParameter Name="@EndTime"><Value>=Parameters!EndTime.Value</Value></QueryParameter><QueryParameter Name="@Instance"><Value>=Parameters!Instance.Value</Value></QueryParameter></QueryParameters><Timeout>3000000</Timeout></Query></DataSet><DataSet Name="HoursInDay"><Fields><Field Name="hourname"><DataField>hourname</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field><Field Name="hour"><DataField>hour</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.Int32</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT     hourname, hour
FROM         (SELECT     '12am' AS [hourname], 0 AS [hour]
                       UNION
                       SELECT     '1am', 1
                       UNION
                       SELECT     '2am', 2
                       UNION
                       SELECT     '3am', 3
                       UNION
                       SELECT     '4am', 4
                       UNION
                       SELECT     '5am', 5
                       UNION
                       SELECT     '6am', 6
                       UNION
                       SELECT     '7am', 7
                       UNION
                       SELECT     '8am', 8
                       UNION
                       SELECT     '9am', 9
                       UNION
                       SELECT     '10am', 10
                       UNION
                       SELECT     '11am', 11
                       UNION
                       SELECT     '12pm', 12
                       UNION
                       SELECT     '1pm', 13
                       UNION
                       SELECT     '2pm', 14
                       UNION
                       SELECT     '3pm', 15
                       UNION
                       SELECT     '4pm', 16
                       UNION
                       SELECT     '5pm', 17
                       UNION
                       SELECT     '6pm', 18
                       UNION
                       SELECT     '7pm', 19
                       UNION
                       SELECT     '8pm', 20
                       UNION
                       SELECT     '9pm', 21
                       UNION
                       SELECT     '10pm', 22
                       UNION
                       SELECT     '11pm', 23) DERIVEDTBL
ORDER BY hour</CommandText><Timeout>300000</Timeout></Query></DataSet><DataSet Name="SQLInstance"><Fields><Field Name="Instance"><DataField>Instance</DataField><TypeName xmlns="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">System.String</TypeName></Field></Fields><Query><DataSourceName>SCDW</DataSourceName><CommandText>SELECT DISTINCT TargetClassInstanceKeyValue AS Instance
FROM         [SC_Class_Rel_Computer-SQLInstance_View]
WHERE     (SourceClassInstanceKeyValue = @Computer)
ORDER BY TargetClassInstanceKeyValue</CommandText><QueryParameters><QueryParameter Name="@Computer"><Value>=Parameters!Computer.Value</Value></QueryParameter></QueryParameters><Timeout>30000000</Timeout></Query></DataSet></DataSets><LeftMargin>1in</LeftMargin><rd:SnapToGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:SnapToGrid><rd:DrawGrid xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">true</rd:DrawGrid><Description /><PageWidth>13in</PageWidth><rd:ReportID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">212d782b-9718-4b8d-a1c1-2bd72afd7b82</rd:ReportID><PageFooter><ReportItems><Textbox Name="textboxPageNumber_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><TextAlign>Right</TextAlign><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><ZIndex>1</ZIndex><Top>0.2in</Top><Height>0.25in</Height><Value>="Page " &amp; Globals.PageNumber &amp; "/" &amp; Globals.TotalPages</Value><Left>4in</Left></Textbox><Textbox Name="textbox1DateTime_tmp"><Style><PaddingLeft>2pt</PaddingLeft><FontFamily>Verdana</FontFamily><BackgroundColor>WhiteSmoke</BackgroundColor><BorderColor><Default>LightGrey</Default></BorderColor><BorderStyle><Bottom>None</Bottom><Top>None</Top><Left>None</Left></BorderStyle><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingTop>2pt</PaddingTop><PaddingRight>2pt</PaddingRight></Style><Top>0.2in</Top><Height>0.25in</Height><Width>4in</Width><Value>="All dates and  times shown in " &amp; Code.CurrentTimeZone()</Value></Textbox></ReportItems><PrintOnLastPage>true</PrintOnLastPage><PrintOnFirstPage>true</PrintOnFirstPage><Style /><Height>0.5in</Height></PageFooter><BottomMargin>1in</BottomMargin><ReportParameters><ReportParameter Name="BeginDate"><DataType>String</DataType><DefaultValue><Values><Value>=Code.GetBeginDate(-7)</Value></Values></DefaultValue><Prompt>Begin Date</Prompt></ReportParameter><ReportParameter Name="EndDate"><DataType>String</DataType><DefaultValue><Values><Value>=Code.GetEndDate(0)</Value></Values></DefaultValue><Prompt>End Date</Prompt></ReportParameter><ReportParameter Name="BeginDateTime"><DataType>DateTime</DataType><Nullable>true</Nullable><DefaultValue><Values><Value>=System.DateTime.Parse( Parameters!BeginDate.Value)</Value></Values></DefaultValue><AllowBlank>true</AllowBlank></ReportParameter><ReportParameter Name="EndDateTime"><DataType>DateTime</DataType><DefaultValue><Values><Value>=System.DateTime.Parse( Parameters!EndDate.Value)</Value></Values></DefaultValue><AllowBlank>true</AllowBlank></ReportParameter><ReportParameter Name="BeginTime"><DataType>String</DataType><DefaultValue><Values><Value>7</Value></Values></DefaultValue><Prompt>BeginTime</Prompt><ValidValues><DataSetReference><DataSetName>HoursInDay</DataSetName><ValueField>hour</ValueField><LabelField>hourname</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="EndTime"><DataType>String</DataType><DefaultValue><Values><Value>19</Value></Values></DefaultValue><Prompt>EndTime</Prompt><ValidValues><DataSetReference><DataSetName>HoursInDay</DataSetName><ValueField>hour</ValueField><LabelField>hourname</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="Computer"><DataType>String</DataType><Prompt>Computer</Prompt><ValidValues><DataSetReference><DataSetName>ComputerList</DataSetName><ValueField>Computer</ValueField><LabelField>Computer</LabelField></DataSetReference></ValidValues></ReportParameter><ReportParameter Name="Instance"><DataType>String</DataType><DefaultValue><DataSetReference><DataSetName>SQLInstance</DataSetName><ValueField>Instance</ValueField></DataSetReference></DefaultValue><Prompt>SQL Instance</Prompt><ValidValues><DataSetReference><DataSetName>SQLInstance</DataSetName><ValueField>Instance</ValueField><LabelField>Instance</LabelField></DataSetReference></ValidValues></ReportParameter></ReportParameters></Report>]]></ReportDefinition>
  </ReportItem>
  <ReportItem>
    <Name>SCDW</Name>
    <Type>DataSource</Type>
    <Path>/Microsoft Operations Manager Reporting/Microsoft SQL Server/SCDW</Path>
    <DataSourceDefinitionContainer><![CDATA[<?xml version="1.0"?>
<DataSourceDefinition xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <Extension xmlns="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices">SQL</Extension>
  <ConnectString xmlns="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices">data source=.;initial catalog=SystemCenterReporting</ConnectString>
  <CredentialRetrieval xmlns="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices">Integrated</CredentialRetrieval>
  <WindowsCredentials xmlns="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices">false</WindowsCredentials>
  <ImpersonateUser xmlns="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices">false</ImpersonateUser>
  <Prompt xmlns="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices">Enter a user name and password to access the data source:</Prompt>
  <Enabled xmlns="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices">true</Enabled>
</DataSourceDefinition>]]></DataSourceDefinitionContainer>
  </ReportItem>
</ReportCollection>