• State Verified Answer
  • Locked Locked
  • Replies 32 replies
  • Subscribers 18 subscribers
  • Views 9577 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Help Modifying a custom report to give me the ability to enter specific dates (pull historical) and then default to the last "Month"

bgetz

HI Guys,

I have had NCM installed and monitoring for a few months now but due to issues never got my "Uptime" report working.  I worked with presales before purchasing and they helped get a demo report working off a custom field using SWQL queries.

The problem with these queries is that the WHERE statement is hardcoded to last 30 days and I lost the ability to change the table to use "Last Month" or any of the other prebuilt options in report builder.  

How can I change this SWQL statement to be able to hard code specific dates so I can get my missing historical data?  

Then I want to schedule the report automatically to report on the last month at the first of the new month.  How do I get it to properly do 30/31 days?

I have two custom queries as follows right now that both need modified.

SELECT 
     Orin.CustomProperties.AvailabilityReportingGroups as [Team]
,    OriN.Caption as [Node Name]
,    ToString(Round(AVG(OriN.ResponseTimeHistory.Availability),2))+'%' as Avail
     FROM Orion.Nodes OriN
WHERE OriN.ResponseTimeHistory.DateTime>ADDDAY(-30, GETDATE())
GROUP BY Orin.CustomProperties.AvailabilityReportingGroups, OriN.Caption
ORDER BY Orin.CustomProperties.AvailabilityReportingGroups, OriN.Caption DESC

SELECT
      OriC.AvailabilityReportingGroups as [Team]
,     ToString(Round(AVG(OriC.Node.ResponseTimeHistory.Availability),2))+'%' as [Availabilty]
FROM Orion.NodesCustomProperties OriC
WHERE OriC.AvailabilityReportingGroups IS NOT NULL and OriC.node.ResponseTimeHistory.DateTime>ADDDAY(-30, GETDATE())
GROUP BY OriC.AvailabilityReportingGroups

Any help is appreciated!

Parents
  • 0

    In the web reporting you can use the ${FromTime} and ${ToTime} values. [Explained in more details on Using SWQL/SQL with web-based reports (solarwinds.com)]

    Your first report query would change to this: [UPDATED]

    SELECT [Nodes].CustomProperties.AvailabilityReportingGroups as [Team]
     , [Nodes].Caption as [Node Name]
     , CONCAT(ROUND(AVG( [Nodes].ResponseTimeHistory.Availability ), 2), '%') as Avail
FROM Orion.Nodes AS [Nodes]
-- Old WHERE clause
--WHERE [Nodes].ResponseTimeHistory.DateTime>ADDDAY(-30, GETDATE())
-- New WHERE clause (my preferred way)
WHERE [Nodes].ResponseTimeHistory.DateTime BETWEEN ${FromTime} AND ${ToTime}
-- Other way
-- WHERE [Nodes].ResponseTimeHistory.DateTime >= ${FromTime}
--   AND [Nodes].ResponseTimeHistory.DateTime < ${ToTime}
GROUP BY [Nodes].CustomProperties.AvailabilityReportingGroups
       , [Nodes].Caption
ORDER BY [Nodes].CustomProperties.AvailabilityReportingGroups
       , [Nodes].Caption DESC

    Note: I changed a few things to get in line with the way that I prefer my queries, but functionally, it's the same.

    Same note applies to your second query. [UPDATED]

    SELECT [NodeCPs].AvailabilityReportingGroups as [Team]
     , CONCAT(ROUND(AVG( [NodeCPs].Node.ResponseTimeHistory.Availability ), 2 ), '%') as [Availabilty]
FROM Orion.NodesCustomProperties [NodeCPs]
--Old WHERE clause
--WHERE [NodeCPs].AvailabilityReportingGroups IS NOT NULL 
--  AND [NodeCPs].Node.ResponseTimeHistory.DateTime>ADDDAY(-30, GETDATE())
-- New WHERE clause (my preferred way)
WHERE ISNULL([NodeCPs].AvailabilityReportingGroups, '') <> ''
  AND [NodeCPs].Node.ResponseTimeHistory.DateTime BETWEEN ${FromTime} AND ${ToTime}
-- Other way
-- WHERE ISNULL([NodeCPs].AvailabilityReportingGroups, '') <> ''
--   AND [NodeCPs].Node.ResponseTimeHistory.DateTime >= ${FromTime}
--   AND [NodeCPs].Node.ResponseTimeHistory.DateTime < ${ToTime}
GROUP BY [NodeCPs].AvailabilityReportingGroups

  • 0 in reply to KMSigma.SWI

    When pasting into my report i simply get "Query is not valid".  

    Also to note the option to select a time frame is gone, so I assume i have to hard code it somehow?

  • 0 in reply to bgetz

    I mean, this is a downtime report, so if there's no downtime, it shouldn't exist on the report.  That said it does seem like unusual data responses.

    How many nodes do you have in your environment?  Because there's so much behind the scenes in this report, we may be running into a timeout issue.

  • 0 in reply to KMSigma.SWI

    Well true.  I guess its probably simpler to just focus on my report and try to figure out why it wont work with the fields you added.  When I imported your report it does have the field.

    Any chance you can export an xml of my data with it working on your side?

  • 0 in reply to bgetz
    bgetz said:
    Any chance you can export an xml of my data with it working on your side?

    Do you mean, me work with your report?

    If so, you can export it and attach it to this thread. Exporting and Importing Shared Content - THWACK Documentation - THWACK Command Center - THWACK - SolarWinds Community

  • 0 in reply to KMSigma.SWI

    Fullscreen KT+Node+and+Group+Availability+-+Last+30+days.xml Download 
    <Report xmlns="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><Category>Daily Node Availability</Category><Configs xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Data"><a:ConfigurationData i:type="b:TableConfiguration" xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Tables"><a:DisplaySubTitle/><a:DisplayTitle>Node Availability - This Month</a:DisplayTitle><a:RefId>de05db73-fa01-48f5-bc16-6582a4fee4c9</a:RefId><b:Columns><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>Team</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType i:nil="true"/><a:DataType><a:Data>System.String</a:Data></a:DataType><a:DeclType>Enumerated</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description>Group for Availability Reporting</a:Description><a:IsFavorite>true</a:IsFavorite><a:IsFilterBy>true</a:IsFilterBy><a:IsGroupBy>true</a:IsGroupBy><a:IsInherited>false</a:IsInherited><a:IsManaged>false</a:IsManaged><a:IsStatistic>false</a:IsStatistic><a:PreviewValue>Dev Servers</a:PreviewValue><a:Units/><a:UtcTimeIsInLocalTime>true</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>Team</c:DisplayName><c:NavigationPath i:nil="true"/><c:OwnerDisplayName i:nil="true"/><c:RefID><c:Data>Orion.NodesCustomProperties|AvailabilityReportingGroups|Team</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>false</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/><b:PropertyName>Team</b:PropertyName><b:RefId>671d2a94-db1f-0f37-df15-05e6fbfaa881</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>Node Name</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType i:nil="true"/><a:DataType><a:Data>System.String</a:Data></a:DataType><a:DeclType>Text</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description/><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>true</a:IsFilterBy><a:IsGroupBy>true</a:IsGroupBy><a:IsInherited>false</a:IsInherited><a:IsManaged>true</a:IsManaged><a:IsStatistic>false</a:IsStatistic><a:PreviewValue>LS1-CR-9300.kleintools.com</a:PreviewValue><a:Units/><a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>Node Name</c:DisplayName><c:NavigationPath i:nil="true"/><c:OwnerDisplayName i:nil="true"/><c:RefID><c:Data>Orion.Nodes|Caption|Node Name</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>false</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/><b:PropertyName>Node Name</b:PropertyName><b:RefId>226e1460-911e-9064-a0fd-70288ce6a1ac</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>Avail</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType i:nil="true"/><a:DataType><a:Data>System.String</a:Data></a:DataType><a:DeclType>Text</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description i:nil="true"/><a:IsFavorite i:nil="true"/><a:IsFilterBy i:nil="true"/><a:IsGroupBy i:nil="true"/><a:IsInherited i:nil="true"/><a:IsManaged i:nil="true"/><a:IsStatistic i:nil="true"/><a:PreviewValue i:nil="true"/><a:Units i:nil="true"/><a:UtcTimeIsInLocalTime i:nil="true"/></c:DataTypeInfo><c:DisplayName>Avail</c:DisplayName><c:NavigationPath i:nil="true"/><c:OwnerDisplayName i:nil="true"/><c:RefID><c:Data>db|Avail|computed</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>false</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/><b:PropertyName>Avail</b:PropertyName><b:RefId>535509cd-7e35-61aa-13e7-11ef297d4a23</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn></b:Columns><b:DefaultStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/><b:Filter xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:Expression i:nil="true"/><c:Limit><c:Count i:nil="true"/><c:Mode>ShowAll</c:Mode><c:OrionServerIDsToIgnore i:nil="true"/><c:Percentage i:nil="true"/></c:Limit></b:Filter><b:Indents/><b:Sorts xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"/><b:SummarizeMode>NoDataSummarization</b:SummarizeMode><b:TimeField i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"/></a:ConfigurationData><a:ConfigurationData i:type="b:TableConfiguration" xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Tables"><a:DisplaySubTitle/><a:DisplayTitle>Custom Table</a:DisplayTitle><a:RefId>c91201da-62ac-43b6-be28-4f2c34effdae</a:RefId><b:Columns><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>Team</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType i:nil="true"/><a:DataType><a:Data>System.String</a:Data></a:DataType><a:DeclType>Enumerated</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description>Group for Availability Reporting</a:Description><a:IsFavorite>true</a:IsFavorite><a:IsFilterBy>true</a:IsFilterBy><a:IsGroupBy>true</a:IsGroupBy><a:IsInherited>false</a:IsInherited><a:IsManaged>false</a:IsManaged><a:IsStatistic>false</a:IsStatistic><a:PreviewValue>Dev Servers</a:PreviewValue><a:Units/><a:UtcTimeIsInLocalTime>true</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>Team</c:DisplayName><c:NavigationPath i:nil="true"/><c:OwnerDisplayName i:nil="true"/><c:RefID><c:Data>Orion.NodesCustomProperties|AvailabilityReportingGroups|Team</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>false</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/><b:PropertyName>Team</b:PropertyName><b:RefId>7f84e83c-34f3-eb10-1ce1-d4e3ae115684</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>Availabilty</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType i:nil="true"/><a:DataType><a:Data>System.Double</a:Data></a:DataType><a:DeclType>Text</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description i:nil="true"/><a:IsFavorite i:nil="true"/><a:IsFilterBy i:nil="true"/><a:IsGroupBy i:nil="true"/><a:IsInherited i:nil="true"/><a:IsManaged i:nil="true"/><a:IsStatistic i:nil="true"/><a:PreviewValue i:nil="true"/><a:Units i:nil="true"/><a:UtcTimeIsInLocalTime i:nil="true"/></c:DataTypeInfo><c:DisplayName>Availabilty</c:DisplayName><c:NavigationPath i:nil="true"/><c:OwnerDisplayName i:nil="true"/><c:RefID><c:Data>db|Availabilty|computed</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>false</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/><b:PropertyName>Availabilty</b:PropertyName><b:RefId>35b57fa2-b1f2-3996-79c7-60540744cda7</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn></b:Columns><b:DefaultStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/><b:Filter xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:Expression i:nil="true"/><c:Limit><c:Count i:nil="true"/><c:Mode>ShowAll</c:Mode><c:OrionServerIDsToIgnore i:nil="true"/><c:Percentage i:nil="true"/></c:Limit></b:Filter><b:Indents/><b:Sorts xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"/><b:SummarizeMode>NoDataSummarization</b:SummarizeMode><b:TimeField i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"/></a:ConfigurationData></Configs><DataSources xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><a:DataSource><a:CommandText>SELECT [Nodes].CustomProperties.AvailabilityReportingGroups as [Team]
     , [Nodes].Caption as [Node Name]
     , CONCAT(ROUND(AVG( [Nodes].ResponseTimeHistory.Availability ), 2), '%') as Avail
FROM Orion.Nodes AS [Nodes]
-- Old WHERE clause
--WHERE [Nodes].ResponseTimeHistory.DateTime&gt;ADDDAY(-30, GETDATE())
-- New WHERE clause (my preferred way)
WHERE [Nodes].ResponseTimeHistory.DateTime BETWEEN ${FromTime} AND ${ToTime}
-- Other way
-- WHERE [Nodes].ResponseTimeHistory.DateTime &gt;= ${FromTime}
--   AND [Nodes].ResponseTimeHistory.DateTime &lt; ${ToTime}
GROUP BY [Nodes].CustomProperties.AvailabilityReportingGroups
       , [Nodes].Caption
ORDER BY [Nodes].CustomProperties.AvailabilityReportingGroups
       , [Nodes].Caption DESC</a:CommandText><a:DynamicSelectionType>Undefined</a:DynamicSelectionType><a:EntityUri xmlns:b="http://schemas.microsoft.com/2003/10/Serialization/Arrays"/><a:Filter i:nil="true"/><a:MasterEntity>orion.nodes</a:MasterEntity><a:Name>Individual Nodes</a:Name><a:NetObjectId/><a:RefId>2c39dc54-9b5a-4824-a282-c487c78a93e2</a:RefId><a:Type>CustomSWQL</a:Type></a:DataSource><a:DataSource><a:CommandText>SELECT [NodeCPs].AvailabilityReportingGroups as [Team]
     , CONCAT(ROUND(AVG( [NodeCPs].Node.ResponseTimeHistory.Availability ), 2 ), '%') as [Availabilty]
FROM Orion.NodesCustomProperties [NodeCPs]
--Old WHERE clause
--WHERE [NodeCPs].AvailabilityReportingGroups IS NOT NULL 
--  AND [NodeCPs].Node.ResponseTimeHistory.DateTime&gt;ADDDAY(-30, GETDATE())
-- New WHERE clause (my preferred way)
WHERE ISNULL([NodeCPs].AvailabilityReportingGroups, '') &lt;&gt; ''
  AND [NodeCPs].Node.ResponseTimeHistory.DateTime BETWEEN ${FromTime} AND ${ToTime}
-- Other way
-- WHERE ISNULL([NodeCPs].AvailabilityReportingGroups, '') &lt;&gt; ''
--   AND [NodeCPs].Node.ResponseTimeHistory.DateTime &gt;= ${FromTime}
--   AND [NodeCPs].Node.ResponseTimeHistory.DateTime &lt; ${ToTime}
GROUP BY [NodeCPs].AvailabilityReportingGroups</a:CommandText><a:DynamicSelectionType>Undefined</a:DynamicSelectionType><a:EntityUri xmlns:b="http://schemas.microsoft.com/2003/10/Serialization/Arrays"/><a:Filter i:nil="true"/><a:MasterEntity>Orion.Nodes</a:MasterEntity><a:Name>Group Availability</a:Name><a:NetObjectId/><a:RefId>0a627900-13d1-4592-b273-68c270287656</a:RefId><a:Type>CustomSWQL</a:Type></a:DataSource></DataSources><Description>Displays the Average Availability for each node for this month</Description><Footer xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Layout"><a:CustomText>© SolarWinds Worldwide, LLC. All Rights Reserved.</a:CustomText><a:ShowCustomText>true</a:ShowCustomText><a:ShowPageNumber>true</a:ShowPageNumber><a:ShowTimestamp>true</a:ShowTimestamp><a:Visible>true</a:Visible></Footer><Header xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Layout"><a:Logo>standard</a:Logo><a:SubTitle/><a:Title>KT Node and Group Availability - Last 30 days</a:Title><a:Visible>true</a:Visible></Header><LimitationCategory>Default Folder</LimitationCategory><ModuleTitle i:nil="true"/><Name>KT Node and Group Availability - Last 30 days</Name><OrionFeatureName i:nil="true"/><PageLayout xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Layout"><a:Height>0</a:Height><a:Orientation i:nil="true"/><a:PublishingType>web</a:PublishingType><a:Size i:nil="true"/><a:Units i:nil="true"/><a:Width>960</a:Width></PageLayout><ReportGuid>765121c3-d364-45fa-b6d5-9b4943d1f431</ReportGuid><Sections xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Layout"><a:Section><a:BorderStyle xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><b:Bottom i:nil="true"/><b:Color i:nil="true"/><b:Left i:nil="true"/><b:Right i:nil="true"/><b:Top i:nil="true"/></a:BorderStyle><a:Columns><a:SectionColumn><a:BorderStyle xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><b:Bottom i:nil="true"/><b:Color i:nil="true"/><b:Left i:nil="true"/><b:Right i:nil="true"/><b:Top i:nil="true"/></a:BorderStyle><a:Cells><a:SectionCell><a:Config i:nil="true" xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Data"/><a:ConfigId>c91201da-62ac-43b6-be28-4f2c34effdae</a:ConfigId><a:DataSelectionRefId>0a627900-13d1-4592-b273-68c270287656</a:DataSelectionRefId><a:DisplayName>Custom Table</a:DisplayName><a:RefId>36f5cf0c-e765-46b0-b604-a0e51885c6e1</a:RefId><a:RenderProvider>SolarWinds.Reporting,Table</a:RenderProvider><a:TimeframeRefId>ffffffff-ffff-ffff-ffff-ffffffffffff</a:TimeframeRefId></a:SectionCell><a:SectionCell><a:Config i:nil="true" xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Data"/><a:ConfigId>de05db73-fa01-48f5-bc16-6582a4fee4c9</a:ConfigId><a:DataSelectionRefId>2c39dc54-9b5a-4824-a282-c487c78a93e2</a:DataSelectionRefId><a:DisplayName>Custom Table</a:DisplayName><a:RefId>fb5b97a9-c0ec-4b56-96c1-3d9b797373ca</a:RefId><a:RenderProvider>SolarWinds.Reporting,Table</a:RenderProvider><a:TimeframeRefId>ffffffff-ffff-ffff-ffff-ffffffffffff</a:TimeframeRefId></a:SectionCell></a:Cells><a:ColumnGutter i:nil="true"/><a:PercentWidth>100</a:PercentWidth><a:PixelWidth i:nil="true"/><a:RefId>92cdd64a-3959-488a-b38f-2a0ce3d842fa</a:RefId><a:Subtitle/><a:Title/></a:SectionColumn></a:Columns><a:RefId>7efe6654-8645-4936-98dd-6bc1b9617e89</a:RefId></a:Section></Sections><TimeFrames xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Timing"><a:TimeFrame><a:DisplayName>This Month</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>c1abbcf6-41b8-46c1-aaaf-5d7aeed64bf3</a:RefId><a:Relative><a:NamedTimeFrame>ThisMonth</a:NamedTimeFrame><a:Unit>Month</a:Unit><a:UnitCount>1</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame><a:TimeFrame><a:DisplayName>Last Month</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>a42a8524-7884-489d-95aa-8b5c38a80b46</a:RefId><a:Relative><a:NamedTimeFrame>LastMonth</a:NamedTimeFrame><a:Unit>Month</a:Unit><a:UnitCount>1</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame><a:TimeFrame><a:DisplayName>Past Hour</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>3d6c60fc-bb11-4fa1-80a8-be1fee216320</a:RefId><a:Relative><a:NamedTimeFrame>PastHour</a:NamedTimeFrame><a:Unit>Hour</a:Unit><a:UnitCount>1</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame></TimeFrames></Report>
    Attached my current report.  Would love to know if the dates work for you.

  • 0 in reply to bgetz

    This is how mine looks (I had to edit a few things because I didn't have the exact same CP name - mine was singular and yours was plural)

    Still not doing the ${FromTime} and ${ToTime} correctly.  That annoys me in so many ways.

  • 0 in reply to KMSigma.SWI

    Okay so definitely a bug of some kind. I guess I will have to try and figure something else out on this.  Thanks

  • 0 in reply to KMSigma.SWI

    Fullscreen Possibly+Better+KT+Report.xml Download 
    <Report xmlns="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
	<Category>Custom</Category>
	<Configs xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Data">
		<a:ConfigurationData i:type="b:TableConfiguration" xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Tables">
			<a:DisplaySubTitle/>
			<a:DisplayTitle>Custom Table</a:DisplayTitle>
			<a:RefId>fc29976b-d89a-4a93-b5f5-e85d3b92d3c1</a:RefId>
			<b:Columns>
				<b:TableColumn>
					<b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles">
						<c:BackgroundColor i:nil="true"/>
						<c:Borders i:nil="true"/>
						<c:DisplayName i:nil="true"/>
						<c:Font i:nil="true"/>
						<c:Padding i:nil="true"/>
						<c:RefId>00000000-0000-0000-0000-000000000000</c:RefId>
						<c:TextAlign>Left</c:TextAlign>
						<c:ZebraBackgroundColor i:nil="true"/>
					</b:CellStyle>
					<b:DataColumnName i:nil="true"/>
					<b:DisplayName>Team</b:DisplayName>
					<b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection">
						<c:DataTypeInfo>
							<a:ApplicationType i:nil="true"/>
							<a:DataType>
								<a:Data>System.String</a:Data>
							</a:DataType>
							<a:DeclType>Text</a:DeclType>
							<a:DefaultAggregation>NotSpecified</a:DefaultAggregation>
							<a:DefaultDataUnitId i:nil="true"/>
							<a:DefaultTransformId i:nil="true"/>
							<a:Description i:nil="true"/>
							<a:IsFavorite i:nil="true"/>
							<a:IsFilterBy i:nil="true"/>
							<a:IsGroupBy i:nil="true"/>
							<a:IsInherited i:nil="true"/>
							<a:IsManaged i:nil="true"/>
							<a:IsStatistic i:nil="true"/>
							<a:PreviewValue i:nil="true"/>
							<a:Units i:nil="true"/>
							<a:UtcTimeIsInLocalTime i:nil="true"/>
						</c:DataTypeInfo>
						<c:DisplayName>AvailabilityReportingGroup</c:DisplayName>
						<c:NavigationPath i:nil="true"/>
						<c:OwnerDisplayName i:nil="true"/>
						<c:RefID>
							<c:Data>db|AvailabilityReportingGroup|computed</c:Data>
						</c:RefID>
					</b:Field>
					<b:FixedWidth i:nil="true"/>
					<b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles">
						<c:BackgroundColor i:nil="true"/>
						<c:Borders i:nil="true"/>
						<c:DisplayName i:nil="true"/>
						<c:Font i:nil="true"/>
						<c:Padding i:nil="true"/>
						<c:RefId>00000000-0000-0000-0000-000000000000</c:RefId>
						<c:TextAlign>Left</c:TextAlign>
						<c:ZebraBackgroundColor i:nil="true"/>
					</b:HeaderStyle>
					<b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed>
					<b:IsHidden>false</b:IsHidden>
					<b:PercentWidth i:nil="true"/>
					<b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/>
					<b:PropertyName>AvailabilityReportingGroup</b:PropertyName>
					<b:RefId>a84afba0-69d8-9555-9039-35a0c9eeeaac</b:RefId>
					<b:Summary>
						<b:Calculation>NotSpecified</b:Calculation>
						<b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/>
					</b:Summary>
					<b:TransformId/>
					<b:ValidRange>NotSpecified</b:ValidRange>
				</b:TableColumn>
				<b:TableColumn>
					<b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles">
						<c:BackgroundColor i:nil="true"/>
						<c:Borders i:nil="true"/>
						<c:DisplayName i:nil="true"/>
						<c:Font i:nil="true"/>
						<c:Padding i:nil="true"/>
						<c:RefId>00000000-0000-0000-0000-000000000000</c:RefId>
						<c:TextAlign>Left</c:TextAlign>
						<c:ZebraBackgroundColor i:nil="true"/>
					</b:CellStyle>
					<b:DataColumnName i:nil="true"/>
					<b:DisplayName>Node</b:DisplayName>
					<b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection">
						<c:DataTypeInfo>
							<a:ApplicationType i:nil="true"/>
							<a:DataType>
								<a:Data>System.String</a:Data>
							</a:DataType>
							<a:DeclType>Text</a:DeclType>
							<a:DefaultAggregation>NotSpecified</a:DefaultAggregation>
							<a:DefaultDataUnitId i:nil="true"/>
							<a:DefaultTransformId i:nil="true"/>
							<a:Description/>
							<a:IsFavorite>false</a:IsFavorite>
							<a:IsFilterBy>true</a:IsFilterBy>
							<a:IsGroupBy>true</a:IsGroupBy>
							<a:IsInherited>false</a:IsInherited>
							<a:IsManaged>true</a:IsManaged>
							<a:IsStatistic>false</a:IsStatistic>
							<a:PreviewValue>KMSHCOMPE01v</a:PreviewValue>
							<a:Units/>
							<a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime>
						</c:DataTypeInfo>
						<c:DisplayName>Caption</c:DisplayName>
						<c:NavigationPath i:nil="true"/>
						<c:OwnerDisplayName i:nil="true"/>
						<c:RefID>
							<c:Data>Orion.Nodes|Caption</c:Data>
						</c:RefID>
					</b:Field>
					<b:FixedWidth i:nil="true"/>
					<b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles">
						<c:BackgroundColor i:nil="true"/>
						<c:Borders i:nil="true"/>
						<c:DisplayName i:nil="true"/>
						<c:Font i:nil="true"/>
						<c:Padding i:nil="true"/>
						<c:RefId>00000000-0000-0000-0000-000000000000</c:RefId>
						<c:TextAlign>Left</c:TextAlign>
						<c:ZebraBackgroundColor i:nil="true"/>
					</b:HeaderStyle>
					<b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed>
					<b:IsHidden>false</b:IsHidden>
					<b:PercentWidth i:nil="true"/>
					<b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/>
					<b:PropertyName>Caption</b:PropertyName>
					<b:RefId>c07c215d-0ba5-08b0-7da1-483fee14fbb5</b:RefId>
					<b:Summary>
						<b:Calculation>NotSpecified</b:Calculation>
						<b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/>
					</b:Summary>
					<b:TransformId/>
					<b:ValidRange>NotSpecified</b:ValidRange>
				</b:TableColumn>
				<b:TableColumn>
					<b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles">
						<c:BackgroundColor i:nil="true"/>
						<c:Borders i:nil="true"/>
						<c:DisplayName i:nil="true"/>
						<c:Font i:nil="true"/>
						<c:Padding i:nil="true"/>
						<c:RefId>00000000-0000-0000-0000-000000000000</c:RefId>
						<c:TextAlign>Right</c:TextAlign>
						<c:ZebraBackgroundColor i:nil="true"/>
					</b:CellStyle>
					<b:DataColumnName i:nil="true"/>
					<b:DisplayName>Availability</b:DisplayName>
					<b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection">
						<c:DataTypeInfo>
							<a:ApplicationType>Core.Percent</a:ApplicationType>
							<a:DataType>
								<a:Data>System.Double</a:Data>
							</a:DataType>
							<a:DeclType>Float</a:DeclType>
							<a:DefaultAggregation>Average</a:DefaultAggregation>
							<a:DefaultDataUnitId i:nil="true"/>
							<a:DefaultTransformId i:nil="true"/>
							<a:Description/>
							<a:IsFavorite>false</a:IsFavorite>
							<a:IsFilterBy>false</a:IsFilterBy>
							<a:IsGroupBy>false</a:IsGroupBy>
							<a:IsInherited>false</a:IsInherited>
							<a:IsManaged>false</a:IsManaged>
							<a:IsStatistic>true</a:IsStatistic>
							<a:PreviewValue>100</a:PreviewValue>
							<a:Units/>
							<a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime>
						</c:DataTypeInfo>
						<c:DisplayName>Availability</c:DisplayName>
						<c:NavigationPath i:nil="true"/>
						<c:OwnerDisplayName i:nil="true"/>
						<c:RefID>
							<c:Data>Orion.ResponseTime|Availability</c:Data>
						</c:RefID>
					</b:Field>
					<b:FixedWidth i:nil="true"/>
					<b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles">
						<c:BackgroundColor i:nil="true"/>
						<c:Borders i:nil="true"/>
						<c:DisplayName i:nil="true"/>
						<c:Font i:nil="true"/>
						<c:Padding i:nil="true"/>
						<c:RefId>00000000-0000-0000-0000-000000000000</c:RefId>
						<c:TextAlign>Right</c:TextAlign>
						<c:ZebraBackgroundColor i:nil="true"/>
					</b:HeaderStyle>
					<b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed>
					<b:IsHidden>false</b:IsHidden>
					<b:PercentWidth i:nil="true"/>
					<b:Presenters xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation">
						<c:PresenterRef>
							<c:PresenterId>orion.core.text.numericformat</c:PresenterId>
							<c:Values>
								<a:ContextValue>
									<a:Name>NumericFormat</a:Name>
									<a:Value>{0:0.00} %</a:Value>
								</a:ContextValue>
							</c:Values>
						</c:PresenterRef>
					</b:Presenters>
					<b:PropertyName>Availability</b:PropertyName>
					<b:RefId>57b70150-ff3c-9371-4783-66f79662ab23</b:RefId>
					<b:Summary>
						<b:Calculation>Average</b:Calculation>
						<b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/>
					</b:Summary>
					<b:TransformId/>
					<b:ValidRange>NotSpecified</b:ValidRange>
				</b:TableColumn>
				<b:TableColumn>
					<b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles">
						<c:BackgroundColor i:nil="true"/>
						<c:Borders i:nil="true"/>
						<c:DisplayName i:nil="true"/>
						<c:Font i:nil="true"/>
						<c:Padding i:nil="true"/>
						<c:RefId>00000000-0000-0000-0000-000000000000</c:RefId>
						<c:TextAlign>Left</c:TextAlign>
						<c:ZebraBackgroundColor i:nil="true"/>
					</b:CellStyle>
					<b:DataColumnName i:nil="true"/>
					<b:DisplayName>ObservationTimestamp</b:DisplayName>
					<b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection">
						<c:DataTypeInfo>
							<a:ApplicationType i:nil="true"/>
							<a:DataType>
								<a:Data>System.DateTime</a:Data>
							</a:DataType>
							<a:DeclType>DateTime</a:DeclType>
							<a:DefaultAggregation>NotSpecified</a:DefaultAggregation>
							<a:DefaultDataUnitId i:nil="true"/>
							<a:DefaultTransformId i:nil="true"/>
							<a:Description/>
							<a:IsFavorite>false</a:IsFavorite>
							<a:IsFilterBy>false</a:IsFilterBy>
							<a:IsGroupBy>false</a:IsGroupBy>
							<a:IsInherited>true</a:IsInherited>
							<a:IsManaged>false</a:IsManaged>
							<a:IsStatistic>true</a:IsStatistic>
							<a:PreviewValue>8/1/2022 1:03:59 PM</a:PreviewValue>
							<a:Units/>
							<a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime>
						</c:DataTypeInfo>
						<c:DisplayName>ObservationTimestamp</c:DisplayName>
						<c:NavigationPath i:nil="true"/>
						<c:OwnerDisplayName i:nil="true"/>
						<c:RefID>
							<c:Data>Orion.ResponseTime|ObservationTimestamp</c:Data>
						</c:RefID>
					</b:Field>
					<b:FixedWidth i:nil="true"/>
					<b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles">
						<c:BackgroundColor i:nil="true"/>
						<c:Borders i:nil="true"/>
						<c:DisplayName i:nil="true"/>
						<c:Font i:nil="true"/>
						<c:Padding i:nil="true"/>
						<c:RefId>00000000-0000-0000-0000-000000000000</c:RefId>
						<c:TextAlign>Left</c:TextAlign>
						<c:ZebraBackgroundColor i:nil="true"/>
					</b:HeaderStyle>
					<b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed>
					<b:IsHidden>true</b:IsHidden>
					<b:PercentWidth i:nil="true"/>
					<b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/>
					<b:PropertyName>ObservationTimestamp</b:PropertyName>
					<b:RefId>b29b97a7-9a18-9d9c-932e-7cc4e59908f2</b:RefId>
					<b:Summary>
						<b:Calculation>NotSpecified</b:Calculation>
						<b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/>
					</b:Summary>
					<b:TransformId/>
					<b:ValidRange>NotSpecified</b:ValidRange>
				</b:TableColumn>
			</b:Columns>
			<b:DefaultStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/>
			<b:Filter xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection">
				<c:Expression i:nil="true"/>
				<c:Limit>
					<c:Count i:nil="true"/>
					<c:Mode>ShowAll</c:Mode>
					<c:OrionServerIDsToIgnore i:nil="true"/>
					<c:Percentage i:nil="true"/>
				</c:Limit>
			</b:Filter>
			<b:Indents>
				<b:TableIndentEntry>
					<b:ColumnId>a84afba0-69d8-9555-9039-35a0c9eeeaac</b:ColumnId>
					<b:HeaderStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/>
					<b:IncludeSummaryRow>false</b:IncludeSummaryRow>
				</b:TableIndentEntry>
				<b:TableIndentEntry>
					<b:ColumnId>c07c215d-0ba5-08b0-7da1-483fee14fbb5</b:ColumnId>
					<b:HeaderStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/>
					<b:IncludeSummaryRow>false</b:IncludeSummaryRow>
				</b:TableIndentEntry>
			</b:Indents>
			<b:Sorts xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection">
				<c:SortEntry>
					<c:Direction>Ascending</c:Direction>
					<c:QFieldRefID>a84afba0-69d8-9555-9039-35a0c9eeeaac</c:QFieldRefID>
				</c:SortEntry>
				<c:SortEntry>
					<c:Direction>Ascending</c:Direction>
					<c:QFieldRefID>c07c215d-0ba5-08b0-7da1-483fee14fbb5</c:QFieldRefID>
				</c:SortEntry>
			</b:Sorts>
			<b:SummarizeMode>NoDataSummarization</b:SummarizeMode>
			<b:TimeField xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection">
				<c:DataTypeInfo i:nil="true"/>
				<c:DisplayName i:nil="true"/>
				<c:NavigationPath i:nil="true"/>
				<c:OwnerDisplayName i:nil="true"/>
				<c:RefID>
					<c:Data>Orion.ResponseTime|ObservationTimestamp</c:Data>
				</c:RefID>
			</b:TimeField>
		</a:ConfigurationData>
		<a:ConfigurationData i:type="b:TableConfiguration" xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Tables">
			<a:DisplaySubTitle/>
			<a:DisplayTitle>Team Breakdown</a:DisplayTitle>
			<a:RefId>6cf71743-8f8b-4ef7-aed5-49dcdd3e2f83</a:RefId>
			<b:Columns>
				<b:TableColumn>
					<b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles">
						<c:BackgroundColor i:nil="true"/>
						<c:Borders i:nil="true"/>
						<c:DisplayName i:nil="true"/>
						<c:Font i:nil="true"/>
						<c:Padding i:nil="true"/>
						<c:RefId>00000000-0000-0000-0000-000000000000</c:RefId>
						<c:TextAlign>Left</c:TextAlign>
						<c:ZebraBackgroundColor i:nil="true"/>
					</b:CellStyle>
					<b:DataColumnName i:nil="true"/>
					<b:DisplayName>Team</b:DisplayName>
					<b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection">
						<c:DataTypeInfo>
							<a:ApplicationType i:nil="true"/>
							<a:DataType>
								<a:Data>System.String</a:Data>
							</a:DataType>
							<a:DeclType>Text</a:DeclType>
							<a:DefaultAggregation>NotSpecified</a:DefaultAggregation>
							<a:DefaultDataUnitId i:nil="true"/>
							<a:DefaultTransformId i:nil="true"/>
							<a:Description i:nil="true"/>
							<a:IsFavorite i:nil="true"/>
							<a:IsFilterBy i:nil="true"/>
							<a:IsGroupBy i:nil="true"/>
							<a:IsInherited i:nil="true"/>
							<a:IsManaged i:nil="true"/>
							<a:IsStatistic i:nil="true"/>
							<a:PreviewValue i:nil="true"/>
							<a:Units i:nil="true"/>
							<a:UtcTimeIsInLocalTime i:nil="true"/>
						</c:DataTypeInfo>
						<c:DisplayName>Team</c:DisplayName>
						<c:NavigationPath i:nil="true"/>
						<c:OwnerDisplayName i:nil="true"/>
						<c:RefID>
							<c:Data>db|Team|computed</c:Data>
						</c:RefID>
					</b:Field>
					<b:FixedWidth i:nil="true"/>
					<b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles">
						<c:BackgroundColor i:nil="true"/>
						<c:Borders i:nil="true"/>
						<c:DisplayName i:nil="true"/>
						<c:Font i:nil="true"/>
						<c:Padding i:nil="true"/>
						<c:RefId>00000000-0000-0000-0000-000000000000</c:RefId>
						<c:TextAlign>Left</c:TextAlign>
						<c:ZebraBackgroundColor i:nil="true"/>
					</b:HeaderStyle>
					<b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed>
					<b:IsHidden>false</b:IsHidden>
					<b:PercentWidth i:nil="true"/>
					<b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/>
					<b:PropertyName>Team</b:PropertyName>
					<b:RefId>b9f9e290-dbfd-833a-0a7b-fa560fcf12e3</b:RefId>
					<b:Summary>
						<b:Calculation>NotSpecified</b:Calculation>
						<b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/>
					</b:Summary>
					<b:TransformId/>
					<b:ValidRange>NotSpecified</b:ValidRange>
				</b:TableColumn>
				<b:TableColumn>
					<b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles">
						<c:BackgroundColor i:nil="true"/>
						<c:Borders i:nil="true"/>
						<c:DisplayName i:nil="true"/>
						<c:Font i:nil="true"/>
						<c:Padding i:nil="true"/>
						<c:RefId>00000000-0000-0000-0000-000000000000</c:RefId>
						<c:TextAlign>Right</c:TextAlign>
						<c:ZebraBackgroundColor i:nil="true"/>
					</b:CellStyle>
					<b:DataColumnName i:nil="true"/>
					<b:DisplayName>Availability</b:DisplayName>
					<b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection">
						<c:DataTypeInfo>
							<a:ApplicationType>Core.Percent</a:ApplicationType>
							<a:DataType>
								<a:Data>System.Double</a:Data>
							</a:DataType>
							<a:DeclType>Float</a:DeclType>
							<a:DefaultAggregation>Average</a:DefaultAggregation>
							<a:DefaultDataUnitId i:nil="true"/>
							<a:DefaultTransformId i:nil="true"/>
							<a:Description/>
							<a:IsFavorite>false</a:IsFavorite>
							<a:IsFilterBy>false</a:IsFilterBy>
							<a:IsGroupBy>false</a:IsGroupBy>
							<a:IsInherited>false</a:IsInherited>
							<a:IsManaged>false</a:IsManaged>
							<a:IsStatistic>true</a:IsStatistic>
							<a:PreviewValue>100</a:PreviewValue>
							<a:Units/>
							<a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime>
						</c:DataTypeInfo>
						<c:DisplayName>Availability</c:DisplayName>
						<c:NavigationPath i:nil="true"/>
						<c:OwnerDisplayName i:nil="true"/>
						<c:RefID>
							<c:Data>Orion.ResponseTime|Availability</c:Data>
						</c:RefID>
					</b:Field>
					<b:FixedWidth i:nil="true"/>
					<b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles">
						<c:BackgroundColor i:nil="true"/>
						<c:Borders i:nil="true"/>
						<c:DisplayName i:nil="true"/>
						<c:Font i:nil="true"/>
						<c:Padding i:nil="true"/>
						<c:RefId>00000000-0000-0000-0000-000000000000</c:RefId>
						<c:TextAlign>Right</c:TextAlign>
						<c:ZebraBackgroundColor i:nil="true"/>
					</b:HeaderStyle>
					<b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed>
					<b:IsHidden>false</b:IsHidden>
					<b:PercentWidth i:nil="true"/>
					<b:Presenters xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation">
						<c:PresenterRef>
							<c:PresenterId>orion.core.text.numericformat</c:PresenterId>
							<c:Values>
								<a:ContextValue>
									<a:Name>NumericFormat</a:Name>
									<a:Value>{0:0.00} %</a:Value>
								</a:ContextValue>
							</c:Values>
						</c:PresenterRef>
					</b:Presenters>
					<b:PropertyName>Availability</b:PropertyName>
					<b:RefId>3f248340-0176-9d52-fe30-0750c402201c</b:RefId>
					<b:Summary>
						<b:Calculation>Average</b:Calculation>
						<b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/>
					</b:Summary>
					<b:TransformId/>
					<b:ValidRange>NotSpecified</b:ValidRange>
				</b:TableColumn>
				<b:TableColumn>
					<b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles">
						<c:BackgroundColor i:nil="true"/>
						<c:Borders i:nil="true"/>
						<c:DisplayName i:nil="true"/>
						<c:Font i:nil="true"/>
						<c:Padding i:nil="true"/>
						<c:RefId>00000000-0000-0000-0000-000000000000</c:RefId>
						<c:TextAlign>Left</c:TextAlign>
						<c:ZebraBackgroundColor i:nil="true"/>
					</b:CellStyle>
					<b:DataColumnName i:nil="true"/>
					<b:DisplayName>ObservationTimestamp</b:DisplayName>
					<b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection">
						<c:DataTypeInfo>
							<a:ApplicationType i:nil="true"/>
							<a:DataType>
								<a:Data>System.DateTime</a:Data>
							</a:DataType>
							<a:DeclType>DateTime</a:DeclType>
							<a:DefaultAggregation>NotSpecified</a:DefaultAggregation>
							<a:DefaultDataUnitId i:nil="true"/>
							<a:DefaultTransformId i:nil="true"/>
							<a:Description/>
							<a:IsFavorite>false</a:IsFavorite>
							<a:IsFilterBy>false</a:IsFilterBy>
							<a:IsGroupBy>false</a:IsGroupBy>
							<a:IsInherited>true</a:IsInherited>
							<a:IsManaged>false</a:IsManaged>
							<a:IsStatistic>true</a:IsStatistic>
							<a:PreviewValue>8/1/2022 1:03:59 PM</a:PreviewValue>
							<a:Units/>
							<a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime>
						</c:DataTypeInfo>
						<c:DisplayName>ObservationTimestamp</c:DisplayName>
						<c:NavigationPath i:nil="true"/>
						<c:OwnerDisplayName i:nil="true"/>
						<c:RefID>
							<c:Data>Orion.ResponseTime|ObservationTimestamp</c:Data>
						</c:RefID>
					</b:Field>
					<b:FixedWidth i:nil="true"/>
					<b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles">
						<c:BackgroundColor i:nil="true"/>
						<c:Borders i:nil="true"/>
						<c:DisplayName i:nil="true"/>
						<c:Font i:nil="true"/>
						<c:Padding i:nil="true"/>
						<c:RefId>00000000-0000-0000-0000-000000000000</c:RefId>
						<c:TextAlign>Left</c:TextAlign>
						<c:ZebraBackgroundColor i:nil="true"/>
					</b:HeaderStyle>
					<b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed>
					<b:IsHidden>true</b:IsHidden>
					<b:PercentWidth i:nil="true"/>
					<b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/>
					<b:PropertyName>ObservationTimestamp</b:PropertyName>
					<b:RefId>776bbcaa-348c-0add-60f2-159c7c20b45b</b:RefId>
					<b:Summary>
						<b:Calculation>NotSpecified</b:Calculation>
						<b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/>
					</b:Summary>
					<b:TransformId/>
					<b:ValidRange>NotSpecified</b:ValidRange>
				</b:TableColumn>
			</b:Columns>
			<b:DefaultStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/>
			<b:Filter xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection">
				<c:Expression i:nil="true"/>
				<c:Limit>
					<c:Count i:nil="true"/>
					<c:Mode>ShowAll</c:Mode>
					<c:OrionServerIDsToIgnore i:nil="true"/>
					<c:Percentage i:nil="true"/>
				</c:Limit>
			</b:Filter>
			<b:Indents>
				<b:TableIndentEntry>
					<b:ColumnId>b9f9e290-dbfd-833a-0a7b-fa560fcf12e3</b:ColumnId>
					<b:HeaderStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/>
					<b:IncludeSummaryRow>false</b:IncludeSummaryRow>
				</b:TableIndentEntry>
			</b:Indents>
			<b:Sorts xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"/>
			<b:SummarizeMode>NoDataSummarization</b:SummarizeMode>
			<b:TimeField xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection">
				<c:DataTypeInfo i:nil="true"/>
				<c:DisplayName i:nil="true"/>
				<c:NavigationPath i:nil="true"/>
				<c:OwnerDisplayName i:nil="true"/>
				<c:RefID>
					<c:Data>Orion.ResponseTime|ObservationTimestamp</c:Data>
				</c:RefID>
			</b:TimeField>
		</a:ConfigurationData>
	</Configs>
	<DataSources xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection">
		<a:DataSource>
			<a:CommandText>SELECT [Nodes].Caption
     , IsNull([Nodes].CustomProperties.AvailabilityReportingGroup, '[No Team]') AS [AvailabilityReportingGroup]
     , [Nodes].ResponseTimeHistory.Availability
     , [Nodes].ResponseTimeHistory.ObservationTimestamp
FROM Orion.Nodes AS [Nodes]
WHERE [Nodes].ResponseTimeHistory.ObservationTimestamp &gt;= ${FromTimeUTC}
  AND [Nodes].ResponseTimeHistory.ObservationTimestamp &lt; ${ToTimeUTC}</a:CommandText>
			<a:DynamicSelectionType>Undefined</a:DynamicSelectionType>
			<a:EntityUri xmlns:b="http://schemas.microsoft.com/2003/10/Serialization/Arrays"/>
			<a:Filter i:nil="true"/>
			<a:MasterEntity>Orion.Nodes</a:MasterEntity>
			<a:Name>Node Breakdown</a:Name>
			<a:NetObjectId/>
			<a:RefId>96b7ba05-c015-41e3-989d-fa4dae1e9d8d</a:RefId>
			<a:Type>CustomSWQL</a:Type>
		</a:DataSource>
		<a:DataSource>
			<a:CommandText>SELECT IsNull([RT].Node.CustomProperties.AvailabilityReportingGroup, '[No Team]') AS [Team]
     , [RT].Availability
     , [RT].ObservationTimestamp
FROM Orion.ResponseTime AS [RT]
WHERE [RT].ObservationTimestamp &gt;= ${FromTimeUTC}
  AND [RT].ObservationTimestamp &lt; ${ToTimeUTC}</a:CommandText>
			<a:DynamicSelectionType>Undefined</a:DynamicSelectionType>
			<a:EntityUri xmlns:b="http://schemas.microsoft.com/2003/10/Serialization/Arrays"/>
			<a:Filter i:nil="true"/>
			<a:MasterEntity>Orion.Nodes</a:MasterEntity>
			<a:Name>Team Breakdown</a:Name>
			<a:NetObjectId/>
			<a:RefId>6fcc4acd-1271-4c0a-b79b-c0eea416cecb</a:RefId>
			<a:Type>CustomSWQL</a:Type>
		</a:DataSource>
	</DataSources>
	<Description>For last 30 Days</Description>
	<Footer xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Layout">
		<a:CustomText>© SolarWinds Worldwide, LLC. All Rights Reserved.</a:CustomText>
		<a:ShowCustomText>true</a:ShowCustomText>
		<a:ShowPageNumber>true</a:ShowPageNumber>
		<a:ShowTimestamp>true</a:ShowTimestamp>
		<a:Visible>true</a:Visible>
	</Footer>
	<Header xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Layout">
		<a:Logo>standard</a:Logo>
		<a:SubTitle>For last 30 Days</a:SubTitle>
		<a:Title>Possibly Better KT Report</a:Title>
		<a:Visible>true</a:Visible>
	</Header>
	<LicenseFeatureName i:nil="true"/>
	<LimitationCategory>Default Folder</LimitationCategory>
	<ModuleTitle i:nil="true"/>
	<Name>Possibly Better KT Report</Name>
	<OrionFeatureName i:nil="true"/>
	<PageLayout xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Layout">
		<a:Height>0</a:Height>
		<a:Orientation i:nil="true"/>
		<a:PublishingType>web</a:PublishingType>
		<a:Size i:nil="true"/>
		<a:Units i:nil="true"/>
		<a:Width>1800</a:Width>
	</PageLayout>
	<ReportGuid>71f8c35c-2865-46c1-9a86-f0a117b8a986</ReportGuid>
	<Sections xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Layout">
		<a:Section>
			<a:BorderStyle xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles">
				<b:Bottom i:nil="true"/>
				<b:Color i:nil="true"/>
				<b:Left i:nil="true"/>
				<b:Right i:nil="true"/>
				<b:Top i:nil="true"/>
			</a:BorderStyle>
			<a:Columns>
				<a:SectionColumn>
					<a:BorderStyle xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles">
						<b:Bottom i:nil="true"/>
						<b:Color i:nil="true"/>
						<b:Left i:nil="true"/>
						<b:Right i:nil="true"/>
						<b:Top i:nil="true"/>
					</a:BorderStyle>
					<a:Cells>
						<a:SectionCell>
							<a:Config i:nil="true" xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Data"/>
							<a:ConfigId>6cf71743-8f8b-4ef7-aed5-49dcdd3e2f83</a:ConfigId>
							<a:DataSelectionRefId>6fcc4acd-1271-4c0a-b79b-c0eea416cecb</a:DataSelectionRefId>
							<a:DisplayName>Custom Table</a:DisplayName>
							<a:RefId>b6a94c4c-14fd-455c-acef-36749192d4cb</a:RefId>
							<a:RenderProvider>SolarWinds.Reporting,Table</a:RenderProvider>
							<a:TimeframeRefId>3cf9b5f9-194f-444e-aa4b-328e7710dad9</a:TimeframeRefId>
						</a:SectionCell>
						<a:SectionCell>
							<a:Config i:nil="true" xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Data"/>
							<a:ConfigId>fc29976b-d89a-4a93-b5f5-e85d3b92d3c1</a:ConfigId>
							<a:DataSelectionRefId>96b7ba05-c015-41e3-989d-fa4dae1e9d8d</a:DataSelectionRefId>
							<a:DisplayName>Custom Table</a:DisplayName>
							<a:RefId>d1689236-9bc6-4b9f-884c-287a96add0b6</a:RefId>
							<a:RenderProvider>SolarWinds.Reporting,Table</a:RenderProvider>
							<a:TimeframeRefId>d99cc7cf-a0e9-4cb0-8d78-6428982c5a42</a:TimeframeRefId>
						</a:SectionCell>
					</a:Cells>
					<a:ColumnGutter i:nil="true"/>
					<a:PercentWidth>100</a:PercentWidth>
					<a:PixelWidth i:nil="true"/>
					<a:RefId>69b1e95a-7e98-4383-8b24-def69aa0d6aa</a:RefId>
					<a:Subtitle/>
					<a:Title/>
				</a:SectionColumn>
			</a:Columns>
			<a:RefId>0f21cc60-f3c8-4e6e-8cf9-65bcb32eb622</a:RefId>
		</a:Section>
	</Sections>
	<TimeFrames xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Timing">
		<a:TimeFrame>
			<a:DisplayName>Past Hour</a:DisplayName>
			<a:IsStatic>false</a:IsStatic>
			<a:RefId>6ab288db-7e77-46fd-b50b-8e81f7c46bc0</a:RefId>
			<a:Relative>
				<a:NamedTimeFrame>PastHour</a:NamedTimeFrame>
				<a:Unit>Hour</a:Unit>
				<a:UnitCount>1</a:UnitCount>
			</a:Relative>
			<a:Static i:nil="true"/>
		</a:TimeFrame>
		<a:TimeFrame>
			<a:DisplayName>Last 30 Days</a:DisplayName>
			<a:IsStatic>false</a:IsStatic>
			<a:RefId>d99cc7cf-a0e9-4cb0-8d78-6428982c5a42</a:RefId>
			<a:Relative>
				<a:NamedTimeFrame>Last30Days</a:NamedTimeFrame>
				<a:Unit>Day</a:Unit>
				<a:UnitCount>31</a:UnitCount>
			</a:Relative>
			<a:Static i:nil="true"/>
		</a:TimeFrame>
		<a:TimeFrame>
			<a:DisplayName>Past Hour</a:DisplayName>
			<a:IsStatic>false</a:IsStatic>
			<a:RefId>1170858a-db62-484a-8fb8-f7d441b5739b</a:RefId>
			<a:Relative>
				<a:NamedTimeFrame>PastHour</a:NamedTimeFrame>
				<a:Unit>Hour</a:Unit>
				<a:UnitCount>1</a:UnitCount>
			</a:Relative>
			<a:Static i:nil="true"/>
		</a:TimeFrame>
		<a:TimeFrame>
			<a:DisplayName>Last 30 Days</a:DisplayName>
			<a:IsStatic>false</a:IsStatic>
			<a:RefId>10a65c89-f0a1-4d65-80a1-0543f41b4258</a:RefId>
			<a:Relative>
				<a:NamedTimeFrame>Last30Days</a:NamedTimeFrame>
				<a:Unit>Day</a:Unit>
				<a:UnitCount>31</a:UnitCount>
			</a:Relative>
			<a:Static i:nil="true"/>
		</a:TimeFrame>
		<a:TimeFrame>
			<a:DisplayName>Past Hour</a:DisplayName>
			<a:IsStatic>false</a:IsStatic>
			<a:RefId>31acf32c-69e3-45e9-99ba-0da636012a50</a:RefId>
			<a:Relative>
				<a:NamedTimeFrame>PastHour</a:NamedTimeFrame>
				<a:Unit>Hour</a:Unit>
				<a:UnitCount>1</a:UnitCount>
			</a:Relative>
			<a:Static i:nil="true"/>
		</a:TimeFrame>
		<a:TimeFrame>
			<a:DisplayName>Past Hour</a:DisplayName>
			<a:IsStatic>false</a:IsStatic>
			<a:RefId>ee6f406a-c884-4d6c-8b35-5c7bdd538a51</a:RefId>
			<a:Relative>
				<a:NamedTimeFrame>PastHour</a:NamedTimeFrame>
				<a:Unit>Hour</a:Unit>
				<a:UnitCount>1</a:UnitCount>
			</a:Relative>
			<a:Static i:nil="true"/>
		</a:TimeFrame>
		<a:TimeFrame>
			<a:DisplayName>Last 30 Days</a:DisplayName>
			<a:IsStatic>false</a:IsStatic>
			<a:RefId>3cf9b5f9-194f-444e-aa4b-328e7710dad9</a:RefId>
			<a:Relative>
				<a:NamedTimeFrame>Last30Days</a:NamedTimeFrame>
				<a:Unit>Day</a:Unit>
				<a:UnitCount>31</a:UnitCount>
			</a:Relative>
			<a:Static i:nil="true"/>
		</a:TimeFrame>
	</TimeFrames>
</Report>
    I think I got what you want working using the native web reporting engine.  Because our Custom Property Names don't 100% match

    • Download the XML file
    • do a global find/replace on the text for "AvailabilityReportingGroup' (my CP) and replace it with "AvailabilityReportingGroups" (your CP)
    • Then import it
  • 0 in reply to KMSigma.SWI

    It appears to be working.  I am double checking the groups in excel and averages look right as well.  I see you added the [NO TEAM] which is great for me to fix them.  Also the $fromTime looks like its now ${FromTimeUTC}

    I think you may have solved it. Ill test a few more reports and let you know shortly.  

  • 0 in reply to KMSigma.SWI

    I have one issue with the [NO TEAM] entry.  On my averages query at the top it is coming back with a result.  

    The bottom query is coming back with nothing.  I also went through and verified that ALL my nodes have this field assigned right now.  

    Any ideas what would be causing that?

  • 0 in reply to bgetz

    Then you have some node, somewhere that doesn't have an entry in this field.  Maybe an ICMP (Ping-only) node or something?

Reply Children
  • 0 in reply to KMSigma.SWI

    I definitely have some ICMP ping only nodes that were in the network devices group. tried pulling them out into another group just for fun and it seems to properly separate them (show in top and bottom queries).  

    I tried using my new found SWQL experience to figure out the node it was reporting so I ran this in SWQL studio:

    SELECT IsNull([RT].Node.CustomProperties.AvailabilityReportingGroups, '[No Team]') AS [Team]
     , [RT].Availability
     , [RT].ObservationTimestamp
     , [RT].Node.Caption
FROM Orion.ResponseTime AS [RT]
WHERE [RT].DateTime>ADDDAY(-31, GETDATE())

    The [No Team] fields actually come back with no caption!

    Also if I change my addday to the last 7 days it does not have any [No Teams] so maybe its just some old historical entries for whatever reason.

    I am going to continue to ignore this for now as its the best I have and see if next months looks good!

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification SolarWinds Lab Link Accounts
About THWACK Blogs Federal & Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2021 SolarWinds Worldwide, LLC. All Rights Reserved.