LabTech Support Forums

MySQL Database Automate

This forum is for discussion of MySQL database related issues.

Moderator: jware.connectwise

MySQL Database Automate

Postby mopyd.provenit » Tue Jun 06, 2017 9:20 am

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

Re: MySQL Database Automate

Postby teamits » Tue Jun 06, 2017 1:28 pm

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
Hero Member
Posts: 1578
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