Any suggestions to speed up this relevance? (Windows Event Log scraping)

[trn]

This forum post by@strawgate may be of help

Relevance: Speeding Up Event Log Queries

Hello! I wanted to take you on a journey of how slow event log queries can be and some tricks you can use to speed it up. Relevance and WMI On my system at home the security event log is 20mb but at work it’s 80mb and querying that with BigFix is slow… Q: number of records of security event log A: 121063 T: 7885.829 ms Doing the same all-encompassing call with WMI ends after a couple of minutes in a timeout… Q: number of select objects "* from Win32_NTLogEvent where Logfile = 'Security'" of…