This forum is for discussion of MySQL database related issues.
I am creating computer reports from a MySQL database for labtech (Automate). But there aren't any date tables. Does that mean MySQL overwrites the data when a new computer is added? How do I see how many new computers we've added to the database in the last year/month/weeks/days etc? Is there an internal date table for MySQL? Any help would be greatly appreciated. Thank you.
- Posts: 1
- Joined: Tue Jun 06, 2017 9:19 am
We have a search for this, with a rolling 31 day window:
Field: Date Added To System
Values: *date_add(now(),interval -31 day)
The * tells LT to treat the string as raw SQL.
- Hero Member
- Posts: 1577
- Joined: Wed Dec 31, 1969 8:00 pm
Return to MySQL Database
Who is online
Users browsing this forum: No registered users and 1 guest