<?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>3.66667in</Width>
            </TablixColumn>
            <TablixColumn>
              <Width>8.8in</Width>
            </TablixColumn>
            <TablixColumn>
              <Width>4.36667in</Width>
            </TablixColumn>
            <TablixColumn>
              <Width>2.66667in</Width>
            </TablixColumn>
          </TablixColumns>
          <TablixRows>
            <TablixRow>
              <Height>0.4in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox7">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Description of Each Report</Value>
                              <Style>
                                <FontSize>18pt</FontSize>
                                <Color>White</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox7</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</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>4</ColSpan>
                  </CellContents>
                </TablixCell>
                <TablixCell />
                <TablixCell />
                <TablixCell />
              </TablixCells>
            </TablixRow>
            <TablixRow>
              <Height>0.28333in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox11">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <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 />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox11</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</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>4</ColSpan>
                  </CellContents>
                </TablixCell>
                <TablixCell />
                <TablixCell />
                <TablixCell />
              </TablixCells>
            </TablixRow>
            <TablixRow>
              <Height>0.28333in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox1">
                      <CanGrow>true</CanGrow>
                      <UserSort>
                        <SortExpression>=Fields!MenuItem.Value</SortExpression>
                      </UserSort>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Report Name</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>White</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox1</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</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>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Purpose Of The Report</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>White</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox3</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</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="Textbox17">
                      <CanGrow>true</CanGrow>
                      <UserSort>
                        <SortExpression>=Fields!FileName.Value</SortExpression>
                      </UserSort>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>RDL File Name</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>White</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox17</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</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="Textbox8">
                      <CanGrow>true</CanGrow>
                      <UserSort>
                        <SortExpression>=Fields!ReportLibraryGroup.Value</SortExpression>
                      </UserSort>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Report Library Group</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                                <Color>White</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox8</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</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.37833in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="MenuItem">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Fields!MenuItem.Value</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>MenuItem</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <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="PurposeOfTheReport">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Fields!PurposeOfTheReport.Value</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>PurposeOfTheReport</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <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="FileName">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Fields!FileName.Value</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>FileName</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <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="ReportLibraryGroup">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Fields!ReportLibraryGroup.Value</Value>
                              <Style>
                                <FontSize>14pt</FontSize>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>ReportLibraryGroup</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <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>
              </TablixCells>
            </TablixRow>
            <TablixRow>
              <Height>0.37168in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox9">
                      <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 />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox9</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</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>4</ColSpan>
                  </CellContents>
                </TablixCell>
                <TablixCell />
                <TablixCell />
                <TablixCell />
              </TablixCells>
            </TablixRow>
          </TablixRows>
        </TablixBody>
        <TablixColumnHierarchy>
          <TablixMembers>
            <TablixMember />
            <TablixMember />
            <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>
          </TablixMembers>
        </TablixRowHierarchy>
        <DataSetName>ReportDef</DataSetName>
        <SortExpressions>
          <SortExpression>
            <Value>=Fields!MenuItem.Value</Value>
          </SortExpression>
        </SortExpressions>
        <Height>1.71667in</Height>
        <Width>19.50001in</Width>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
        </Style>
      </Tablix>
    </ReportItems>
    <Height>1.71667in</Height>
    <Style />
  </Body>
  <Width>19.50001in</Width>
  <Page>
    <PageHeight>300in</PageHeight>
    <LeftMargin>1in</LeftMargin>
    <RightMargin>1in</RightMargin>
    <TopMargin>1in</TopMargin>
    <BottomMargin>1in</BottomMargin>
    <Style />
  </Page>
  <AutoRefresh>0</AutoRefresh>
  <DataSources>
    <DataSource Name="Local">
      <ConnectionProperties>
        <DataProvider>SQL</DataProvider>
        <ConnectString>Data Source=LocalHost;Initial Catalog=master</ConnectString>
        <IntegratedSecurity>true</IntegratedSecurity>
      </ConnectionProperties>
      <rd:SecurityType>Integrated</rd:SecurityType>
      <rd:DataSourceID>b4e5e153-8181-428e-ae73-9cb3b8b2341f</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <DataSets>
    <DataSet Name="ReportDef">
      <Query>
        <DataSourceName>Local</DataSourceName>
        <CommandText>CREATE TABLE #ReportMenu
			(MenuItem VARCHAR(100)
			 , PurposeOfTheReport  VARCHAR(500)
			 , FileName VARCHAR(100)
			 , ReportLibraryGroup VARCHAR(100))

INSERT INTO #ReportMenu
SELECT 
'Processes' AS 'Topic'
, 'Lists all the user processes and identifies blocking information.'
, 'Processes'
, 'Current State'

INSERT INTO #ReportMenu
SELECT 
'CPU Utilization' AS 'Topic'
, 'CPU Utilization by minute for the last few days.  Returns CPU usage for both "SQL Server" and "Other Processes"'
, 'CPULast7Days'
, 'Current State'

INSERT INTO #ReportMenu
SELECT 
'Open Transactions' AS 'Topic'
, 'Information about open transactions on the server.'
, 'OpenTransactions'
, 'Current State'


INSERT INTO #ReportMenu
SELECT 
'What is Using the TempDB with Code' AS 'Topic'
, 'Returns what processes are currently using the TempDB.'
, 'TempDBQueries'
, 'Current State'




INSERT INTO #ReportMenu
SELECT 
'Read Write Latency' AS 'Topic'
, 'Returns Read\Write latency for each file for all databases.  This includes both data and log files.'
, 'ReadWriteLatency'
, 'Current State'

INSERT INTO #ReportMenu
SELECT 
'Wait Information' AS 'Topic'
, 'Information about some of the common important wait types.'
, 'WaitInformation'
, 'Current State'

INSERT INTO #ReportMenu
SELECT 
'Job Failures Last 30 Days' AS 'Topic'
, 'Returns information about job failures for the past 30 days.'
, 'JobFailures'
, 'Jobs, Alerts and Operators'

INSERT INTO #ReportMenu
SELECT 
'Currently Running Jobs' AS 'Topic'
, 'What jobs are currently running.'
, 'CurrentlyExecutingJobs'
, 'Jobs, Alerts and Operators'



INSERT INTO #ReportMenu
SELECT 
'Job Failure Rate Past 90 Days' AS 'Topic'
, 'This returns the percentage of failures for each job for the past 90 days.'
, 'JobFailureRate'
, 'Jobs, Alerts and Operators'

INSERT INTO #ReportMenu
SELECT 
'Jobs Using Schedules' AS 'Topic'
, 'What schedules are being used and what jobs are using them'
, 'JobsUsingSchedules'
, 'Jobs, Alerts and Operators'


INSERT INTO #ReportMenu
SELECT 
'Operator Information' AS 'Topic'
, 'Information about each operators, including email address'
, 'OperatorInformation'
, 'Jobs, Alerts and Operators'

INSERT INTO #ReportMenu
SELECT 
'Job Information' AS 'Topic'
, 'General information about each job, including schedules and notifications.'
, 'JobInformation'
, 'Jobs, Alerts and Operators'

INSERT INTO #ReportMenu
SELECT 
'Job Step Information' AS 'Topic'
, 'Provides some detail about each jobs step, including what type of step'
, 'JobStepInformation'
, 'Jobs, Alerts and Operators'

INSERT INTO #ReportMenu
SELECT 
'Auto Delete Jobs' AS 'Topic'
, 'Are there any jobs configured to delete automatically? This report will tell you.'
, 'AutoDeleteJobs'
, 'Jobs, Alerts and Operators'

INSERT INTO #ReportMenu
SELECT 
'Alert Information' AS 'Topic'
, 'General information about the Alerts, including the last occurence.'
, 'AlertInformation'
, 'Jobs, Alerts and Operators'

INSERT INTO #ReportMenu
SELECT 
'Jobs with No Configured Notification' AS 'Topic'
, 'If there are jobs that do not have any notifications configured, this report will help you find them.'
, 'Jobs with No Configured Notification'
, 'Jobs, Alerts and Operators'

INSERT INTO #ReportMenu
SELECT 
'Memory Settings and Counters' AS 'Topic'
, 'Configuration of important memory settings'
, 'MemorySettingsAndCounters'
, 'Memory Information'

INSERT INTO #ReportMenu
SELECT 
'Additional Memory Counters' AS 'Topic'
, 'More memory related counters such as Free List Stalls and Lazy Writes'
, 'MoreMemoryCounters'
, 'Memory Information'

INSERT INTO #ReportMenu
SELECT 
'Connection Count and Memory Used' AS 'Topic'
, 'Many connections to the server and how much memory is being consumed'
, 'UserConnections'
, 'Memory Information'

INSERT INTO #ReportMenu
SELECT 
'Memory Dump File Information' AS 'Topic'
, 'Location, when created and size of each memory dump file.'
, 'MemoryDumpFileInformation'
, 'Memory Information'

INSERT INTO #ReportMenu
SELECT 
'Database Virtual Log Files' AS 'Topic'
, 'Virtual Log File count for each database.  Will provide a warn if the count is too high'
, 'DatabaseVirtualLogFile'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'TempDB  Information' AS 'Topic'
, 'How many files in the TempDB including file size'
, 'TempDBInformation'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Synonym Information  (D)' AS 'Topic'
, 'Checks for the presence of Synonyms and the definition of each'
, 'DatabaseSynonyms'
, 'Database Information'


INSERT INTO #ReportMenu
SELECT 
'CDC Tables' AS 'Topic'
, 'What tables are using Change Data Capture'
, 'CDCEnabledTables'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Change Tracking Tables (D)' AS 'Topic'
, 'What tables are configured for Change Tracking'
, 'ChangeTrackingTables'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'CheckDB Status' AS 'Topic'
, 'Returns the date of the last successful CheckDB'
, 'CheckDBStatus'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Table Row Counts and Size  (D)' AS 'Topic'
, 'Returns row counts for all tables in the database as well as the size'
, 'TableRowCountsAndSize'
, 'Database Information'


INSERT INTO #ReportMenu
SELECT 
'Statistics Information  (D)' AS 'Topic'
, 'Information about statistics, including last updated date, sample rate and modification counts'
, 'StatsModificationCounts'
, 'Database Information'


INSERT INTO #ReportMenu
SELECT 
'Forwarded Records   (D)' AS 'Topic'
, 'The number of forwarded records since the service was last started and the number of forwarded records in tables'
, 'ForwardedRecords'
, 'Database Information'



INSERT INTO #ReportMenu
SELECT 
'Index Fragmentation   (D)' AS 'Topic'
, 'Index fragmentation percentage'
, 'IndexFragmentation'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Database Auto Settings' AS 'Topic'
, 'Returns setting status for "Auto Update Stats", "Auto Create Stats" and a few others'
, 'DatabaseAutoSettings'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Database Snapshot Information' AS 'Topic'
, 'Are there any snapshots?'
, 'DatabaseSnapshotInformation'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Database Auto Tune Settings' AS 'Topic'
, 'Returns current status of the Auto Tune settings'
, 'AutoTuningOptions'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Tables Created or Modified Last 90 Days  (D)' AS 'Topic'
, 'List of tables that were created or modified in the past 90 days'
, 'TablesCreatedModifiedInPast7Days'
, 'Database Information'


INSERT INTO #ReportMenu
SELECT 
'Database Filegroup Information' AS 'Topic'
, 'Filegroup information for each database'
, 'FilegroupInformation'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Index To Column Ratio by Table  (D)' AS 'Topic'
, 'The ratio of Indexes to Columns.  Could help us identify if there are too many indexes'
, 'IndexToColumnRatio'
, 'Database Information'


INSERT INTO #ReportMenu
SELECT 
'File Size\Space Used' AS 'Topic'
, 'The name, size and free space of each file for all the databases.'
, 'DatabaseSizeInfo'
, 'Database Information'


INSERT INTO #ReportMenu
SELECT 
'Plan Guides' AS 'Topic'
, 'Returns the query defined in the plan guide, if any exist'
, 'PlanGuide'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Stored Procs Created or Modified Last 90 Days  (D)' AS 'Topic'
, 'Stored procs created or modified in past 90 days'
, 'StoredProcsCreatedModifiedPast7Days'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Index Information  (D)' AS 'Topic'
, 'Name, type and location of each index in the database'
, 'IndexInformation'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Index Fragmentation for an Object   (D)' AS 'Topic'
, 'This is the code if you want to check the fragmentation of indexes on a specific object'
, 'IndexFragmentationForAnObject'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'CDC and Change Tracking Status' AS 'Topic'
, 'Returns the status of CDC and Change Tracking'
, 'DatabaseCDCChangeTracking'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Databases Not in Offline\Online State' AS 'Topic'
, 'State of each database is on Offline or Online'
, 'ProblemDatabases'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Tables That are Heaps   (D)' AS 'Topic'
, 'Where are those heaps....use this report to find them'
, 'TablesThatAreHeaps'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Queries with High Logical Reads  (D)' AS 'Topic'
, 'Returns the top 10 queries based on the number of logical reads'
, 'QueriesWithHighReads'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Database Information(Stats Settings\Compat Level)' AS 'Topic'
, 'Compatibility level and addition settings for each database'
, 'DatabaseInformation'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Database Settings' AS 'Topic'
, 'Settings on the databases that might be useful to know'
, 'DatabaseSettings'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Computed Columns in Database (D)' AS 'Topic'
, 'Location and definition of each computed column in the current database'
, 'ComputedColumnsInDB'
, 'Database Information'


INSERT INTO #ReportMenu
SELECT 
'Views Created or Modified Last 90 Days   (D)' AS 'Topic'
, 'Views created or modified in the past 90 days'
, 'ViewsCreatedOrModifiedPast7Days'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Compressed Objects   (D)' AS 'Topic'
, 'Compression status of each object'
, 'CompressedObjects'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Column List for Current Databases  (D)' AS 'Topic'
, 'Simple list of all the columns in each table'
, 'ColumnList'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Database File Information' AS 'Topic'
, 'Location of each database related file'
, 'DatabaseFileInfo'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Query Store Status and Settings' AS 'Topic'
, 'Query store status'
, 'QueryStoreStatus'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Database Triggers   (D)' AS 'Topic'
, 'Find those hidden triggers with this report'
, 'DatabaseTriggers'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Database Functions   (D)' AS 'Topic'
, 'Any user defined functions?'
, 'DatabaseFunctions'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'User Defined Data Types   (D)' AS 'Topic'
, 'What user defined database exist in the database and where are they used'
, 'DatabaseUserDefinedDataTypes'
, 'Database Information'


INSERT INTO #ReportMenu
SELECT 
'Full Text Index Info.  (D)' AS 'Topic'
, 'Full text indexes....are there any?'
, 'FullTextIndexInformation'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Default Constraint Info.  (D)' AS 'Topic'
, 'Default constraints and where they are being used'
, 'DatabaseDefaultInformation'
, 'Database Information'


INSERT INTO #ReportMenu
SELECT 
'Server Triggers' AS 'Topic'
, 'Returns information about server triggers if any exist'
, 'ServerTriggers'
, 'Server Information'

INSERT INTO #ReportMenu
SELECT 
'Extended Events Information' AS 'Topic'
, 'What Extended Event Sessions exist'
, 'ExtendedEventInformation'
, 'Server Information'

INSERT INTO #ReportMenu
SELECT 
'Enabled Trace Flags' AS 'Topic'
, 'Currently enabled trace flags'
, 'EnabledTraceFlags'
, 'Server Information'

INSERT INTO #ReportMenu
SELECT 
'Trace Information' AS 'Topic'
, 'Any traces running?'
, 'Traces'
, 'Server Information'

INSERT INTO #ReportMenu
SELECT 
'Sys.Configurations' AS 'Topic'
, 'Returns the contents of the Configurations table.  Will identify which settings are causing a pending reboot'
, 'SysConfiguration'
, 'Server Information'


INSERT INTO #ReportMenu
SELECT 
'Cluster Node Information' AS 'Topic'
, 'Is the server in a cluster?'
, 'WindowsClusterInformation'
, 'Backups\Restores\HA\DR'

INSERT INTO #ReportMenu
SELECT 
'Custom Error Messages' AS 'Topic'
, 'Looks for custom error messages, anything with a number above 50,000'
, 'CustomMessages'
, 'Server Information'


INSERT INTO #ReportMenu
SELECT 
'Processor Information' AS 'Topic'
, 'How many processors on the server?'
, 'ProcessorInformation'
, 'Server Information'


INSERT INTO #ReportMenu
SELECT 
'Service Account Information' AS 'Topic'
, 'What account is being used to run the services.  Also will return the status of the service'
, 'ServiceAccountInformation'
, 'Server Information'

INSERT INTO #ReportMenu
SELECT 
'Connection IP Addresses' AS 'Topic'
, 'IP addresses of existing connections'
, 'IPAddressesConnected'
, 'Server Information'

INSERT INTO #ReportMenu
SELECT 
'Start up Parameters' AS 'Topic'
, 'Definition of each of the start up parameters'
, 'StartupParameters'
, 'Server Information'


INSERT INTO #ReportMenu
SELECT 
'SA Audit and Password Review' AS 'Topic'
, 'Will tell you if any accounts have security issues, passwords same as account name or no password.  Will also return settings of the SA account'
, 'SAAuditPasswordReview'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'Failed Logins' AS 'Topic'
, 'What failed logins are happening.  Only looks at the current log'
, 'FailedLogins'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'Login Information' AS 'Topic'
, 'Information about each login on the server'
, 'LoginInformation'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'Server Role Information and Membership' AS 'Topic'
, 'Who is in each server role'
, 'ServerRoleMembers'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'Authentication Information' AS 'Topic'
, 'Windows or Mixed authentication.  How is the server configured?'
, 'AuthenticationInfo'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'Email In Job Steps' AS 'Topic'
, 'Email addresses found in job steps.'
, 'EmbeddedEmailInJobSteps'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'Server Permissions other than Connect' AS 'Topic'
, 'Logins that have permissions at the server level other than connect'
, 'ServerPermissionsOtherThanConnect'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'Database Role Members' AS 'Topic'
, 'Returns the members of each database role for all the databases'
, 'DatabaseRoleMembers'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'Database Users' AS 'Topic'
, 'Who is in what databases'
, 'DatabaseUsers'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'Linked Server Information' AS 'Topic'
, 'Information about all the linked servers, most importantly is it configured to use Self credentials'
, 'LinkedServerInformation'
, 'Security Information'


INSERT INTO #ReportMenu
SELECT 
'Credential Information' AS 'Topic'
, 'Are there any credentials on the server?'
, 'CredentialInformation'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'Database Audit Specification Information' AS 'Topic'
, 'Database Audit information, including what Server Audit each is using'
, 'DatabaseAuditInformation'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'Server Audit Specification Information' AS 'Topic'
, 'Server Audit information'
, 'ServerAuditInformation'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'Proxy Information' AS 'Topic'
, 'General information about each proxy'
, 'ProxyInformation'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'General Information' AS 'Topic'
, 'General information about the SQL Server and Windows Server'
, 'GeneralInformation'
, 'Server Information'

INSERT INTO #ReportMenu
SELECT 
'Users DMLRights other than SELECT (D)' AS 'Topic'
, 'Who can change data or object definition'
, 'UsersWithDMLRightsOtherThanSELECT'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'Public Role Permissions  (D)' AS 'Topic'
, 'Permissions for the public role'
, 'PublicRolePermissions'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'Guest Account Permissions and Status (D)' AS 'Topic'
, 'Status of the Guest account for the current database'
, 'GuessAccountPermissions'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'Encrypted Database Information' AS 'Topic'
, 'Any encrypted databases?'
, 'EncryptedDatabaseInfo'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'Guest Account Status All Databases' AS 'Topic'
, 'Status of the Guest account for each database'
, 'GuestAccountStatusAllDatabases'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'Procedures With Execute As   (D)' AS 'Topic'
, 'Returns any procedure that has the keywords "Execute As" in the definition'
, 'StoredProcsWithExecuteAs'
, 'Security Information'


INSERT INTO #ReportMenu
SELECT 
'Backup(Full and Differential) Information' AS 'Topic'
, 'History of Full and Differential backups, including the device backed up to'
, 'BackupInformation'
, 'Backups\Restores\HA\DR'

INSERT INTO #ReportMenu
SELECT 
'Replication Information' AS 'Topic'
, 'Any replication?'
, 'ReplicationInfo'
, 'Backups\Restores\HA\DR'

INSERT INTO #ReportMenu
SELECT 
'Availability Group Information' AS 'Topic'
, 'What Availability Groups exist and what databases are involved'
, 'AvailablityGroupInformation'
, 'Backups\Restores\HA\DR'

INSERT INTO #ReportMenu
SELECT 
'Restore Information' AS 'Topic'
, 'Any restores of databases?'
, 'RestoreInformation'
, 'Backups\Restores\HA\DR'


INSERT INTO #ReportMenu
SELECT 
'Missing Backups' AS 'Topic'
, 'Any database without a full backup in past few days or no log backup as well'
, 'MissingBackups'
, 'Backups\Restores\HA\DR'

INSERT INTO #ReportMenu
SELECT 
'Backup Speed Rate' AS 'Topic'
, 'The MB\Sec for each backup'
, 'BackupSpeed'
, 'Backups\Restores\HA\DR'

INSERT INTO #ReportMenu
SELECT 
'Backup (TLog Only) Information' AS 'Topic'
, 'History of transaction log backups'
, 'BackupInformationTLog'
, 'Backups\Restores\HA\DR'

INSERT INTO #ReportMenu
SELECT 
'Backup (All Other Types) Information' AS 'Topic'
, 'History of all other types of backups'
, 'BackupInformationOtherBkupType'
, 'Backups\Restores\HA\DR'

INSERT INTO #ReportMenu
SELECT 
'Mirrored Database Information' AS 'Topic'
, 'Mirrored Databases, do they exist?'
, 'MirroredDatabases'
, 'Backups\Restores\HA\DR'

INSERT INTO #ReportMenu
SELECT 
'Log Shipping Databases' AS 'Topic'
, 'Databases with log shipping configured'
, 'LogShippingInformation'
, 'Backups\Restores\HA\DR'

INSERT INTO #ReportMenu
SELECT 
'User Defined Data Type Usage' AS 'Topic'
, 'Returns the columns the are using User Defined Datatypes'
, 'DatabaseUserDefDataTypeUsage'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Azure Database Resource Stats' AS 'Topic'
, 'Returns Performance related information on an Azure SQL DB'
, 'AzureDBResourceStats'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Memory Optimized Tables' AS 'Topic'
, 'Returns information about all the memory optimized tables in all the databases.  This also includes the allocated and used sizes'
, 'MemoryOptimizedTables'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Azure SQL DB Service Tiers' AS 'Topic'
, 'You can use this report to find the service level for each Azure SQL DB on your instance.'
, 'AzureServiceTier'
, 'Server Information'
INSERT INTO #ReportMenu
SELECT 
'Stored Procedures that start with SP_' AS 'Topic'
, 'Returns any stored procedure that starts with SP_.  Proces with this naming convention can present issues if MS comes out with a proc of the same name.'
, 'ProceduresThatStartWithSP_'
, 'Database Information'


INSERT INTO #ReportMenu
SELECT 
'Dynamic Masked Columns' AS 'Topic'
, 'Lists the columns that are masked'
, 'DynamicMaskedColumns'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Extended Events Session Status' AS 'Topic'
, 'Returns the running status for each of the Exended Event sessions'
, 'ExtendedEventSessionStatus'
, 'Server Information'

INSERT INTO #ReportMenu
SELECT 
'Mail Configuration' AS 'Topic'
, 'Information about the mail confiuration including profiles and mail servers'
, 'MailConfiguration'
, 'Server Information'

INSERT INTO #ReportMenu
SELECT 
'Memory Grants Pending' AS 'Topic'
, 'Returns the SPIDs with pending memory grants with the query'
, 'MemoryGrantsPending'
, 'Memory Information'

INSERT INTO #ReportMenu
SELECT 
'Mail Configuration Parameters' AS 'Topic'
, 'Returns the parameter configuration for database mail'
, 'MailConfigParameters'
, 'Server Information'

INSERT INTO #ReportMenu
SELECT 
'Database Mail Status and History' AS 'Topic'
, 'Returns information about the history of database mail, including who it was sent to'
, 'DatabaseMailEmailSentStatus'
, 'Server Information'
INSERT INTO #ReportMenu
SELECT 
'Partitioned Tables' AS 'Topic'
, 'Report on what tables are partitioned'
, 'PartitionedTables'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Spills To TempDB' AS 'Topic'
, 'Executes sys.dm_exec_query_stats to get the number of spills to TempDB for completed queries that still have a plan in the cache'
, 'SpillsToTempDB'
, 'Memory Information'

INSERT INTO #ReportMenu
SELECT 
'Stored Procs with Recompile' AS 'Topic'
, 'Returns all the stored procedures that have the keyword recompile in the definition'
, 'StoredProcsWithRecompile'
, 'Database Information'


INSERT INTO #ReportMenu
SELECT 
'Column Store Index Information' AS 'Topic'
, 'Returns information about the Column Store indexes includes type, size and row count'
, 'ColumnStoreIndexes'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Plans In Cache with Implicit Convert' AS 'Topic'
, 'Returns the TOP 100 query plans based on execution count that have an Implicit Convert'
, 'QueryPlansWIthImplicitConvert'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Duplicate Indexes' AS 'Topic'
, 'Returns all indexes that have a duplicate on the same table'
, 'DuplicateIndexes'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Orphan Database Users' AS 'Topic'
, 'Returns database user accounts that do not have a matching login, either by SID or by name'
, 'OrphanedDBUsrs'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Trace Flags Being Used' AS 'Topic'
, 'This report reviews the past three logs looking for any trace flag that was turned on.  This does not return current status of enabled trace flags.'
, 'Traceflagsbeingused'
, 'Server Information'

INSERT INTO #ReportMenu
SELECT 
'Error Log File Size' AS 'Topic'
, 'Returns the size of each of the archived error log files, as well as the current error log'
, 'ErrorLogFileSize'
, 'Server Information'

INSERT INTO #ReportMenu
SELECT 
'Columns with BLOB data types'
, 'Lists all columns in the current database that use XML, VARCHAR(MAX), NVARCHAR(MAX), VARBINARY(MAX), IMAGE and TEXT data types'
, 'ColumnsWithBLOBDataType'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Stored Procedures that have a "Select *"'
, 'Returns all stored procedures that have a "Select *" in the code somewhere'
, 'StoredProcsWithSelectAst'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Stored Procedures that have CURSOR"'
, 'Returns all stored procedures that have a CURSOR in the code somewhere'
, 'StoredProcsWithCursor'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Buffer Pool Extension Information'
, 'Returns the file path, size and number of pages in the bufferpool extension'
, 'BufferPoolExtensionInformation'
, 'Server Information'

INSERT INTO #ReportMenu
SELECT 
'Spinlock Information'
, 'Returns information about spinlocks including backoffs'
, 'BufferPoolExtensionInformation'
, 'Server Information'

INSERT INTO #ReportMenu
SELECT 
'All Permissions On The Database'
, 'Returns the permissions on the database.  This excludes the system database roles, the Public role and the Guest account'
, 'AllPermissionsOntheDatabase'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'Index Usage'
, 'Returns user seeks, scans, lookups and updates for all indexes in the database'
, 'IndexUsage'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Indexes That are unused'
, 'Returns indexes where there are not any user seeks, scans and lookups in the database'
, 'IndexThatAreUnused'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Nonsargable Searches in Stored Procedures'
, 'Returns the list of stored procedures that have Nonsargable searches.  This include functions in the WHERE clause and leading wildcard searches'
, 'NonSargAbleStoredProcs'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Stored Procs with Deadlock Priority Set'
, 'Returns the list of stord procedures that have the DEADLOCK_PRIORITY set'
, 'StoredProceduresWithDeadlockPriority'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Stored Procs with NOCOUNT Set to OFF'
, 'Returns the list of stord procedures that have NOCOUNT set to OFF or not set at all'
, 'StoredProceduresWithoutNOCOUNT'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Temporal Table Information'
, 'Returns all temporal tables as well as the create date and retention period'
, 'TemporalTableInformation'
, 'Database Information'

INSERT INTO #ReportMenu
SELECT 
'Objects with Schemabinding'
, 'Returns a list of all the objects, with code, that have schemabinding'
, 'ObjectsWithSchemabinding'
, 'Database Information' 

INSERT INTO #ReportMenu
SELECT 
'Stretch Database Information'
, 'Returns information about the stretch tables in the database'
, 'StretchTableInformation'
, 'Database Information' 


INSERT INTO #ReportMenu
SELECT 
'Contained Database Information'
, 'Returns information about contained database'
, 'ContainedDatabases'
, 'Database Information' 

INSERT INTO #ReportMenu
SELECT 
'Contained Database Users'
, 'Returns information about contained database users'
, 'ContainedDatabaseUsers'
, 'Database Information' 

INSERT INTO #ReportMenu
SELECT 
'Security Policy Information'
, 'Returns information about the security policies in the database'
, 'SecurityPolicyInformation'
, 'Security Information' 


INSERT INTO #ReportMenu
SELECT 
'Why is the Log Not Clearing'
, 'Uses Sysdatabases to return the reason the transaction log is not clearing'
, 'WhyIsTLogNotClearing'
, 'Current State' 

INSERT INTO #ReportMenu
SELECT 
'OS Power Plan Setting'
, 'Gets the current Power Settings for the OS'
, 'OSPowerPlanSetting'
, 'Server Information'


INSERT INTO #ReportMenu
SELECT 
'Deploy Admin Monitor'
, 'Main Page for Deploying the monitor solution'
, 'DeployAdminMonitor'
, 'Monitor Reports'

INSERT INTO #ReportMenu
SELECT 
'Create AdminMonitor database'
, 'Creates the AdminMonitor database'
, 'CreateAdminMonitorDB'
, 'Monitor Reports'


INSERT INTO #ReportMenu
SELECT 
'Create Monitor Tables'
, 'Creates the Required tables for the monitor solution'
, 'CreateMonitorTables'
, 'Monitor Reports'


INSERT INTO #ReportMenu
SELECT 
'Create Monitor Procedures'
, 'Creates the Required stored procs for the monitor solution'
, 'CreateStoredProcs'
, 'Monitor Reports'



INSERT INTO #ReportMenu
SELECT 
'Create Monitor Jobs'
, 'Creates the Required jobs for the monitor solution'
, 'Createjobs'
, 'Monitor Reports'

INSERT INTO #ReportMenu
SELECT 
'Insert Counters and Wait Types'
, 'Used to enter the data for counters and wait types'
, 'InsertMonitorData'
, 'Monitor Reports'

INSERT INTO #ReportMenu
SELECT 
'Confirmation Page to Create the Monitor Solution'
, 'Provides a last check to determine the user really wants to create the monitor solution'
, 'MonitorAreYouSure'
, 'Monitor Reports'

INSERT INTO #ReportMenu
SELECT 
'View Code for the Monitor Solution'
, 'Used as a starting point for viewing the code'
, 'ViewMonitorCode'
, 'Monitor Reports'

INSERT INTO #ReportMenu
SELECT 
'Create AdminMonitor Database Code'
, 'View the code to create the AdminMonitor DB'
, 'MonitorCreateDatabase'
, 'Monitor Reports'

INSERT INTO #ReportMenu
SELECT 
'Create AdminMonitor Procs Code'
, 'View the code to create the AdminMonitor Procs'
, 'MonitorCreateProcedures'
, 'Monitor Reports'

INSERT INTO #ReportMenu
SELECT 
'Create AdminMonitor Tables Code'
, 'View the code to create the AdminMonitor Tables'
, 'MonitorCreateTablesCode'
, 'Monitor Reports'

INSERT INTO #ReportMenu
SELECT 
'Create AdminMonitor Jobs Code'
, 'View the code to create the AdminMonitor Jobs'
, 'MonitorCreateJobsCode'
, 'Monitor Reports'

INSERT INTO #ReportMenu
SELECT 
'Create AdminMonitor Perf Job Code'
, 'View the code to create the job to collect Performance Counters'
, 'CreatePerfMonitorJob'
, 'Monitor Reports'

INSERT INTO #ReportMenu
SELECT 
'Create AdminMonitor Wait Job Code'
, 'View the code to create the job to collect Wait Information'
, 'CreateWaitMonitorJob'
, 'Monitor Reports'


INSERT INTO #ReportMenu
SELECT 
'Create AdminMonitor Purge Job Code'
, 'View the code to create the job to purge monitor data'
, 'CreatePurgeJob'
, 'Monitor Reports'

INSERT INTO #ReportMenu
SELECT 
'Directions for the Monitor Solution'
, 'View the directions for the Monitor Solution'
, 'MonitorDirections'
, 'Monitor Reports'

INSERT INTO #ReportMenu
SELECT 
'Login Password Last Changed'
, 'View the last password change for SQL logins'
, 'LoginLastChangePassword'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'Schema Owners'
, 'Lists the Schema owners and the number of objects in each'
, 'SchemaOwners'
, 'Security Information'

INSERT INTO #ReportMenu
SELECT 
'Job Step Reties Past 24 Hours'
, 'Lists each Job step that has had a retry in the past 24 hours'
, 'JobStepsRetryPast24Hours'
, 'Jobs, Alerts and Operators'


SELECT * FROM #ReportMenu
ORDER BY MenuItem

DROP TABLE #ReportMenu</CommandText>
      </Query>
      <Fields>
        <Field Name="MenuItem">
          <DataField>MenuItem</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="PurposeOfTheReport">
          <DataField>PurposeOfTheReport</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="FileName">
          <DataField>FileName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ReportLibraryGroup">
          <DataField>ReportLibraryGroup</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
    </DataSet>
    <DataSet Name="Version">
      <Query>
        <DataSourceName>Local</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>Local</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>e79cd308-5cab-4cb6-960f-caed3908e54e</rd:ReportID>
</Report>