This website uses cookies. By clicking Accept, you consent to the use of cookies.
Click Here
to learn more about how we use cookies.
Accept
Reject
Browse
Lansweeper.com
Developer Portal
Start Free Trial
Lansweeper Community
Lansweeper.com
Developer Portal
Start Free Trial
Community FAQ
Sign In
Welcome Center
Community Blog
Community Resources
Contests and Giveaways
Asset Discovery Challenge
[Caption Contest] Mad About Sweepy
Forums
General Discussions
Reports & Analytics
Product Discussions
Deployment Packages
Product Announcements
Archive
Knowledge Center
Knowledge Base
Requirements
Installation
Troubleshooting your installation
Scanning your network
Troubleshooting Scanning Issues
Customizing the Web Console
Managing Assets
Lansweeper Maintenance
Troubleshooting
Deploying Software & Other Changes
Configuring & Using the Helpdesk
Managing Software
Managing Licenses
Managing Users
Actions
Reporting
Billing-related Questions
Lansweeper OT
Cloud
Diagrams
Cyber Security and Risk Insights
Integrations
Pro Tips
Quick Tech Solutions
Support Portal
Training
Fundamentals
1. Introduction
2. Overview
3. Scanning & Discovery
4. Risk Insights
5. Features
6. Views, Reports & Dashboards
7. Operational Technology
8. API & Integrations
Video Series
Quiz
Trial Guide
Resources
Vulnerability Audit Reports
End of Life Updates
Patch Tuesday Updates
Events and Webinars
Events
Virtual Office Hours
Participate in Product Research
About the Programs
Open Programs
Luis_Lopez
Engaged Sweeper
since
01-28-2021
07-11-2022
User Statistics
2
Posts
0
Solutions
2
Kudos given
1
Kudos received
View all badges
Lansweeper Community
About Luis_Lopez
Options
Report User
User Activity
Posts
Replies
Report - find hostname like with OR and DATE functions combined in
01-28-2021
Hi all,I am having trouble putting together a report that does the following:Find all assets that have hostname contain ABC OR 123Last seen within last 30 days.
Re: Report - find hostname like with OR and DATE functions combined in
01-28-2021
Excellent!Thanks.I had some trouble getting the date part to work, but finally, I got it to work this way:tblAssets.Lastseen >= Current_TimeStamp - 30
Kudos from
User
Count
Luis_Lopez
1
View all
Kudos given to
User
Count
Luis_Lopez
1
RCorbeil
1
View all
