<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
  <Body>
    <ReportItems>
      <Tablix Name="Tablix1">
        <TablixBody>
          <TablixColumns>
            <TablixColumn>
              <Width>4.31666in</Width>
            </TablixColumn>
            <TablixColumn>
              <Width>6.21666in</Width>
            </TablixColumn>
          </TablixColumns>
          <TablixRows>
            <TablixRow>
              <Height>0.39583in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox2">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>="Virtual Log File Count - " + First(Fields!ServerName.Value, "ServerName")</Value>
                              <Style>
                                <FontSize>18pt</FontSize>
                                <Color>White</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style>
                            <TextAlign>Left</TextAlign>
                          </Style>
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox2</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>MidnightBlue</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>DarkBlue</BackgroundColor>
                        <VerticalAlign>Middle</VerticalAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                    <ColSpan>2</ColSpan>
                  </CellContents>
                </TablixCell>
                <TablixCell />
              </TablixCells>
            </TablixRow>
            <TablixRow>
              <Height>0.29584in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox6">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Click Here to see the Query</Value>
                              <ActionInfo>
                                <Actions>
                                  <Action>
                                    <Drillthrough>
                                      <ReportName>DatabaseVirtualLogFileCode</ReportName>
                                    </Drillthrough>
                                  </Action>
                                </Actions>
                              </ActionInfo>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>DarkBlue</Color>
                              </Style>
                            </TextRun>
                            <TextRun>
                              <Value xml:space="preserve">   </Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>DarkBlue</Color>
                              </Style>
                            </TextRun>
                            <TextRun>
                              <Value>|</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>Gray</Color>
                              </Style>
                            </TextRun>
                            <TextRun>
                              <Value xml:space="preserve">   </Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>DarkBlue</Color>
                              </Style>
                            </TextRun>
                            <TextRun>
                              <Value>Go To Report Library</Value>
                              <ActionInfo>
                                <Actions>
                                  <Action>
                                    <Drillthrough>
                                      <ReportName>ReportLibrary</ReportName>
                                    </Drillthrough>
                                  </Action>
                                </Actions>
                              </ActionInfo>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>DarkBlue</Color>
                              </Style>
                            </TextRun>
                            <TextRun>
                              <Value xml:space="preserve">    </Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>DarkBlue</Color>
                              </Style>
                            </TextRun>
                            <TextRun>
                              <Value>| </Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>Gray</Color>
                              </Style>
                            </TextRun>
                            <TextRun>
                              <Value xml:space="preserve">   </Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>DarkBlue</Color>
                              </Style>
                            </TextRun>
                            <TextRun>
                              <Value>Go To Main Report</Value>
                              <ActionInfo>
                                <Actions>
                                  <Action>
                                    <Drillthrough>
                                      <ReportName>=IIF(First(Fields!ProductMajorVersion.Value, "Version") = 10 and First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5, "MainReport2008", 
IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, Nothing, 
IIF(First(Fields!ProductMajorVersion.Value, "Version") &gt; 10 and First(Fields!EngineEdition.Value, "ServerProperty") &lt;&gt; 5, "MainReport", Nothing)))</ReportName>
                                    </Drillthrough>
                                  </Action>
                                </Actions>
                              </ActionInfo>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>=IIF(First(Fields!ProductMajorVersion.Value, "Version") = 10, "DarkBlue", IIF(First(Fields!EngineEdition.Value, "ServerProperty") = 5, "LightSteelBlue", "DarkBlue"))</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style>
                            <TextAlign>Left</TextAlign>
                          </Style>
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox6</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>MidnightBlue</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>LightSteelBlue</BackgroundColor>
                        <VerticalAlign>Middle</VerticalAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                    <ColSpan>2</ColSpan>
                  </CellContents>
                </TablixCell>
                <TablixCell />
              </TablixCells>
            </TablixRow>
            <TablixRow>
              <Height>0.3125in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox1">
                      <CanGrow>true</CanGrow>
                      <UserSort>
                        <SortExpression>=Fields!dbname.Value</SortExpression>
                      </UserSort>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Database Name</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>White</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style>
                            <TextAlign>Left</TextAlign>
                          </Style>
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox1</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>MidnightBlue</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>DimGray</BackgroundColor>
                        <VerticalAlign>Middle</VerticalAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox3">
                      <CanGrow>true</CanGrow>
                      <UserSort>
                        <SortExpression>=Fields!vlfcount.Value</SortExpression>
                      </UserSort>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>VLF Count</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>White</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style>
                            <TextAlign>Left</TextAlign>
                          </Style>
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox3</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>MidnightBlue</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>DimGray</BackgroundColor>
                        <VerticalAlign>Middle</VerticalAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
              </TablixCells>
            </TablixRow>
            <TablixRow>
              <Height>0.29584in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="dbname">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Fields!dbname.Value</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>dbname</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>MidnightBlue</Color>
                          <Style>Solid</Style>
                        </Border>
                        <TopBorder>
                          <Style>Solid</Style>
                        </TopBorder>
                        <BottomBorder>
                          <Style>Solid</Style>
                        </BottomBorder>
                        <LeftBorder>
                          <Style>Solid</Style>
                        </LeftBorder>
                        <RightBorder>
                          <Style>Solid</Style>
                        </RightBorder>
                        <BackgroundColor>=IIF(ROWNUMBER(NOTHING) MOD 2, "LIGHTBLUE", "SILVER")</BackgroundColor>
                        <VerticalAlign>Middle</VerticalAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="vlfcount">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Fields!vlfcount.Value</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>=IIF(Fields!vlfcount.Value &lt; 300, "Black",IIF(Fields!vlfcount.Value &gt;=1000, "White", IIF(Fields!vlfcount.Value &gt;= 300, "Black", "Black")))</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style>
                            <TextAlign>Left</TextAlign>
                          </Style>
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>vlfcount</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>MidnightBlue</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>=IIF(Fields!vlfcount.Value &lt; 300, IIF(ROWNUMBER(NOTHING) MOD 2, "LIGHTBLUE", "SILVER"),IIF(Fields!vlfcount.Value &gt;=1000, "Red", IIF(Fields!vlfcount.Value &gt;= 300, "Yellow", "Yellow")))</BackgroundColor>
                        <VerticalAlign>Middle</VerticalAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
              </TablixCells>
            </TablixRow>
            <TablixRow>
              <Height>0.325in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox4">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Code is From: https://gallery.technet.microsoft.com/scriptcenter/SQL-Script-to-list-VLF-e6315249-- Kev Riley</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>DarkBlue</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style>
                            <TextAlign>Left</TextAlign>
                          </Style>
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox4</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>MidnightBlue</Color>
                          <Style>Solid</Style>
                        </Border>
                        <TopBorder>
                          <Style>Solid</Style>
                        </TopBorder>
                        <BottomBorder>
                          <Style>Solid</Style>
                        </BottomBorder>
                        <LeftBorder>
                          <Style>Solid</Style>
                        </LeftBorder>
                        <RightBorder>
                          <Style>Solid</Style>
                        </RightBorder>
                        <BackgroundColor>LightSteelBlue</BackgroundColor>
                        <VerticalAlign>Middle</VerticalAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                    <ColSpan>2</ColSpan>
                  </CellContents>
                </TablixCell>
                <TablixCell />
              </TablixCells>
            </TablixRow>
            <TablixRow>
              <Height>0.375in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox5">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>="End Of Report                  Completed By: " &amp; UCASE(User!UserID) &amp; " on " &amp; Globals!ExecutionTime</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>White</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style>
                            <TextAlign>Left</TextAlign>
                          </Style>
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox5</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>MidnightBlue</Color>
                          <Style>Solid</Style>
                        </Border>
                        <TopBorder>
                          <Style>Solid</Style>
                        </TopBorder>
                        <BottomBorder>
                          <Style>Solid</Style>
                        </BottomBorder>
                        <LeftBorder>
                          <Style>Solid</Style>
                        </LeftBorder>
                        <RightBorder>
                          <Style>Solid</Style>
                        </RightBorder>
                        <BackgroundColor>DarkBlue</BackgroundColor>
                        <VerticalAlign>Middle</VerticalAlign>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                    <ColSpan>2</ColSpan>
                  </CellContents>
                </TablixCell>
                <TablixCell />
              </TablixCells>
            </TablixRow>
          </TablixRows>
        </TablixBody>
        <TablixColumnHierarchy>
          <TablixMembers>
            <TablixMember />
            <TablixMember />
          </TablixMembers>
        </TablixColumnHierarchy>
        <TablixRowHierarchy>
          <TablixMembers>
            <TablixMember>
              <KeepWithGroup>After</KeepWithGroup>
            </TablixMember>
            <TablixMember>
              <KeepWithGroup>After</KeepWithGroup>
            </TablixMember>
            <TablixMember>
              <KeepWithGroup>After</KeepWithGroup>
            </TablixMember>
            <TablixMember>
              <Group Name="Details" />
            </TablixMember>
            <TablixMember>
              <KeepWithGroup>Before</KeepWithGroup>
            </TablixMember>
            <TablixMember>
              <KeepWithGroup>Before</KeepWithGroup>
            </TablixMember>
          </TablixMembers>
        </TablixRowHierarchy>
        <DataSetName>VLF</DataSetName>
        <Height>2.00001in</Height>
        <Width>10.53332in</Width>
        <Style>
          <Border>
            <Style>Solid</Style>
          </Border>
          <BackgroundColor>#605959</BackgroundColor>
          <Color>Yellow</Color>
        </Style>
      </Tablix>
    </ReportItems>
    <Height>2.05834in</Height>
    <Style />
  </Body>
  <Width>10.63749in</Width>
  <Page>
    <PageHeight>36in</PageHeight>
    <LeftMargin>1in</LeftMargin>
    <RightMargin>1in</RightMargin>
    <TopMargin>1in</TopMargin>
    <BottomMargin>1in</BottomMargin>
    <Style />
  </Page>
  <AutoRefresh>0</AutoRefresh>
  <DataSources>
    <DataSource Name="DataSource1">
      <ConnectionProperties>
        <DataProvider>SQL</DataProvider>
        <ConnectString>Data Source=localhost</ConnectString>
        <IntegratedSecurity>true</IntegratedSecurity>
      </ConnectionProperties>
      <rd:SecurityType>Integrated</rd:SecurityType>
      <rd:DataSourceID>d7ed32ce-08a8-4ef9-8302-0c606bf505c7</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <DataSets>
    <DataSet Name="VLF">
      <Query>
        <DataSourceName>DataSource1</DataSourceName>
        <CommandText>--From https://gallery.technet.microsoft.com/scriptcenter/SQL-Script-to-list-VLF-e6315249
-- Kev Riley

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

DECLARE @query VARCHAR(100) 
DECLARE @dbname SYSNAME 
DECLARE @vlfs INT /*table variable used to 'loop' over databases  */ 
DECLARE @databases TABLE (dbname SYSNAME)
    INSERT  
    INTO   @databases
            /*only choose online databases  */ 
			SELECT name
            FROM     sys.databases
            WHERE  state = 0 /*table variable to hold results  */
DECLARE @vlfcounts TABLE (dbname SYSNAME, vlfcount INT) 
/*changes in the output of DBCC loginfo from SQL2012 mean we have to determine the version */ 
DECLARE @MajorVersion TINYINT
SET @MajorVersion = LEFT(CAST(SERVERPROPERTY('ProductVersion') AS NVARCHAR(MAX))
				, CHARINDEX('.', CAST(SERVERPROPERTY('ProductVersion') AS NVARCHAR(MAX))) - 1) 
IF @MajorVersion &lt; 11 /* pre-SQL2012 */ 
BEGIN 
DECLARE @dbccloginfo TABLE (fileid SMALLINT, 
							file_size BIGINT, 
							start_offset BIGINT, 
							fseqno INT, 
							[status] TINYINT, 
							parity TINYINT, 
							create_lsn NUMERIC(25, 0)) 
WHILE EXISTS
    (SELECT TOP 1 dbname
     FROM      @databases) 
	BEGIN
		SET          @dbname =
					(SELECT TOP 1 dbname
					 FROM      @databases)
		SET @query = 'DBCC LOGINFO (' + '''' + @dbname + ''') '
			INSERT  
			INTO @dbccloginfo 
			EXEC (@query)
		SET  @vlfs = @@rowcount 
		INSERT @vlfcounts
		VALUES (@dbname,@vlfs)
			DELETE FROM @databases
		WHERE  dbname = @dbname 
	END /*while */ 
END 
ELSE 
BEGIN 
DECLARE @dbccloginfo2012 TABLE 
				(RecoveryUnitId INT, 
				 fileid SMALLINT, 
				 file_size BIGINT, 
				 start_offset BIGINT, 
				 fseqno INT, 
				 [status] TINYINT, 
				 parity TINYINT, 
                 create_lsn NUMERIC(25, 0)) 
	WHILE EXISTS
        (SELECT TOP 1 dbname
            FROM      @databases)
		BEGIN
			SET   @dbname =
				(SELECT TOP 1 dbname
				 FROM      @databases)
			SET  @query = 'DBCC LOGINFO (' + '''' + @dbname + ''') '
				INSERT  
				INTO @dbccloginfo2012 
				EXEC (@query)
			SET  @vlfs = @@ROWCOUNT 
			INSERT @vlfcounts
				VALUES (@dbname,@vlfs)
			DELETE FROM @databases
			WHERE  dbname = @dbname 
		END /*while */ 
END

/*output the full list  */ 
SELECT 'Virtual Log File Counts' AS 'Status', dbname, vlfcount
FROM     @vlfcounts
ORDER BY vlfcount DESC</CommandText>
      </Query>
      <Fields>
        <Field Name="Status">
          <DataField>Status</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="dbname">
          <DataField>dbname</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="vlfcount">
          <DataField>vlfcount</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="ServerName">
      <Query>
        <DataSourceName>DataSource1</DataSourceName>
        <CommandText>Select @@servername AS 'ServerName'</CommandText>
      </Query>
      <Fields>
        <Field Name="ServerName">
          <DataField>ServerName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="Version">
      <Query>
        <DataSourceName>DataSource1</DataSourceName>
        <CommandText>SELECT  SERVERPROPERTY('ProductMajorversion') AS 'ProductMajorVersion'</CommandText>
      </Query>
      <Fields>
        <Field Name="ProductMajorVersion">
          <DataField>ProductMajorVersion</DataField>
          <rd:TypeName>System.Object</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="ServerProperty">
      <Query>
        <DataSourceName>DataSource1</DataSourceName>
        <CommandText>SELECT ServerProperty('EngineEdition') AS 'EngineEdition'</CommandText>
      </Query>
      <Fields>
        <Field Name="EngineEdition">
          <DataField>EngineEdition</DataField>
          <rd:TypeName>System.Object</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
  </DataSets>
  <rd:ReportUnitType>Inch</rd:ReportUnitType>
  <rd:ReportID>651e4b6d-2b8d-44d5-bc60-5f84885b4c82</rd:ReportID>
</Report>