I need to modify this report, I only require show me the status in conflict and erase the other status, the query es the next:
"select distinct
CASE
WHEN CacheResults.DiffFlags = 1 THEN 'conflict'
WHEN CacheResults.DiffFlags = 0 THEN 'noConflict'
ELSE 'unknown'
END as NCMNodeStatus,
Orion.NodeID,
Orion.VendorIcon,
Orion.Caption,
Orion.IPAddress,
CacheResults.DiffFlags,
Orion.DetailsUrl,
Orion.Status,
Orion.ChildStatus,
Orion.Vendor,
Orion.Icon,
OrionVendors.Icon
FROM Cirrus.NodeProperties as NCMNodeProperties
join Orion.Nodes as Orion on Orion.NodeID=NCMNodeProperties.CoreNodeId
join Orion.NodesCustomProperties as OrionCustomProperties on Orion.NodeId= OrionCustomProperties.NodeId
inner join Orion.Vendors AS OrionVendors ON Orion.Vendor=OrionVendors.Name
left join
(
select
DiffFlag as DiffFlags,
NodeID
from Cirrus.LatestComparisonResults
where
ComparisonType=1
) as CacheResults
on NCMNodeProperties.NodeID=CacheResults.NodeID
ORDER BY Orion.Caption ASC"
I try modify this sentences without successfull
Some body have something similar
Let me know your comments
Kind reagards.