topic Re: Purge data from active View Events DB in Horizon Desktops and Apps

Purge data from active View Events DB

tcu — Thu, 19 Jan 2012 18:07:39 GMT

Somehow (I wish I knew) the date was set wrong when I setup our DR View installation, and due to that incorrect date when I look at my Events in View Manager there are a few items for 4/27/20 x:xx:xx PM!!

I want to purge those out, or even purge the whole Events DB (I would rather not start completely over) but I cannot seem to find a transact statement that will clear those entries out.

I have found plenty to purge out the historical records, but nothing on the active ones.

Thanks,

smooter

Re: Purge data from active View Events DB

gunnarb — Thu, 19 Jan 2012 19:35:33 GMT

Events DB is just a SQL database, I'm not SQL admin but I'm sure a SQL admin could do that for you.

The simple solution, which you allude to, is just purging hte DB. IE, delete the thing and create a new one.

Gunnar

Re: Purge data from active View Events DB

uday_s — Fri, 20 Jan 2012 05:48:37 GMT

http://communities.vmware.com/message/1881999

For your need, remove 'historical' from the table names.

Thanks,

Uday

Re: Purge data from active View Events DB

tcu — Fri, 20 Jan 2012 13:11:28 GMT

So thanks for the replies, I do appreciate both of them!

The reason I didn't want to purge the whole Events db is because I wanted to keep the data that was relevant. As I said in the original post, somehow the dates got messed up, so I had 14 records at the top that were in the future. That makes it difficult to use the Event DB as a diagnostic tool when this random data keeps showing up at the top.

No matter, I am going to go ahead and post what I used from the previous thread (provided by Uday - Thanks again!)

http://communities.vmware.com/message/1881999

NOTE: My DB is named View_Event, and my prefix is vdi

Using the TOP element from the previous thread, I ran this statement to make sure I was getting just the suspect records (I actually counted the number of records looking at the Events console in View Admin as a reference before choosing a number to use in the below SELECT Statement):

SELECT TOP (20) [EventID],[Time] FROM [View_Event].[dbo].[vdievent]

This will return the TOP 20 records that (should, read the whole thread referenced above for cautionary info) are listed in the Events console. I knew there were less than 20 records displayed, so I looked at the results, ensured that the number of TOP (14) records I suspected was actually accurate, and then adjusted my next DELETE Statement appropriately:

DELETE TOP (14) FROM [view_Event].[dbo].[vdievent]

Walah! So cool!

Now, I am NOT a SQL guru, and I know enough transact to get myself in a LOT of trouble, but this one wasn't a biggy.

Thanks again for everyone's help, and hopefully this helps someone else!

smooter

Re: Purge data from active View Events DB

uday_s — Fri, 20 Jan 2012 14:24:44 GMT

Super Cool. Well done. Happy that I could help!

Re: Purge data from active View Events DB

amandasmith — Sun, 22 Jan 2012 14:43:51 GMT

Hi,

Check the following information http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1025914

Hope this information helps you.

Always remember you're unique, just like everyone else