This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Community FAQ
Register | Log In
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Lansweeper Community
- Forums
- Reports & Analytics
- Report for new asset
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Register to ask a question, start a topic or share an idea
Join the Community
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
Reports & Analytics
Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.
New to Lansweeper?
Try Lansweeper For Free
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now
Related Content
- Creating a custom chart report for USB-C Docks in Reports & Analytics
- Windows 11 Devices Without a Specific Software (Report Builder) in Reports & Analytics
- Report - KB report details for the month of February in General Discussions
- Custom state asset in General Discussions
- Azure AD scanning, tblAzureAdUser LastLogon is NULL in General Discussions
