New England Security User Group

 View Only
  • 1.  Computers with Deployment Tasks Execution Status Report Issue (SMP 7.5)

    Posted Jun 05, 2015 01:11 PM

    When I run "Computers with Deployment Tasks Execution Status" report it only captures the last 10 days worth of data. I adjusted the 'Timeframe' filter to all options but still same issue. It is neccessary to be able to capture all data for monthly reporting.



  • 2.  RE: Computers with Deployment Tasks Execution Status Report Issue (SMP 7.5)

    Posted Jun 26, 2015 09:30 AM

    How is the event purging setup for that table? 



  • 3.  RE: Computers with Deployment Tasks Execution Status Report Issue (SMP 7.5)
    Best Answer

    Posted Jun 26, 2015 11:03 AM

    Hi SK,

    The issue was tied to the Cleanup Task Data schedule.  We had it set to keep a maximum of 500,000 rows in the database.  Due to a large number of running tasks from several enabled policies, it was truncating the data after a short period of time because we were hitting that maximum.  We updated to 1,000,000 and have now gotten more than 10 days' worth of data.  We've also disabled some long-running policies to better control the number of running tasks.  So things look better now, thanks.



  • 4.  RE: Computers with Deployment Tasks Execution Status Report Issue (SMP 7.5)
    Best Answer

    Posted Jun 26, 2015 11:11 AM

    Thank you etk1131 for your assistance with this!