Skip to main content

Helpful Commands

The script commands can be executed for the following functionalities:

1.  FIPS Enabled Devices

If the SureMDM Agent version is < or = 4.64.0 and the Styx version is till 6.62.0, then the features such as App List update and Remote File Explorer will not work for the devices using Hashing and Encryption.To overcome this, follow the below-mentioned steps:

1.  Use SureMDM Agent v4.64.0 or above.

2.  Run the below mentioned query in sql db 

 ALTER TABLE installedapplist ALTER COLUMN checksum_installedapplist varchar(65) NOT NULL;

2.  Comment on Auto-backup scripts

 While upgrading on-premise package, sometimes auto backup will not work due to huge SQL data. To overcome this, you need to comment on all auto-backup scripts. 

1.  Navigate to this path C:\inetpub\wwwroot\dbsetup\scripts\BackupRestore.

2.  Open dbBackup.sql file. 

3.  Comment on all backup scripts.

note

Backup should be taken manually.

3.  Change Console Language

1.  Check if default value is 0 in the below mentioned query.

select hide_language_customer from customer

2.  Update value to 1 using the following query.

Update customer SET hide_language_customer = 1

note

Once after updating the language option, it will display under Account Settings on the console.

4. OS Version is not getting updated in the device info panel for Android 11 and 12 devices

Run the query given below for OS version update:

  • INSERT INTO platform (platform_type,os_version,os_name) VALUES
  • ('Android','30','ANDROID 11'),
  • ('Android','31','ANDROID 12');
note

This script is applicable only upto styx v6.62.0

5. Call Log Timing is not showing correctly

If there is a time difference between the time on the device and the call log in the SureMDM On-Premises console, recheck and correct the time zone as mentioned below:

  • The Server Time should be set in UTC time zone to display the same time on the device and the call log in the SureMDM On-Premises console

6. Not able to rename the device and reboot the device from the dynamic job

If the http request is blocked in the server, the API will not be able to communicate with pluto, so to establish the communication please change the baselocalurl with DNS providing https at the below-mentioned path:

  • wwwroot/web.config and wwwroot/api/web.config - If deployment is without /suremdm
  • suremdm/web.config and suremdm/api/web.config - If deployment is with /suremdm

7. Mail Configuration for SureMDM On Premise

Click here to learn how to send mail through a normal Gmail account.