topic Re: How to trim Historical data? in Server Management - Systems Insight Manager

How to trim Historical data?

murthy_3 — Mon, 12 Jul 2004 20:35:59 GMT

Hi,

One of our customer has exceeded the 2GB limit for MSDE database under Insight manager 7. They do not wish to purchase SQL as their environment is quite small. Is there a way to trim the database of historical data to keep the DB below the 2GB limit either in CIM 7 or SIM?

Thanks.
Dakshin

Re: How to trim Historical data?

Rob Buxton — Mon, 12 Jul 2004 22:30:21 GMT

Not by size that I'm aware of, but in IM 7 you can set a limit to how many days data you wish to retain.

I no longer have IM 7 up and running, so I can't provide the exact details as to where the setting was.

I'm still looking in HPSIM.

Re: How to trim Historical data?

Mike Kanakos_1 — Tue, 13 Jul 2004 17:06:26 GMT

There is one way that I know of; although it is not fully automated. I am still trying to fully automate this process..

Any help from other forum members would be great.

In SIM 4.x
----------------
1 - create a new event list.
2 - Search for events where "event time" "is older than" XX days (XX represents a value you assign).
3 - Save list (don't forget to assign a list name)

This will create an event list that will show you all EVENTS older than XX days. You can then select all those events and delete from the Database.

You could add more rules to show only certain events over XX Days (such as login events).

Hope that helps.. please feel free to respond with comments/suggestions.

Oh and give out some points if this was helpful!!

Re: How to trim Historical data?

Ed Cox — Tue, 13 Jul 2004 18:48:35 GMT

Rob,
If you find that option to delete historical data in SIM...please let me know. I've searched high and low and have not found it.
Ed

Re: How to trim Historical data?

Rob Buxton — Tue, 13 Jul 2004 19:59:48 GMT

Ed,
You and me both. Trouble is I seem to recall seeing it somewhere, unless that was in 4.0 and it's gone. Or I've just lost the plot...

Re: How to trim Historical data?

Mike Kanakos_1 — Thu, 15 Jul 2004 14:33:40 GMT

This is PT 2 of my first post earlier in the thread...

After you create an event list:

1 - Go to OPTIONS > EVENTS > DELETE EVENTS
2 - Change target to: (the list name you created earlier.) then APPLY
3 - Select SCHEDULE and config as necessary

Re: How to trim Historical data?

murthy_3 — Thu, 15 Jul 2004 19:38:22 GMT

I also ran into another problem, I am not able to find an option to uninstall MSDE. Any ideas Guys?

Re: How to trim Historical data?

Ed Cox — Thu, 15 Jul 2004 20:30:18 GMT

I used to do that under Add\Remove programs. Is it not there anymore?

Re: How to trim Historical data?

murthy_3 — Thu, 15 Jul 2004 20:34:59 GMT

No. I cannot find the option to uninstall through the Add remove programs.

This is the MSDE which got installed as part of the SIM 4.0 installation.

Re: How to trim Historical data?

Ed Cox — Thu, 15 Jul 2004 20:52:50 GMT

That's odd...
I have SIM 4.0 on a Win 2003 server down in Florida and I looked under Add\Remove Programs and it shows up there as Microsoft SQL Desktop Engine.

Re: How to trim Historical data?

William_114 — Mon, 19 Jul 2004 10:40:27 GMT

Murthy, the historical database option that Rob refers to is located under the System tab, the server group on the left, then database.

That's if you still using IM 7.

Re: How to trim Historical data?

murthy_3 — Wed, 21 Jul 2004 23:00:01 GMT

Hi Ed,
I found that the option to uninstall was missing from only this particular server which I was working on.
But the other servers have the option under Add Remove programs.
I reinstalled the SW on this problem server and now I can see the option. Not sure what was the problem.