Report to see any device first seen within the last 3 months

[aplechaty]

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.

[aplechaty]

Thanks i did a bit more searching around the finished reports and found a similar one for 7 days and just modified it to 90 instead of 7 seemed to work.

[AZHockeyNut]

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.

there are canned reports for computers and devices and software (all different reports) that are new in the last 24 hours. You could easily modify those and create new reports.

I know this because I just found them and created a daily task to email me those reports 🙂

[RCorbeil]

DateDiff() is your friend.

Set up a report with the fields you want and include

WHERE
  ...
  AND DateDiff(mm, tblAssets.Firstseen, GetDate()) <= 3

to filter for assets first seen within the last three months.