https://community.hpe.com/t5/server-management-systems/sim-4-1-delete-task-results-and-schema/m-p/3425632#M7563 I apologize for the misunderstanding.<BR /><BR />Refer to page 93 if <A href="http://docs.hp.com/hpux/pdf/5990-8181.pdf" target="_blank">http://docs.hp.com/hpux/pdf/5990-8181.pdf</A> on how to limit the lifetimes of the tasks.<BR /> Mon, 06 Dec 2004 15:56:12 GMT Jon Ward 2004-12-06T15:56:12Z https://community.hpe.com/t5/server-management-systems/sim-4-1-delete-task-results-and-schema/m-p/3425628#M7559 How do you delete the task results in bulk - one at a time is not a viable option. If not possible through the GUI how do you do it in SQL.<BR /><BR />Also, is there a schema published anywhere - the full schema for all tables in the IM DB. i.e. notices.... Thu, 18 Nov 2004 17:13:36 GMT https://community.hpe.com/t5/server-management-systems/sim-4-1-delete-task-results-and-schema/m-p/3425628#M7559 Tom Schafer 2004-11-18T17:13:36Z https://community.hpe.com/t5/server-management-systems/sim-4-1-delete-task-results-and-schema/m-p/3425629#M7560 You could setup a recursive batch file to run<BR /><BR /> mxtask -lf taskname<BR /><BR />which will remove task "taskname" from the hp Systems Insight Manager databaase.<BR /><BR />Table information is available on page 216 of <A href="http://www.hp.com/wwsolutions/misc/downloads/management/hpsim/sys-book.pdf" target="_blank">http://www.hp.com/wwsolutions/misc/downloads/management/hpsim/sys-book.pdf</A><BR /> Sun, 05 Dec 2004 10:49:28 GMT https://community.hpe.com/t5/server-management-systems/sim-4-1-delete-task-results-and-schema/m-p/3425629#M7560 Jon Ward 2004-12-05T10:49:28Z https://community.hpe.com/t5/server-management-systems/sim-4-1-delete-task-results-and-schema/m-p/3425630#M7561 Mxtask is documented at <A href="http://h18013.www1.hp.com/products/servers/management/hpsim/info-library/mxtask.1m.html" target="_blank">http://h18013.www1.hp.com/products/servers/management/hpsim/info-library/mxtask.1m.html</A> Sun, 05 Dec 2004 10:50:30 GMT https://community.hpe.com/t5/server-management-systems/sim-4-1-delete-task-results-and-schema/m-p/3425630#M7561 Jon Ward 2004-12-05T10:50:30Z https://community.hpe.com/t5/server-management-systems/sim-4-1-delete-task-results-and-schema/m-p/3425631#M7562 I don't want to delete a task, i want to delete the results of the tasks. Mon, 06 Dec 2004 10:00:45 GMT https://community.hpe.com/t5/server-management-systems/sim-4-1-delete-task-results-and-schema/m-p/3425631#M7562 Tom Schafer 2004-12-06T10:00:45Z https://community.hpe.com/t5/server-management-systems/sim-4-1-delete-task-results-and-schema/m-p/3425632#M7563 I apologize for the misunderstanding.<BR /><BR />Refer to page 93 if <A href="http://docs.hp.com/hpux/pdf/5990-8181.pdf" target="_blank">http://docs.hp.com/hpux/pdf/5990-8181.pdf</A> on how to limit the lifetimes of the tasks.<BR /> Mon, 06 Dec 2004 15:56:12 GMT https://community.hpe.com/t5/server-management-systems/sim-4-1-delete-task-results-and-schema/m-p/3425632#M7563 Jon Ward 2004-12-06T15:56:12Z