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.
mopyd.provenit
Newbie
Newbie
 
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.
Steve
teamits
Hero Member
Hero Member
 
Posts: 1566
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