prevent duplicate events from WMI queries?

[briguy]

Hi All - I'm using the WMI input to gather some custom WMI data. Some of the queries (such as below) result in duplicate events being indexed since the same events are returned each time the query is run. The fix seems to be adding a where clause based on the current date, but I don't know of a way to do this. Starting to feel like I'm going to have to write something custom. Any ideas?

On a related note - is anyone using wmi permanent event subscription to gather wmi data, rather that using polling? Seems like it might be a better way to go.

[WMI:DotNetErrors] disabled = 0 interval = 5 server = localhost wql = Select * from Win32_NTLogEvent WHERE logfile='Application' and Type='error' and SourceName like '%.NET%'

[briguy · Accepted solution]

Hi gkanapathy, thanks for your answer.

On further search I found this Answer, which looks like the solution: http://answers.splunk.com/questions/577/how-do-you-filter-windows-event-log

[gkanapathy]

You should not use WMI to query for the eventlog like this.

You're better off just using the Splunk WMI Windows Event Log input, and leave "pure" WMI for collecting statistics. It doesn't let you filter by Type or Sourcename. You will have to do that in Splunk instead.

By far the best way to collect the WinEventLog data is to use the Splunk local WinEventLog input, not the WMI one, but the forwarder agent needs to run on the box where the log is written for that to work.