This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
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
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
- Lansweeper on-prem report from Lansweeper App in General Discussions
- How to mass delete assets on-premises? in Open Office Hours Q&A
- Cloud Visibility Issue with Asset Locations in Open Office Hours Q&A
- Can we customize asset states to have an asset type other than the default "active" asset? in Open Office Hours Q&A
- In Lansweeper Sites, could we have a setting to hide assets that are "Non-Active" from reports? in Open Office Hours Q&A
