cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Luis_Lopez
Engaged Sweeper
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.
2 REPLIES 2
Luis_Lopez
Engaged Sweeper
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
Honored Sweeper II
...
WHERE
DateDiff(dd, tblAssets.Lastseen, GetDate()) <= 30
AND ( tblAssets.AssetName LIKE '%ABC%'
OR tblAssets.AssetName LIKE '%123%')

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now