XML Query Select After Date -


i've been browsing around various forums trying figure out how restrict windows event log xml queries specific date range, seems xml doesn't play it. query have set is:

<querylist>  <query id="0" path="application">  <select path="application">  *[system[provider[@name='microsoft-windows-folder redirection']  , (level=2)]]  </select>  </query>  </querylist> 

basically i'm trying find out how limit query x amount of days ago , forward. i'm trying find computers above error may present problem, , if flagged error year ago or something, doesn't me.

can give me little direction on this?

try this:

<querylist>   <query id="0" path="application">     <select path="application">       *[system[provider[@name='application hang'] , (level=2) , (timecreated[timediff(@systemtime) &lt;= 86400000])]]     </select>   </query> </querylist> 

this limit created in last day (i.e. last 86,400,000 milliseconds). changed provider name application hang since don't have errors test against microsoft-windows-folder redirection, change that.

if need go further 1 day, use formula milliseconds:

(days) * 24 * 60 * 60 * 1000 = (milliseconds)

reference: https://msdn.microsoft.com/en-us/library/dd996910(vs.85).aspx#limitations


Comments

Popular posts from this blog

python - TypeError: start must be a integer -

c# - DevExpress RepositoryItemComboBox BackColor property ignored -

django - Creating multiple model instances in DRF3 -