Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

hpmxAutomationTaskResults exceeds 350,000.

Todd Schelin
Valued Contributor

hpmxAutomationTaskResults exceeds 350,000.

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?

Any information or help would be great. Here is a capture from hpconfigrepo command.

Performing repository corruption checking.
15 Sep 2008 09:10:36,120 INFO [HPSIM_DEBUG]
Database Version:
15 Sep 2008 09:10:36,120 INFO [HPSIM_DEBUG]
Microsoft SQL Server 2005 - 9.00.3200.00 (Intel X86)
Oct 2 2007 11:33:27
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

15 Sep 2008 09:10:36,120 INFO [HPSIM_DEBUG]
Database Driver:
jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 1.2.2

15 Sep 2008 09:10:36,182 INFO [HPSIM_DEBUG] Checking for possible database corruption...
15 Sep 2008 09:10:36,213 INFO [HPSIM_DEBUG] Number of records in table 'devices': 1418
15 Sep 2008 09:10:36,213 INFO [HPSIM_DEBUG] Number of records in table 'notices': 42836
15 Sep 2008 09:10:36,213 INFO [HPSIM_DEBUG] Number of records in table 'tasks': 35
15 Sep 2008 09:10:36,229 INFO [HPSIM_DEBUG] Number of records in table 'hpmxJob': 2438
15 Sep 2008 09:10:36,323 INFO [HPSIM_DEBUG] Number of records in table 'hpmxAutomationTaskResults': 370051
15 Sep 2008 09:10:36,323 INFO [HPSIM_DEBUG] Number of records in table 'hpmxQuery': 105
15 Sep 2008 09:10:36,323 INFO [HPSIM_DEBUG] Number of records in table 'collections': 112
15 Sep 2008 09:10:36,323 INFO [HPSIM_DEBUG] Number of records in table 'hpmxUser': 21
15 Sep 2008 09:10:36,323 INFO [HPSIM_DEBUG] Number of records in table 'hpmxAuthorization': 98
15 Sep 2008 09:10:36,338 INFO [HPSIM_DEBUG] Number of records in table 'consolidatedNodeAuths': 32164
15 Sep 2008 09:10:37,604 INFO [HPSIM_DEBUG] Completed database checking with no errors.
Completed repository corruption checking.