Query Unmanaged Devices

Query Unmanaged Devices

Hello, I am in need of assistance in regards to pulling data from the MySQL database. I need to pull the devices that are on maintenance, the common name of the device, and when they went into maintenance. This query will go into a daily email script.

Looking at the table "elementsonmaintenance" is only slightly helpful, as I am having difficulty matching the two columns within to the rest of the database...

Thanks in advance!



                  New to ADSelfService Plus?