Report for new asset

[jaynnibal]

Hi guys,

I'm a new user of Lansweeper and i'm pretty bad at SQL query :s

I want to know if it's possible to create a report that show me (and then email me) every new asset. I was thinking for a "First seen" query but i really have no idea how to create it.

Can you help me?

Regards

[jaynnibal]

Great! Tyvm 🙂

[Hemoco · Accepted solution]

Do the following:
- Open the report builder under Dashboard/Reports/Report Builder.
- In the visual representation of the report in the upper section of the report builder, tick the Firstseen field in tblAssets to add it to your report.
- In the expression list, add the following criterion to the Criteria column for the tblAssets.Firstseen expression:

> GetDate() - 1

- Give your report a title and hit the Save & Run button to save it.
- Instructions for setting up an email alert can be found on page 136 and beyond of our online documentation: http://www.lansweeper.com/documentation.pdf