Help With WQL Query

[tEkHEd]

Hi there.. I am trying to find out what patches have been applied to a machine within the last month via the SMS 2K3 SoftwareUpdates FP.

I need to do this on the client so I am querying the Win32_PatchState WMI Class.

I am having a problem with the Date time format in WMI (Universal Time Code) as I can't do a Now() - 31 or DATEDIFF with this format.. can anyone point me in the right direction?

 

[HRoarke]

Give this a shot:

    Dim d As DateTime
    Dim d1 As DateTime
    d = System.DateTime.UtcNow() 'your WQL UTC Date value
    d1 = DateAdd(DateInterval.Day, -31, d) 'your target date
    MsgBox(d1.ToUniversalTime, MsgBoxStyle.OKOnly) 'the result

"I swear by my life and my love of it that I will never live for the sake of another man, nor ask another man to live for mine."
— John Galt
Atlas Shrugged

If you want to get the best response to a question, please check out FAQ222-2244 first