Has anyone ever seen when they click on Monitoring / Deployments in SCCM console, it 1st displays applications, and then a minute pause (literally) and then it "refreshes" and shows remaining software updates?
We added about 800 new applications to the console and we started seeing this behavior. I've tracked it thru smsprov and you can see its actually run 3 separate queries when you click on monitoring / deployments. SELECT * FROM SMS_DeploymentSummary WHERE FeatureType IN (1, 2, 3) SELECT * FROM SMS_DeploymentSummary WHERE FeatureType IN (5, 7) SELECT * FROM SMS_DeploymentSummary WHERE FeatureType IN (6, 11) If I run the queries from WMI Explorer it comes back fast. I've also got the same 3 queries that is being converted from WQL to SQL, I run those 3 SQL queries and they also return back fast. select all SMS_DeploymentSummary.AssignmentID,SMS_DeploymentSummary.CI_ID,SMS_Deploymen tSummary.CollectionID,SMS_DeploymentSummary.CollectionName,SMS_DeploymentSum mary.CreationTime,SMS_DeploymentSummary.DeploymentID,SMS_DeploymentSummary.D eploymentIntent,SMS_DeploymentSummary.DeploymentTime,SMS_DeploymentSummary.D esiredConfigType,SMS_DeploymentSummary.EnforcementDeadline,SMS_DeploymentSum mary.FeatureType,SMS_DeploymentSummary.ModelName,SMS_DeploymentSummary.Modif icationTime,SMS_DeploymentSummary.NumberErrors,SMS_DeploymentSummary.NumberI nProgress,SMS_DeploymentSummary.NumberOther,SMS_DeploymentSummary.NumberSucc ess,SMS_DeploymentSummary.NumberTargeted,SMS_DeploymentSummary.NumberUnknown ,SMS_DeploymentSummary.ObjectTypeID,SMS_DeploymentSummary.PackageID,SMS_Depl oymentSummary.PolicyModelID,SMS_DeploymentSummary.ProgramName,SMS_Deployment Summary.SoftwareName,SMS_DeploymentSummary.SummarizationTime,SMS_DeploymentS ummary.SummaryType from fn_DeploymentSummary(1033) AS SMS_DeploymentSummary where SMS_DeploymentSummary.FeatureType in (1,2,3) select all SMS_DeploymentSummary.AssignmentID,SMS_DeploymentSummary.CI_ID,SMS_Deploymen tSummary.CollectionID,SMS_DeploymentSummary.CollectionName,SMS_DeploymentSum mary.CreationTime,SMS_DeploymentSummary.DeploymentID,SMS_DeploymentSummary.D eploymentIntent,SMS_DeploymentSummary.DeploymentTime,SMS_DeploymentSummary.D esiredConfigType,SMS_DeploymentSummary.EnforcementDeadline,SMS_DeploymentSum mary.FeatureType,SMS_DeploymentSummary.ModelName,SMS_DeploymentSummary.Modif icationTime,SMS_DeploymentSummary.NumberErrors,SMS_DeploymentSummary.NumberI nProgress,SMS_DeploymentSummary.NumberOther,SMS_DeploymentSummary.NumberSucc ess,SMS_DeploymentSummary.NumberTargeted,SMS_DeploymentSummary.NumberUnknown ,SMS_DeploymentSummary.ObjectTypeID,SMS_DeploymentSummary.PackageID,SMS_Depl oymentSummary.PolicyModelID,SMS_DeploymentSummary.ProgramName,SMS_Deployment Summary.SoftwareName,SMS_DeploymentSummary.SummarizationTime,SMS_DeploymentS ummary.SummaryType from fn_DeploymentSummary(1033) AS SMS_DeploymentSummary where SMS_DeploymentSummary.FeatureType in (5,7) select all SMS_DeploymentSummary.AssignmentID,SMS_DeploymentSummary.CI_ID,SMS_Deploymen tSummary.CollectionID,SMS_DeploymentSummary.CollectionName,SMS_DeploymentSum mary.CreationTime,SMS_DeploymentSummary.DeploymentID,SMS_DeploymentSummary.D eploymentIntent,SMS_DeploymentSummary.DeploymentTime,SMS_DeploymentSummary.D esiredConfigType,SMS_DeploymentSummary.EnforcementDeadline,SMS_DeploymentSum mary.FeatureType,SMS_DeploymentSummary.ModelName,SMS_DeploymentSummary.Modif icationTime,SMS_DeploymentSummary.NumberErrors,SMS_DeploymentSummary.NumberI nProgress,SMS_DeploymentSummary.NumberOther,SMS_DeploymentSummary.NumberSucc ess,SMS_DeploymentSummary.NumberTargeted,SMS_DeploymentSummary.NumberUnknown ,SMS_DeploymentSummary.ObjectTypeID,SMS_DeploymentSummary.PackageID,SMS_Depl oymentSummary.PolicyModelID,SMS_DeploymentSummary.ProgramName,SMS_Deployment Summary.SoftwareName,SMS_DeploymentSummary.SummarizationTime,SMS_DeploymentS ummary.SummaryType from fn_DeploymentSummary(1033) AS SMS_DeploymentSummary where SMS_DeploymentSummary.FeatureType in (6,11) select count(*) from v_Update_ComplianceStatusAll I'm not sure where/how else to figure this out, its totally bizarre. Thanks Rob
