Report - find hostname like with OR and DATE functions combined in

[Luis_Lopez]

Hi all,

I am having trouble putting together a report that does the following:

Find all assets that have hostname contain ABC OR 123
Last seen within last 30 days.

[Luis_Lopez]

Excellent!
Thanks.
I had some trouble getting the date part to work, but finally, I got it to work this way:

tblAssets.Lastseen >= Current_TimeStamp - 30

[RCorbeil]

...
WHERE
  DateDiff(dd, tblAssets.Lastseen, GetDate()) <= 30
  AND (   tblAssets.AssetName LIKE '%ABC%'
       OR tblAssets.AssetName LIKE '%123%')