‎04-16-2019 09:39 PM
‎04-17-2019 12:07 PM
‎04-17-2019 01:01 AM
aplechaty wrote:
Good Afternoon,
I am not much of a report writer so thought I would ask here. Does anyone have a report that displays only items that show as first seen in the last 3 months. Our network operations center wants information so they can be sure any new systems that show up are entered for monitoring.
So they want a report that lists all machines first seen within the last 3 months to compare and add the devices as needed. Thanks in advance.
‎04-16-2019 10:06 PM
WHERE
...
AND DateDiff(mm, tblAssets.Firstseen, GetDate()) <= 3
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now