→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
jaynnibal
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
jaynnibal
Engaged Sweeper
Great! Tyvm 🙂
Hemoco
Lansweeper Alumni
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