Device/Group update schedule in SQL Table

W
Wayne
Continental Reifen Deutschland GmbH

Hello, 

We use the update schedule in MC 14.7 to run a rule to upload and execute a xml file which will the in return update our Zebra android devices, I am looking for the update schedules of each group/device in the MC SQL Database, I need this to be able to send a reminder to the device users that the update will happen and they need to ensure the devices are powered on. 

I looked but couldn't find this in the SQL DB, has anyone ever seen this update schedules somewhere in the DB?

5 years ago
SOTI MobiControl
ANSWERS
D
DDMOD@SOTI Platinum Contributor
5 years ago

Hi Wayne,

Thanks for the interesting post!

Can you please tell me how is the current Update Schedule rule in place? Did you push it via MobiControl web-console or database?

Regards,

W
Wayne
5 years ago

Hello

The update schedule is set in the WebGui of SOTI, I am looking for the SQL Table or view that holds these schedules so I can use this in a separate application to push some sort of notification to the device owner.

D
DDMOD@SOTI Platinum Contributor
5 years ago

Hi Wayne,

All the profile configurations are spread between different tables.

You can get the profile details from CatalogueItem table, PayloadId from ProfilePayload table, and Payload (task scheduler) contents from Payload table in the MobiControl database.

Regards,

W
Wayne
5 years ago

Hello

Yes I cant really find what I am looking for in these mentioned tables, I am rather looking for the device update schedule you set within each group or device; 

D
DDMOD@SOTI Platinum Contributor
5 years ago

Hi Wayne,

Can you please raise a support case(click here) or call SOTI Support team(click here) to show you these fields on your MobiControl database?

Regards,