SIM 4.1 - Delete Task Results And Schema

[Tom Schafer]

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.

Also, is there a schema published anywhere - the full schema for all tables in the IM DB. i.e. notices....

[Jon Ward]

You could setup a recursive batch file to run

mxtask -lf taskname

which will remove task "taskname" from the hp Systems Insight Manager databaase.

Table information is available on page 216 of http://www.hp.com/wwsolutions/misc/downloads/management/hpsim/sys-book.pdf

[Jon Ward]

Mxtask is documented at http://h18013.www1.hp.com/products/servers/management/hpsim/info-library/mxtask.1m.html

[Tom Schafer]

I don't want to delete a task, i want to delete the results of the tasks.

[Jon Ward]

I apologize for the misunderstanding.

Refer to page 93 if http://docs.hp.com/hpux/pdf/5990-8181.pdf on how to limit the lifetimes of the tasks.