February 10, 2014 at 3:56 pm
Hello - My server event log is difficult to work with. I was wondering if there's a way to wire up the event log to a SS database? Essentially, the goal would be to be able to query the event log as a SS DB through SSMS. Do you know if this is possible and if there's a relatively easy way to do this?
February 10, 2014 at 4:28 pm
I'd actually like to ensure that all events in the event log are included in the SS DB. Not just errors and not just events related to SS. An event handler/listener approach would be most ideal I think. Essentially, events would be propagated from the event log to SS in real time as the events are logged. If this is not possible then I would need to figure out the best way to pull this info from the event log into the DB on an hourly basis.
February 10, 2014 at 8:37 pm
I pretty much suck at PowerShell simply because I don't use it for much. BUT, this looks like a great use for PowerShell and, combined with some interesting stuff that I don't recall off the top of my head to easily route the output to an SQL Server table, I'm thinking that PoSH might just be the trick to "wire" this bad boy up. If it were me, I'd start here...
http://technet.microsoft.com/en-us/library/ee176846.aspx
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply