<o p=""> </o><o p=""> </o>
Hi everyone, please could you help me with this issue?
We are trying to execute the report I mentioned above. Parameters we are using are:
Report: Microsoft Compliance and Vulnerability by Update - Details <o p=""></o>
Folder: <o p=""></o>
|
\Reports\Software Management\Patch Management\Compliance and Vulnerability\<o p=""></o>
|
- Collection: All computers (or any other collection with over 200 machines)
- Release Date From 01/01/2008
- Release Date To: 10/12/2009
- Severity: by default
- Custom Severity: by default
- Distribution Status: by default
- Supersedence Status: by default
- Operating system: by default
NS Version: 6.0.6074
MS SQL Server 2005
MS Windows Server 2003 R2 SP2 Enterprise ED.
When we execute this report, it fails if the collection targeted have more than 200 machines. It takes over 10 minutes to release and finally this error appears:
Sql error in query. Error: System.Data.SqlClient.SqlError: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.Sql CommandText: -- MAX ROWCOUNT SET ROWCOUNT 50000 -- exec spPMWindows_ComplianceByUpdate_Details @SupersedenceStatus = 'non-superseded', @OperatingSystem = '%', @DistributionStatus = 'active', @CollectionGuid = '9c56ee5b-4798-422d-9a4d-b935e98d6230', @VendorSeverity = 'Critical', @CustomSeverity = '%', @StartDate = @param1, @EndDate = @param2, @SWBGuid = '%', @pCulture = 'en-US'
If the collection contains less than 200 computers, it works correctly (although It takes around 10 minutes), but over this quantity (250, 300, 1000 or whatever), it fails.
"All computers" collection have around 4500 machines and we need to take that information (what the report shows) about all of this computers (it could be bothers running the report by step of 200 computers every time and also creating this collections of course)
Do you have any idea of this?
What do you advice me?
Regards
David.<o p=""></o>