Hi,
I have been told to create a report that shows availability of our storage arrays for the last 7 days. The person who created the previous report did it by creating a dynamic query builder that ended up bringing duplicates and this is the strange part.
By looking at the query that runs behind the report I can see this:
SELECT TOP 15 [data].[Name] AS [Name],[data].[Manufacturer] AS [Manufacturer],[data].[Model] AS [Model],[data].[HardwareHealthInfos].[HardwareCategoryStatuses].[HardwareItems].[HardwareItemStatistics].[Availability] AS [Availability],[data].[InstanceSiteId] AS [InstanceSiteId]
FROM orion.srm.storagearrays AS data
WHERE
(((([data].[Manufacturer]) = p0))) AND ((([data].[HardwareHealthInfos].[HardwareCategoryStatuses].[HardwareItems].[HardwareItemStatistics].[ObservationTimestamp]) >= p1)) AND (([data].[HardwareHealthInfos].[HardwareCategoryStatuses].[HardwareItems].[HardwareItemStatistics].[ObservationTimestamp]) < p2))))
GROUP BY
[data].[Name],[data].[Manufacturer],[data].[Model],[data].[HardwareHealthInfos].[HardwareCategoryStatuses].[HardwareItems].[HardwareItemStatistics].[Availability],[data].[InstanceSiteId]
ORDER BY
[Name] ASC
WITH NOLOCK RETURN XML RAW (p0=DELL, p1=10/4/2022 4:00:00 AM, p2=10/12/2022 4:00:00 AM)
The result as follows:
All the records but one show 0 and 100 % availability and their names are duplicates.
The reason why these records show duplicate is due of this column:
[data].[HardwareHealthInfos].[HardwareCategoryStatuses].[HardwareItems].[HardwareItemStatistics].[Availability] AS [Availability],[data].[InstanceSiteId] AS [InstanceSiteId]
The above column is an option that is available when the dynamic query builder is done, so the Web Interface shows that as part of the report.
What concerns me is how/why the availability can be fetched without creating this behavior that only occurs for DELL nodes.
Do you have any suggestion?
Thank you
