Reporting: Report for Scheduled reports
From DocWiki
(Created page with "== Reporting: Report for Scheduled reports == {| border="1" |- ! '''Problem Summary''' | Check the status of reports that are scheduled |- ! '''Error Message''' | Not relevant |...") |
m (→Reporting: Report for Scheduled reports) |
||
| (One intermediate revision not shown) | |||
| Line 1: | Line 1: | ||
| - | == Reporting: Report for Scheduled reports == | + | == Reporting: Report for Scheduled reports == |
{| border="1" | {| border="1" | ||
|- | |- | ||
| - | ! '''Problem Summary''' | + | ! '''Problem Summary''' |
| Check the status of reports that are scheduled | | Check the status of reports that are scheduled | ||
|- | |- | ||
| - | ! '''Error Message''' | + | ! '''Error Message''' |
| Not relevant | | Not relevant | ||
|- | |- | ||
| - | ! '''Possible Cause''' | + | ! '''Possible Cause''' |
| Not relevant | | Not relevant | ||
|- | |- | ||
| - | ! '''Recommended Action''' | + | ! '''Recommended Action''' |
| - | | | + | | |
| + | Save the XML below to a file and import as report. | ||
| + | |||
| + | <?xml version="1.0" encoding="utf-8"?><br><SerializedReport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><br> <ReportName>SchedulerStatus</ReportName><br> <ReportDescription /><br> <ModifiedBy>2K3SERVER-1\administrator</ModifiedBy><br> <FilePath>c:\temp\055f1237-e4b5-4c0c-9e0e-46ad36bbb290.xml</FilePath><br> <Category>00000000-0000-0000-0000-000000000000</Category><br> <AllowsTodayRange>true</AllowsTodayRange><br> <AllowsYesterdayRange>true</AllowsYesterdayRange><br> <AllowsThisWeekRange>false</AllowsThisWeekRange><br> <AllowsLastWeekRange>true</AllowsLastWeekRange><br> <AllowsThisMonthRange>true</AllowsThisMonthRange><br> <AllowsLastMonthRange>true</AllowsLastMonthRange><br> <AllowsQuarterToDateRange>true</AllowsQuarterToDateRange><br> <AllowsLastQuarterRange>true</AllowsLastQuarterRange><br> <AllowsYearToDateRange>true</AllowsYearToDateRange><br> <AllowsLastYearRange>true</AllowsLastYearRange><br> <AllowsTomorrowRange>false</AllowsTomorrowRange><br> <AllowsNextWeekRange>false</AllowsNextWeekRange><br> <AllowsNextMonthRange>false</AllowsNextMonthRange><br> <Type>Personal</Type><br> <Timeframe>Realtime</Timeframe><br> <bIsEditing>false</bIsEditing><br> <SortClause /><br> <RefreshRate>60</RefreshRate><br> <ReportID>86e60b92-49b6-4d2f-bcdf-20f8cbca2811</ReportID><br> <CustomSQL /><br> <AnonymousBlock>select B.SaveFileName, A.State, A.ProjectedRunDateTime, A.ActualRunDateTime from AA_RunSchedule A,AA_ScheduledReports B | ||
| + | |||
| + | where ProjectedRunDateTime&gt;:From and ProjectedRunDateTime&lt;:To and A.ScheduleID=B.ID | ||
| + | |||
| + | order by ProjectedRunDateTime</AnonymousBlock><br> <G1Summary>true</G1Summary><br> <G2Summary>true</G2Summary><br> <G3Summary>true</G3Summary><br> <DataSummary>true</DataSummary><br> <GridMode>realtime</GridMode><br> <VerticalAlign>top</VerticalAlign><br> <IncludeDateTime>true</IncludeDateTime><br> <IncludeFilterSummary>true</IncludeFilterSummary><br> <NumGroups>0</NumGroups><br> <GroupField1>00000000-0000-0000-0000-000000000000</GroupField1><br> <SortField1>00000000-0000-0000-0000-000000000000</SortField1><br> <GroupField2>00000000-0000-0000-0000-000000000000</GroupField2><br> <SortField2>00000000-0000-0000-0000-000000000000</SortField2><br> <GroupField3>00000000-0000-0000-0000-000000000000</GroupField3><br> <SortField3>00000000-0000-0000-0000-000000000000</SortField3><br> <SortFieldData>00000000-0000-0000-0000-000000000000</SortFieldData><br> <SortField1Direction>ASC</SortField1Direction><br> <SortField2Direction>ASC</SortField2Direction><br> <SortField3Direction>ASC</SortField3Direction><br> <SortFieldDataDirection>ASC</SortFieldDataDirection><br> <ChartSeriesList /><br> <x3DEnable>false</x3DEnable><br> <XAxisTitle /><br> <XAxisTickMarks>false</XAxisTickMarks><br> <XAxisGridLines>false</XAxisGridLines><br> <XAxisInterlacedStrips>false</XAxisInterlacedStrips><br> <XAxisReversed>false</XAxisReversed><br> <XAxisSideMargin>false</XAxisSideMargin><br> <XAxisLabelFormat /><br> <YAxisTitle /><br> <YAxisTickMarks>false</YAxisTickMarks><br> <YAxisGridLines>false</YAxisGridLines><br> <YAxisInterlacedStrips>false</YAxisInterlacedStrips><br> <YAxisReversed>false</YAxisReversed><br> <YAxisStartFromZero>false</YAxisStartFromZero><br> <YAxisLabelFormat /><br> <LegendVisible>false</LegendVisible><br> <LegendStyle>Column</LegendStyle><br> <LegendDocking>Right</LegendDocking><br> <LegendAlignment>Near</LegendAlignment><br> <LegendInsidePlotArea>false</LegendInsidePlotArea><br> <TitleText /><br> <TitleDocking>Top</TitleDocking><br> <TitleAlignment>TopCenter</TitleAlignment><br> <PointLabelsDisplay>false</PointLabelsDisplay><br> <PointLabelsSmartLabels>false</PointLabelsSmartLabels><br> <PointLabelAngle>0</PointLabelAngle><br> <XLabelAlign>center</XLabelAlign><br> <XAxisExtent>80</XAxisExtent><br> <YAxisExtent>80</YAxisExtent><br> <XAxisVisible>true</XAxisVisible><br> <YAxisVisible>true</YAxisVisible><br> <XGroupBySeries>false</XGroupBySeries><br> <YGroupBySeries>false</YGroupBySeries><br> <XAxisMin>0</XAxisMin><br> <YAxisMin>0</YAxisMin><br> <XAxisMax>100</XAxisMax><br> <YAxisMax>100</YAxisMax><br> <TitleFontSize>9</TitleFontSize><br> <XLabelFontSize>8</XLabelFontSize><br> <YLabelFontSize>8</YLabelFontSize><br> <XTitleFontSize>9</XTitleFontSize><br> <YTitleFontSize>9</YTitleFontSize><br> <TitleRotation>0</TitleRotation><br> <XRotation>0</XRotation><br> <YRotation>0</YRotation><br> <TitleLeft>50</TitleLeft><br> <TitleTop>5</TitleTop><br> <ChartAreaLeft>0</ChartAreaLeft><br> <ChartAreaTop>0</ChartAreaTop><br> <ChartAreaHeight>100</ChartAreaHeight><br> <ChartAreaWidth>100</ChartAreaWidth><br> <LegendLeft>80</LegendLeft><br> <LegendTop>10</LegendTop><br> <LegendHeight>80</LegendHeight><br> <LegendWidth>20</LegendWidth><br> <YAxisLabelLeft>5</YAxisLabelLeft><br> <YAxisLabelTop>40</YAxisLabelTop><br> <XAxisLabelLeft>50</XAxisLabelLeft><br> <XAxisLabelTop>95</XAxisLabelTop><br> <HasIntervalField>false</HasIntervalField><br> <CurrentInterval>30</CurrentInterval><br> <UsePageNumbers>true</UsePageNumbers><br> <TimeFrameType>D</TimeFrameType><br> <BackgroundImage /><br> <ShowGaugeLabels>true</ShowGaugeLabels><br> <ChartWidth>800</ChartWidth><br> <ChartHeight>600</ChartHeight><br> <ChartTheme /><br> <FontSize>8</FontSize><br> <XsltFileName /><br> <ShowFilterDialog>true</ShowFilterDialog><br> <DefaultDashboardDisplayMode>GRID</DefaultDashboardDisplayMode><br> <CategoryID>00000000-0000-0000-0000-000000000000</CategoryID><br> <DatasourceID>de2cd6f3-a603-49ca-99c4-4ffbc1362504</DatasourceID><br> <DataSourceType>AnonymousBlock</DataSourceType><br> <URL /><br> <XsltID>00000000-0000-0000-0000-000000000000</XsltID><br> <AnsiWarnings>false</AnsiWarnings><br> <AnsiNulls>true</AnsiNulls><br> <ArithAbort>false</ArithAbort><br> <ArithIgnore>true</ArithIgnore><br> <KeyCriteriaFieldID>00000000-0000-0000-0000-000000000000</KeyCriteriaFieldID><br> <RestrictTimeFrame>false</RestrictTimeFrame><br> <CommandTimeout>999</CommandTimeout><br> <RollingValue>0</RollingValue><br> <ParentReportID /><br> <DisplayFormat>Grid</DisplayFormat><br> <ChartType /><br> <YLabelFormat /><br> <HistoricalFilterType>NoFilter</HistoricalFilterType><br> <HistoricalStartDate>0001-01-01T00:00:00</HistoricalStartDate><br> <HistoricalEndDate>0001-01-01T00:00:00</HistoricalEndDate><br> <HistoricalStartTime>0001-01-01T00:00:00</HistoricalStartTime><br> <HistoricalEndTime>0001-01-01T00:00:00</HistoricalEndTime><br> <Parameters><br> <ReportParameter><br> <QuoteValues>None</QuoteValues><br> <ID>6c2c6a1f-135b-47a9-8d26-2d3412ca66e7</ID><br> <RestrictedValueList /><br> <FriendlyName>Scheduled From </FriendlyName><br> <NullForBlank>true</NullForBlank><br> <ValueSeparator>,</ValueSeparator><br> <PrefixValueWith /><br> <ParameterIndex>0</ParameterIndex><br> <ValueQuery /><br> <SelectedValueID>00000000-0000-0000-0000-000000000000</SelectedValueID><br> <SelectedCollectionID>00000000-0000-0000-0000-000000000000</SelectedCollectionID><br> <FreeformValue /><br> <AllowFreeformEntry>true</AllowFreeformEntry><br> <Bluevuename>New Parameter</Bluevuename><br> <TestValue>'2010-04-23 00:00:18.853'</TestValue><br> <HardCodedValue /><br> <FilteredFieldID>00000000-0000-0000-0000-000000000000</FilteredFieldID><br> <DataType>varchar</DataType><br> <ReportID>86e60b92-49b6-4d2f-bcdf-20f8cbca2811</ReportID><br> <Name>@From</Name><br> <Description>Reports Scheduled To Run From. Enter Date in format 2010-04-03</Description><br> <ParameterType>AnonymousBlock</ParameterType><br> <Required>true</Required><br> <ValueListID>00000000-0000-0000-0000-000000000000</ValueListID><br> </ReportParameter><br> <ReportParameter><br> <QuoteValues>None</QuoteValues><br> <ID>b34cec55-7c21-42fc-abbf-9305dd515a80</ID><br> <RestrictedValueList /><br> <FriendlyName>Scheduled Until </FriendlyName><br> <NullForBlank>true</NullForBlank><br> <ValueSeparator>,</ValueSeparator><br> <PrefixValueWith /><br> <ParameterIndex>0</ParameterIndex><br> <ValueQuery /><br> <SelectedValueID>00000000-0000-0000-0000-000000000000</SelectedValueID><br> <SelectedCollectionID>00000000-0000-0000-0000-000000000000</SelectedCollectionID><br> <FreeformValue /><br> <AllowFreeformEntry>true</AllowFreeformEntry><br> <Bluevuename>New Parameter</Bluevuename><br> <TestValue>'2010-04-23 00:00:18.853'</TestValue><br> <HardCodedValue /><br> <FilteredFieldID>00000000-0000-0000-0000-000000000000</FilteredFieldID><br> <DataType>varchar</DataType><br> <ReportID>86e60b92-49b6-4d2f-bcdf-20f8cbca2811</ReportID><br> <Name>@To</Name><br> <Description>Reports scheduled to run until. Enter Date in format 2010-04-03</Description><br> <ParameterType>AnonymousBlock</ParameterType><br> <Required>true</Required><br> <ValueListID>00000000-0000-0000-0000-000000000000</ValueListID><br> </ReportParameter><br> </Parameters><br> <Fields><br> <Field><br> <Group1FooterFormula /><br> <Group2FooterFormula /><br> <Group3FooterFormula /><br> <FilterChanged>false</FilterChanged><br> <FilterPreQuery>true</FilterPreQuery><br> <ExportAsHHMMSS>false</ExportAsHHMMSS><br> <ReportID>86e60b92-49b6-4d2f-bcdf-20f8cbca2811</ReportID><br> <AllowUsersToShow>true</AllowUsersToShow><br> <NormalizeTimeZone>false</NormalizeTimeZone><br> <TimeFrameType>Y</TimeFrameType><br> <ID>828c8a4e-cc91-414f-b606-4b38b1307593</ID><br> <DisplayWidth>125</DisplayWidth><br> <ValueCacheLifetimeInMinutes>3</ValueCacheLifetimeInMinutes><br> <ValueSQLQuery /><br> <IsFakeFilterField>false</IsFakeFilterField><br> <IsFormula>false</IsFormula><br> <FooterFormula /><br> <DisplayFormatStored>FormattedData</DisplayFormatStored><br> <XsltID>5db791d1-720d-4115-a9d9-2cad9d1b7721</XsltID><br> <FooterStyle>None</FooterStyle><br> <DrilldownOptions /><br> <Threshholds /><br> <Description /><br> <Key>SaveFileName</Key><br> <FormatString /><br> <TableID>00000000-0000-0000-0000-000000000000</TableID><br> <IsAggregate>false</IsAggregate><br> <ActiveFilterIndex>0</ActiveFilterIndex><br> <BluevueName>Report</BluevueName><br> <Formula /><br> <HighValue>0</HighValue><br> <LowValue>0</LowValue><br> <HighRangeValue>0</HighRangeValue><br> <LowRangeValue>0</LowRangeValue><br> <Randomize>false</Randomize><br> <Filters /><br> <FieldID>828c8a4e-cc91-414f-b606-4b38b1307593</FieldID><br> <FieldIndex>0</FieldIndex><br> <KeyCriteriaSearchable>false</KeyCriteriaSearchable><br> <ColumnName>SaveFileName</ColumnName><br> <DisplayName>Report</DisplayName><br> <KeyCriteria>true</KeyCriteria><br> <KeyCriteriaName>SaveFileName</KeyCriteriaName><br> <Displayed>true</Displayed><br> <DecimalPlaces>2</DecimalPlaces><br> <ShowAvg>false</ShowAvg><br> <ShowSum>false</ShowSum><br> <Filter><br> <DayFilter>ALL</DayFilter><br> <FromTime>2010-04-26T00:00:00</FromTime><br> <ToTime>2010-04-26T23:59:59</ToTime><br> <RestrictTime>false</RestrictTime><br> <DatabaseID>18c2086b-f149-4614-a725-362322f289e7</DatabaseID><br> <IsStockHistoricalFilter>false</IsStockHistoricalFilter><br> <IsCustomReportBuilderFilter>false</IsCustomReportBuilderFilter><br> <Caption>New Filter</Caption><br> <FilterField /><br> <FieldType>BigInt</FieldType><br> <FilterValues /><br> <FilterType1>NoFilter</FilterType1><br> <RollingValue>1</RollingValue><br> <IsHistoricalFilter>false</IsHistoricalFilter><br> <FieldID>828c8a4e-cc91-414f-b606-4b38b1307593</FieldID><br> <FilteringValues><br> <DataID>828c8a4e-cc91-414f-b606-4b38b1307593</DataID><br> <Updating>0</Updating><br> <RefreshRate>86400</RefreshRate><br> <LastRefreshed>1970-01-01T01:00:00</LastRefreshed><br> <ValueListQuery /><br> <CollectionQuery /><br> <IsDirty>true</IsDirty><br> <ID>828c8a4e-cc91-414f-b606-4b38b1307593</ID><br> <DatasourceID /><br> <ValueListDataType>Numeric</ValueListDataType><br> <Values><br> <Values><br> <IsDirty>true</IsDirty><br> <ValueListID>00000000-0000-0000-0000-000000000000</ValueListID><br> <Description /><br> <ValueListValueID>a1b194f0-79af-4055-bff8-4eff61828a37</ValueListValueID><br> <ValueListValue /><br> <DataType>String</DataType><br> <Ident>0</Ident><br> </Values><br> </Values><br> </FilteringValues><br> <ValueFieldID>00000000-0000-0000-0000-000000000000</ValueFieldID><br> <ValueCollectionID>00000000-0000-0000-0000-000000000000</ValueCollectionID><br> </Filter><br> <DataType>String</DataType><br> <SimpleDataType>String</SimpleDataType><br> <ColumnOrder>-1</ColumnOrder><br> <Alias /><br> <ValueListID>00000000-0000-0000-0000-000000000000</ValueListID><br> <ParentFieldID>00000000-0000-0000-0000-000000000000</ParentFieldID><br> <DescriptorFieldID>00000000-0000-0000-0000-000000000000</DescriptorFieldID><br> <ColumnSize>0</ColumnSize><br> <NumericPrecision>255</NumericPrecision><br> <NumericScale>255</NumericScale><br> <AllowDBNull>true</AllowDBNull><br> <IsUnique>false</IsUnique><br> <IsFakeHistoricalField>false</IsFakeHistoricalField><br> <IsKeyColumn>false</IsKeyColumn><br> <IsAutoIncrement>false</IsAutoIncrement><br> <IsReadOnly>false</IsReadOnly><br> <IsLong>false</IsLong><br> <BaseSchemaName /><br> <BaseCatalogName /><br> <BaseTableName /><br> <BaseColumnname>SaveFileName</BaseColumnname><br> <RequireAtLeastOneValueToBeSelected>false</RequireAtLeastOneValueToBeSelected><br> <ShowGauge>false</ShowGauge><br> <UseFooterForGauge>false</UseFooterForGauge><br> <DataID>828c8a4e-cc91-414f-b606-4b38b1307593</DataID><br> <ShelfLifeInSeconds>180</ShelfLifeInSeconds><br> <AutoMergeCells>false</AutoMergeCells><br> </Field><br> <Field><br> <Group1FooterFormula /><br> <Group2FooterFormula /><br> <Group3FooterFormula /><br> <FilterChanged>false</FilterChanged><br> <FilterPreQuery>true</FilterPreQuery><br> <ExportAsHHMMSS>false</ExportAsHHMMSS><br> <ReportID>86e60b92-49b6-4d2f-bcdf-20f8cbca2811</ReportID><br> <AllowUsersToShow>true</AllowUsersToShow><br> <NormalizeTimeZone>false</NormalizeTimeZone><br> <TimeFrameType>Y</TimeFrameType><br> <ID>419f5da5-28b7-43f6-b37a-b095d6a59fc0</ID><br> <DisplayWidth>125</DisplayWidth><br> <ValueCacheLifetimeInMinutes>3</ValueCacheLifetimeInMinutes><br> <ValueSQLQuery /><br> <IsFakeFilterField>false</IsFakeFilterField><br> <IsFormula>false</IsFormula><br> <DisplayFormatStored>FormattedData</DisplayFormatStored><br> <XsltID>00000000-0000-0000-0000-000000000000</XsltID><br> <FooterStyle>None</FooterStyle><br> <DrilldownOptions /><br> <Threshholds><br> <Threshhold><br> <ThreshholdValue xsi:type="xsd:string">0</ThreshholdValue><br> <ThreshholdValue2 xsi:type="xsd:string" /><br> <ThreshholdType>EqualTo</ThreshholdType><br> <FormattingType1>Font</FormattingType1><br> <GlobalVariableID /><br> <ID>585dad64-4fe6-4421-af5f-640afaea0eeb</ID><br> <Text>To Run Today</Text><br> <ImageURL /><br> <ForeColor>NamedColor:Black</ForeColor><br> <BackColor>ARGBColor:255:204:255:204</BackColor><br> <IsBold>true</IsBold><br> <IsBlinking>false</IsBlinking><br> </Threshhold><br> <Threshhold><br> <ThreshholdValue xsi:type="xsd:string">1</ThreshholdValue><br> <ThreshholdValue2 xsi:type="xsd:string" /><br> <ThreshholdType>EqualTo</ThreshholdType><br> <FormattingType1>Font</FormattingType1><br> <GlobalVariableID /><br> <ID>0906d83e-8aae-43a4-aca9-52fad78a7be5</ID><br> <Text>In Scheduler Queue </Text><br> <ImageURL /><br> <ForeColor>NamedColor:Black</ForeColor><br> <BackColor>ARGBColor:255:0:255:0</BackColor><br> <IsBold>false</IsBold><br> <IsBlinking>false</IsBlinking><br> </Threshhold><br> <Threshhold><br> <ThreshholdValue xsi:type="xsd:string">2</ThreshholdValue><br> <ThreshholdValue2 xsi:type="xsd:string" /><br> <ThreshholdType>EqualTo</ThreshholdType><br> <FormattingType1>Font</FormattingType1><br> <GlobalVariableID /><br> <ID>f935bf48-b2d3-4aaa-8eaa-8b7811cb61ec</ID><br> <Text>Running...</Text><br> <ImageURL /><br> <ForeColor>ARGBColor:255:0:0:0</ForeColor><br> <BackColor>ARGBColor:255:255:255:102</BackColor><br> <IsBold>false</IsBold><br> <IsBlinking>false</IsBlinking><br> </Threshhold><br> <Threshhold><br> <ThreshholdValue xsi:type="xsd:string">3</ThreshholdValue><br> <ThreshholdValue2 xsi:type="xsd:string" /><br> <ThreshholdType>EqualTo</ThreshholdType><br> <FormattingType1>Font</FormattingType1><br> <GlobalVariableID /><br> <ID>16f30f3f-dfd4-4992-8c9c-0cbfa64e6f58</ID><br> <Text>Run Succesfully</Text><br> <ImageURL /><br> <ForeColor>NamedColor:Black</ForeColor><br> <BackColor>ARGBColor:255:170:170:170</BackColor><br> <IsBold>true</IsBold><br> <IsBlinking>false</IsBlinking><br> </Threshhold><br> <Threshhold><br> <ThreshholdValue xsi:type="xsd:string">4</ThreshholdValue><br> <ThreshholdValue2 xsi:type="xsd:string" /><br> <ThreshholdType>EqualTo</ThreshholdType><br> <FormattingType1>Font</FormattingType1><br> <GlobalVariableID /><br> <ID>996ff789-bcde-442f-8499-8e5768b9df15</ID><br> <Text>Failed During Run</Text><br> <ImageURL /><br> <ForeColor>NamedColor:Black</ForeColor><br> <BackColor>ARGBColor:255:255:51:51</BackColor><br> <IsBold>true</IsBold><br> <IsBlinking>false</IsBlinking><br> </Threshhold><br> </Threshholds><br> <Key>State</Key><br> <FormatString /><br> <TableID>00000000-0000-0000-0000-000000000000</TableID><br> <IsAggregate>false</IsAggregate><br> <ActiveFilterIndex>0</ActiveFilterIndex><br> <BluevueName>State</BluevueName><br> <HighValue>0</HighValue><br> <LowValue>0</LowValue><br> <HighRangeValue>0</HighRangeValue><br> <LowRangeValue>0</LowRangeValue><br> <Randomize>false</Randomize><br> <Filters /><br> <FieldID>419f5da5-28b7-43f6-b37a-b095d6a59fc0</FieldID><br> <FieldIndex>1</FieldIndex><br> <KeyCriteriaSearchable>false</KeyCriteriaSearchable><br> <ColumnName>State</ColumnName><br> <DisplayName>State</DisplayName><br> <KeyCriteria>true</KeyCriteria><br> <KeyCriteriaName>State</KeyCriteriaName><br> <Displayed>true</Displayed><br> <DecimalPlaces>2</DecimalPlaces><br> <ShowAvg>false</ShowAvg><br> <ShowSum>false</ShowSum><br> <Filter><br> <DayFilter>ALL</DayFilter><br> <FromTime>2010-04-26T00:00:00</FromTime><br> <ToTime>2010-04-26T23:59:59</ToTime><br> <RestrictTime>false</RestrictTime><br> <DatabaseID>76c0b05c-d62d-4010-9b1a-4d9efc83aeeb</DatabaseID><br> <IsStockHistoricalFilter>false</IsStockHistoricalFilter><br> <IsCustomReportBuilderFilter>false</IsCustomReportBuilderFilter><br> <Caption>New Filter</Caption><br> <FilterField /><br> <FieldType>BigInt</FieldType><br> <FilterValues /><br> <FilterType1>NoFilter</FilterType1><br> <RollingValue>1</RollingValue><br> <IsHistoricalFilter>false</IsHistoricalFilter><br> <FieldID>419f5da5-28b7-43f6-b37a-b095d6a59fc0</FieldID><br> <FilteringValues><br> <DataID>419f5da5-28b7-43f6-b37a-b095d6a59fc0</DataID><br> <Updating>0</Updating><br> <RefreshRate>86400</RefreshRate><br> <LastRefreshed>1970-01-01T01:00:00</LastRefreshed><br> <ValueListQuery /><br> <CollectionQuery /><br> <IsDirty>true</IsDirty><br> <ID>419f5da5-28b7-43f6-b37a-b095d6a59fc0</ID><br> <DatasourceID /><br> <ValueListDataType>Numeric</ValueListDataType><br> <Values><br> <Values><br> <IsDirty>true</IsDirty><br> <ValueListID>00000000-0000-0000-0000-000000000000</ValueListID><br> <Description /><br> <ValueListValueID>85c04aec-c00d-4fdf-9a73-dcbe7968bd15</ValueListValueID><br> <ValueListValue /><br> <DataType>String</DataType><br> <Ident>0</Ident><br> </Values><br> </Values><br> </FilteringValues><br> <ValueFieldID>00000000-0000-0000-0000-000000000000</ValueFieldID><br> <ValueCollectionID>00000000-0000-0000-0000-000000000000</ValueCollectionID><br> </Filter><br> <DataType>Int32</DataType><br> <SimpleDataType>Numeric</SimpleDataType><br> <ColumnOrder>-1</ColumnOrder><br> <Alias /><br> <ValueListID>00000000-0000-0000-0000-000000000000</ValueListID><br> <ParentFieldID>00000000-0000-0000-0000-000000000000</ParentFieldID><br> <DescriptorFieldID>00000000-0000-0000-0000-000000000000</DescriptorFieldID><br> <ColumnSize>0</ColumnSize><br> <NumericPrecision>10</NumericPrecision><br> <NumericScale>255</NumericScale><br> <AllowDBNull>true</AllowDBNull><br> <IsUnique>false</IsUnique><br> <IsFakeHistoricalField>false</IsFakeHistoricalField><br> <IsKeyColumn>false</IsKeyColumn><br> <IsAutoIncrement>false</IsAutoIncrement><br> <IsReadOnly>false</IsReadOnly><br> <IsLong>false</IsLong><br> <BaseSchemaName /><br> <BaseCatalogName /><br> <BaseTableName /><br> <BaseColumnname>State</BaseColumnname><br> <RequireAtLeastOneValueToBeSelected>false</RequireAtLeastOneValueToBeSelected><br> <ShowGauge>false</ShowGauge><br> <UseFooterForGauge>false</UseFooterForGauge><br> <DataID>419f5da5-28b7-43f6-b37a-b095d6a59fc0</DataID><br> <ShelfLifeInSeconds>180</ShelfLifeInSeconds><br> <AutoMergeCells>false</AutoMergeCells><br> </Field><br> <Field><br> <Group1FooterFormula /><br> <Group2FooterFormula /><br> <Group3FooterFormula /><br> <FilterChanged>false</FilterChanged><br> <FilterPreQuery>true</FilterPreQuery><br> <ExportAsHHMMSS>false</ExportAsHHMMSS><br> <ReportID>86e60b92-49b6-4d2f-bcdf-20f8cbca2811</ReportID><br> <AllowUsersToShow>true</AllowUsersToShow><br> <NormalizeTimeZone>false</NormalizeTimeZone><br> <TimeFrameType>Y</TimeFrameType><br> <ID>aa3f113c-d835-4469-aa9b-696ded7469f6</ID><br> <DisplayWidth>125</DisplayWidth><br> <ValueCacheLifetimeInMinutes>3</ValueCacheLifetimeInMinutes><br> <ValueSQLQuery /><br> <IsFakeFilterField>false</IsFakeFilterField><br> <IsFormula>false</IsFormula><br> <DisplayFormatStored>FormattedData</DisplayFormatStored><br> <XsltID>00000000-0000-0000-0000-000000000000</XsltID><br> <FooterStyle>None</FooterStyle><br> <DrilldownOptions /><br> <Threshholds /><br> <Key>ProjectedRunDateTime</Key><br> <FormatString /><br> <TableID>00000000-0000-0000-0000-000000000000</TableID><br> <IsAggregate>false</IsAggregate><br> <ActiveFilterIndex>0</ActiveFilterIndex><br> <BluevueName>ProjectedRunDateTime</BluevueName><br> <HighValue>0</HighValue><br> <LowValue>0</LowValue><br> <HighRangeValue>0</HighRangeValue><br> <LowRangeValue>0</LowRangeValue><br> <Randomize>false</Randomize><br> <Filters /><br> <FieldID>aa3f113c-d835-4469-aa9b-696ded7469f6</FieldID><br> <FieldIndex>2</FieldIndex><br> <KeyCriteriaSearchable>false</KeyCriteriaSearchable><br> <ColumnName>ProjectedRunDateTime</ColumnName><br> <DisplayName>ProjectedRunDateTime</DisplayName><br> <KeyCriteria>true</KeyCriteria><br> <KeyCriteriaName>ProjectedRunDateTime</KeyCriteriaName><br> <Displayed>true</Displayed><br> <DecimalPlaces>2</DecimalPlaces><br> <ShowAvg>false</ShowAvg><br> <ShowSum>false</ShowSum><br> <Filter><br> <DayFilter>ALL</DayFilter><br> <FromTime>2010-04-26T00:00:00</FromTime><br> <ToTime>2010-04-26T23:59:59</ToTime><br> <RestrictTime>false</RestrictTime><br> <DatabaseID>17886618-30a0-4e74-96b2-e2d876a0ed45</DatabaseID><br> <IsStockHistoricalFilter>false</IsStockHistoricalFilter><br> <IsCustomReportBuilderFilter>false</IsCustomReportBuilderFilter><br> <Caption>New Filter</Caption><br> <FilterField /><br> <FieldType>BigInt</FieldType><br> <FilterValues /><br> <FilterType1>NoFilter</FilterType1><br> <RollingValue>1</RollingValue><br> <IsHistoricalFilter>false</IsHistoricalFilter><br> <FieldID>aa3f113c-d835-4469-aa9b-696ded7469f6</FieldID><br> <FilteringValues><br> <DataID>aa3f113c-d835-4469-aa9b-696ded7469f6</DataID><br> <Updating>0</Updating><br> <RefreshRate>86400</RefreshRate><br> <LastRefreshed>1970-01-01T01:00:00</LastRefreshed><br> <ValueListQuery /><br> <CollectionQuery /><br> <IsDirty>true</IsDirty><br> <ID>aa3f113c-d835-4469-aa9b-696ded7469f6</ID><br> <DatasourceID /><br> <ValueListDataType>Numeric</ValueListDataType><br> <Values><br> <Values><br> <IsDirty>true</IsDirty><br> <ValueListID>00000000-0000-0000-0000-000000000000</ValueListID><br> <Description /><br> <ValueListValueID>aed290ea-cd20-4a7d-af8c-24de33817efa</ValueListValueID><br> <ValueListValue /><br> <DataType>String</DataType><br> <Ident>0</Ident><br> </Values><br> </Values><br> </FilteringValues><br> <ValueFieldID>00000000-0000-0000-0000-000000000000</ValueFieldID><br> <ValueCollectionID>00000000-0000-0000-0000-000000000000</ValueCollectionID><br> </Filter><br> <DataType>DateTime</DataType><br> <SimpleDataType>Date</SimpleDataType><br> <ColumnOrder>-1</ColumnOrder><br> <Alias /><br> <ValueListID>00000000-0000-0000-0000-000000000000</ValueListID><br> <ParentFieldID>00000000-0000-0000-0000-000000000000</ParentFieldID><br> <DescriptorFieldID>00000000-0000-0000-0000-000000000000</DescriptorFieldID><br> <ColumnSize>0</ColumnSize><br> <NumericPrecision>23</NumericPrecision><br> <NumericScale>3</NumericScale><br> <AllowDBNull>true</AllowDBNull><br> <IsUnique>false</IsUnique><br> <IsFakeHistoricalField>false</IsFakeHistoricalField><br> <IsKeyColumn>false</IsKeyColumn><br> <IsAutoIncrement>false</IsAutoIncrement><br> <IsReadOnly>false</IsReadOnly><br> <IsLong>false</IsLong><br> <BaseSchemaName /><br> <BaseCatalogName /><br> <BaseTableName /><br> <BaseColumnname>ProjectedRunDateTime</BaseColumnname><br> <RequireAtLeastOneValueToBeSelected>false</RequireAtLeastOneValueToBeSelected><br> <ShowGauge>false</ShowGauge><br> <UseFooterForGauge>false</UseFooterForGauge><br> <DataID>aa3f113c-d835-4469-aa9b-696ded7469f6</DataID><br> <ShelfLifeInSeconds>180</ShelfLifeInSeconds><br> <AutoMergeCells>false</AutoMergeCells><br> </Field><br> <Field><br> <Group1FooterFormula /><br> <Group2FooterFormula /><br> <Group3FooterFormula /><br> <FilterChanged>false</FilterChanged><br> <FilterPreQuery>true</FilterPreQuery><br> <ExportAsHHMMSS>false</ExportAsHHMMSS><br> <ReportID>86e60b92-49b6-4d2f-bcdf-20f8cbca2811</ReportID><br> <AllowUsersToShow>true</AllowUsersToShow><br> <NormalizeTimeZone>false</NormalizeTimeZone><br> <TimeFrameType>Y</TimeFrameType><br> <ID>5927a923-0ea4-4d43-a4c9-2d84c460b6cd</ID><br> <DisplayWidth>125</DisplayWidth><br> <ValueCacheLifetimeInMinutes>3</ValueCacheLifetimeInMinutes><br> <ValueSQLQuery /><br> <IsFakeFilterField>false</IsFakeFilterField><br> <IsFormula>false</IsFormula><br> <DisplayFormatStored>FormattedData</DisplayFormatStored><br> <XsltID>00000000-0000-0000-0000-000000000000</XsltID><br> <FooterStyle>None</FooterStyle><br> <DrilldownOptions /><br> <Threshholds /><br> <Key>ActualRunDateTime</Key><br> <FormatString /><br> <TableID>00000000-0000-0000-0000-000000000000</TableID><br> <IsAggregate>false</IsAggregate><br> <ActiveFilterIndex>0</ActiveFilterIndex><br> <BluevueName>ActualRunDateTime</BluevueName><br> <HighValue>0</HighValue><br> <LowValue>0</LowValue><br> <HighRangeValue>0</HighRangeValue><br> <LowRangeValue>0</LowRangeValue><br> <Randomize>false</Randomize><br> <Filters /><br> <FieldID>5927a923-0ea4-4d43-a4c9-2d84c460b6cd</FieldID><br> <FieldIndex>3</FieldIndex><br> <KeyCriteriaSearchable>false</KeyCriteriaSearchable><br> <ColumnName>ActualRunDateTime</ColumnName><br> <DisplayName>ActualRunDateTime</DisplayName><br> <KeyCriteria>true</KeyCriteria><br> <KeyCriteriaName>ActualRunDateTime</KeyCriteriaName><br> <Displayed>true</Displayed><br> <DecimalPlaces>2</DecimalPlaces><br> <ShowAvg>false</ShowAvg><br> <ShowSum>false</ShowSum><br> <Filter><br> <DayFilter>ALL</DayFilter><br> <FromTime>2010-04-26T00:00:00</FromTime><br> <ToTime>2010-04-26T23:59:59</ToTime><br> <RestrictTime>false</RestrictTime><br> <DatabaseID>8b2208e6-c071-4ec6-8158-cf0fa561684d</DatabaseID><br> <IsStockHistoricalFilter>false</IsStockHistoricalFilter><br> <IsCustomReportBuilderFilter>false</IsCustomReportBuilderFilter><br> <Caption>New Filter</Caption><br> <FilterField /><br> <FieldType>BigInt</FieldType><br> <FilterValues /><br> <FilterType1>NoFilter</FilterType1><br> <RollingValue>1</RollingValue><br> <IsHistoricalFilter>false</IsHistoricalFilter><br> <FieldID>5927a923-0ea4-4d43-a4c9-2d84c460b6cd</FieldID><br> <FilteringValues><br> <DataID>5927a923-0ea4-4d43-a4c9-2d84c460b6cd</DataID><br> <Updating>0</Updating><br> <RefreshRate>86400</RefreshRate><br> <LastRefreshed>1970-01-01T01:00:00</LastRefreshed><br> <ValueListQuery /><br> <CollectionQuery /><br> <IsDirty>true</IsDirty><br> <ID>5927a923-0ea4-4d43-a4c9-2d84c460b6cd</ID><br> <DatasourceID /><br> <ValueListDataType>Numeric</ValueListDataType><br> <Values><br> <Values><br> <IsDirty>true</IsDirty><br> <ValueListID>00000000-0000-0000-0000-000000000000</ValueListID><br> <Description /><br> <ValueListValueID>35a29450-2e3a-46b8-b438-166bd21a93da</ValueListValueID><br> <ValueListValue /><br> <DataType>String</DataType><br> <Ident>0</Ident><br> </Values><br> </Values><br> </FilteringValues><br> <ValueFieldID>00000000-0000-0000-0000-000000000000</ValueFieldID><br> <ValueCollectionID>00000000-0000-0000-0000-000000000000</ValueCollectionID><br> </Filter><br> <DataType>DateTime</DataType><br> <SimpleDataType>Date</SimpleDataType><br> <ColumnOrder>-1</ColumnOrder><br> <Alias /><br> <ValueListID>00000000-0000-0000-0000-000000000000</ValueListID><br> <ParentFieldID>00000000-0000-0000-0000-000000000000</ParentFieldID><br> <DescriptorFieldID>00000000-0000-0000-0000-000000000000</DescriptorFieldID><br> <ColumnSize>0</ColumnSize><br> <NumericPrecision>23</NumericPrecision><br> <NumericScale>3</NumericScale><br> <AllowDBNull>true</AllowDBNull><br> <IsUnique>false</IsUnique><br> <IsFakeHistoricalField>false</IsFakeHistoricalField><br> <IsKeyColumn>false</IsKeyColumn><br> <IsAutoIncrement>false</IsAutoIncrement><br> <IsReadOnly>false</IsReadOnly><br> <IsLong>false</IsLong><br> <BaseSchemaName /><br> <BaseCatalogName /><br> <BaseTableName /><br> <BaseColumnname>ActualRunDateTime</BaseColumnname><br> <RequireAtLeastOneValueToBeSelected>false</RequireAtLeastOneValueToBeSelected><br> <ShowGauge>false</ShowGauge><br> <UseFooterForGauge>false</UseFooterForGauge><br> <DataID>5927a923-0ea4-4d43-a4c9-2d84c460b6cd</DataID><br> <ShelfLifeInSeconds>180</ShelfLifeInSeconds><br> <AutoMergeCells>false</AutoMergeCells><br> </Field><br> </Fields><br> <HistoricalKey /><br> <ReportTypeUserSystem>PERSONAL</ReportTypeUserSystem><br> <ReportAccessLevel>PRIVATE</ReportAccessLevel><br> <PageSize>200</PageSize><br> <HelpLink /><br> <HelpLinkTitle /><br></SerializedReport><br> | ||
| + | |||
|- | |- | ||
| - | ! '''Release''' | + | ! '''Release''' |
| Release 7.5(x) | | Release 7.5(x) | ||
|- | |- | ||
| - | ! '''Associated CDETS #''' | + | ! '''Associated CDETS #''' |
| Not relevant | | Not relevant | ||
| - | |||
|} | |} | ||
| + | |||
| + | [[Category:Unified_IS,_Release_7.5]] | ||
Latest revision as of 08:00, 3 July 2012
Reporting: Report for Scheduled reports
| Problem Summary | Check the status of reports that are scheduled |
|---|---|
| Error Message | Not relevant |
| Possible Cause | Not relevant |
| Recommended Action |
Save the XML below to a file and import as report. <?xml version="1.0" encoding="utf-8"?> where ProjectedRunDateTime>:From and ProjectedRunDateTime<:To and A.ScheduleID=B.ID order by ProjectedRunDateTime</AnonymousBlock> |
| Release | Release 7.5(x) |
| Associated CDETS # | Not relevant |