
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-30-2013 02:04 PM
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
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
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-30-2013 06:13 PM
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:
- 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
- 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
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-04-2013 10:59 AM
Great! Tyvm 🙂

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-30-2013 06:13 PM
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:
- 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
- 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
