Product(s):
AssetWise APM Foundation
Version(s):
07.11.00.27
Environment:
N\A
Area:
N/A
Subarea:
Problem Description
When checking the riskplot of an analysis of certain site/factory, it has been noticed that there are more assets considered in the riskplot than there are in the analyses. We were able to see assets from other sites that shouldn't be there according to the analysis.
When selecting a certain score, the assets belonging to the score show down below. There you can see assets belonging to other sites.
Steps to Resolve
SELECT c.TotConsScore,a1.Title,a1.icon,p.Probability,a1.AssetNumber,a1.FuncPosition,c.RelativeRisk,c.AnalysisStat,p.FailureRate_fl,c.CriticalityA_oi,c.Asset_oi,c.AssetCritica_oi,c.ProbabilityO_oi,c.ACAAnalysisAssetoi,c1.Site_oi
FROM MNT.CriticaltyAnalysis c1,(((MNT.CriticalityAsset c
LEFT OUTER JOIN MNT.PFFailure p ON c.ProbabilityO_oi=p.ACAProbabilityOfFailureoi)
LEFT OUTER JOIN MNT.AssetCriticality a ON c.AssetCritica_oi=a.AssetCriticalityoi)
LEFT OUTER JOIN MNT.Asset a1 ON c.Asset_oi=a1.Assetoi)
WHERE (c.CriticalityA_oi=c1.ACAAnalysisoi) AND (((c.ACAAnalysisAssetoi IN (27251,27252,27253,27254,27255,27256,27257,27258,27259,27260,27261,27262,27263,27264,27265,27266,27267,27268,27269,27270,27271,27272,27273,27274,27275,27276,27277,27278,27279,27280,27281,27282,27283) AND p.ACAProbabilityOfFailureoi IN (7) AND a.AssetCriticalityoi IN (14)) AND ((c1.ACAAnalysisoi=26193))))
ORDER BY a1.AssetNumber ASC/* SliceContext MCLBConfigurationOI=1040013934 */