https://community.hpe.com/t5/server-management-systems/hpmxautomationtaskresults-exceeds-350-000/m-p/4269616#M34540 I have seen other threads about mxjobs etc. but nothing in regards to this specific table in the database. I find that what I try to look at Scheduled Tasks in HP SIM it takes a couple minutes before it comes up. Is there a way I can limit the number of Task Results and purge all the rest from the HP SIM Database?<BR /><BR />Any information or help would be great. Here is a capture from hpconfigrepo command.<BR /><BR />Performing repository corruption checking.<BR />15 Sep 2008 09:10:36,120 INFO [HPSIM_DEBUG]<BR /> Database Version:<BR />15 Sep 2008 09:10:36,120 INFO [HPSIM_DEBUG]<BR /> Microsoft SQL Server 2005 - 9.00.3200.00 (Intel X86)<BR /> Oct 2 2007 11:33:27<BR /> Copyright (c) 1988-2005 Microsoft Corporation<BR /> Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)<BR /><BR />15 Sep 2008 09:10:36,120 INFO [HPSIM_DEBUG]<BR /> Database Driver:<BR /> jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 1.2.2<BR /><BR />15 Sep 2008 09:10:36,182 INFO [HPSIM_DEBUG] Checking for possible database corruption...<BR />15 Sep 2008 09:10:36,213 INFO [HPSIM_DEBUG] Number of records in table 'devices': 1418<BR />15 Sep 2008 09:10:36,213 INFO [HPSIM_DEBUG] Number of records in table 'notices': 42836<BR />15 Sep 2008 09:10:36,213 INFO [HPSIM_DEBUG] Number of records in table 'tasks': 35<BR />15 Sep 2008 09:10:36,229 INFO [HPSIM_DEBUG] Number of records in table 'hpmxJob': 2438<BR />15 Sep 2008 09:10:36,323 INFO [HPSIM_DEBUG] Number of records in table 'hpmxAutomationTaskResults': 370051<BR />15 Sep 2008 09:10:36,323 INFO [HPSIM_DEBUG] Number of records in table 'hpmxQuery': 105<BR />15 Sep 2008 09:10:36,323 INFO [HPSIM_DEBUG] Number of records in table 'collections': 112<BR />15 Sep 2008 09:10:36,323 INFO [HPSIM_DEBUG] Number of records in table 'hpmxUser': 21<BR />15 Sep 2008 09:10:36,323 INFO [HPSIM_DEBUG] Number of records in table 'hpmxAuthorization': 98<BR />15 Sep 2008 09:10:36,338 INFO [HPSIM_DEBUG] Number of records in table 'consolidatedNodeAuths': 32164<BR />15 Sep 2008 09:10:37,604 INFO [HPSIM_DEBUG] Completed database checking with no errors.<BR />Completed repository corruption checking. Mon, 15 Sep 2008 15:36:50 GMT Todd Schelin 2008-09-15T15:36:50Z https://community.hpe.com/t5/server-management-systems/hpmxautomationtaskresults-exceeds-350-000/m-p/4269616#M34540 I have seen other threads about mxjobs etc. but nothing in regards to this specific table in the database. I find that what I try to look at Scheduled Tasks in HP SIM it takes a couple minutes before it comes up. Is there a way I can limit the number of Task Results and purge all the rest from the HP SIM Database?<BR /><BR />Any information or help would be great. Here is a capture from hpconfigrepo command.<BR /><BR />Performing repository corruption checking.<BR />15 Sep 2008 09:10:36,120 INFO [HPSIM_DEBUG]<BR /> Database Version:<BR />15 Sep 2008 09:10:36,120 INFO [HPSIM_DEBUG]<BR /> Microsoft SQL Server 2005 - 9.00.3200.00 (Intel X86)<BR /> Oct 2 2007 11:33:27<BR /> Copyright (c) 1988-2005 Microsoft Corporation<BR /> Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)<BR /><BR />15 Sep 2008 09:10:36,120 INFO [HPSIM_DEBUG]<BR /> Database Driver:<BR /> jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 1.2.2<BR /><BR />15 Sep 2008 09:10:36,182 INFO [HPSIM_DEBUG] Checking for possible database corruption...<BR />15 Sep 2008 09:10:36,213 INFO [HPSIM_DEBUG] Number of records in table 'devices': 1418<BR />15 Sep 2008 09:10:36,213 INFO [HPSIM_DEBUG] Number of records in table 'notices': 42836<BR />15 Sep 2008 09:10:36,213 INFO [HPSIM_DEBUG] Number of records in table 'tasks': 35<BR />15 Sep 2008 09:10:36,229 INFO [HPSIM_DEBUG] Number of records in table 'hpmxJob': 2438<BR />15 Sep 2008 09:10:36,323 INFO [HPSIM_DEBUG] Number of records in table 'hpmxAutomationTaskResults': 370051<BR />15 Sep 2008 09:10:36,323 INFO [HPSIM_DEBUG] Number of records in table 'hpmxQuery': 105<BR />15 Sep 2008 09:10:36,323 INFO [HPSIM_DEBUG] Number of records in table 'collections': 112<BR />15 Sep 2008 09:10:36,323 INFO [HPSIM_DEBUG] Number of records in table 'hpmxUser': 21<BR />15 Sep 2008 09:10:36,323 INFO [HPSIM_DEBUG] Number of records in table 'hpmxAuthorization': 98<BR />15 Sep 2008 09:10:36,338 INFO [HPSIM_DEBUG] Number of records in table 'consolidatedNodeAuths': 32164<BR />15 Sep 2008 09:10:37,604 INFO [HPSIM_DEBUG] Completed database checking with no errors.<BR />Completed repository corruption checking. Mon, 15 Sep 2008 15:36:50 GMT https://community.hpe.com/t5/server-management-systems/hpmxautomationtaskresults-exceeds-350-000/m-p/4269616#M34540 Todd Schelin 2008-09-15T15:36:50Z