Database Tools

The Database Tools – Query Database feature helps Insperity Time and Attendance Professional Service Technicians and Master Users avoid having to access the database server to review TimeStar™ data. The Database Tools page includes a query analyzer tool that allows SELECT statements only, unless a private Insperity Time and Attendance admin password is supplied.

NOTE - It is recommended that only users who have a familiarity with SQL statements utilize the query builder.

To execute a query, follow these steps:

1.       Use the ‘SQL’ drop-down to select the action. Click the  icon to add the SQL to the query.

2.      Use the ‘Table’ drop-down to select the table to query. Click the  icon to add the table to the query.

3.       If applicable, use the ‘Field’ drop-down to select the field to query. Click the  icon to add the field to the query.

4.      From the ‘Output Results To’ drop-down select screen, excel file, or text file.

5.       Click the ‘Execute’ button.

6.      To save the query for future use, name the query and click the ‘Save’ button.

The Backup Tools tab includes a tool for creating and downloading database backups directly from the browser. In order to set it up correctly, the new backup folder in the TimeStar™ web root must have MODIFY rights for the IUSR account. 

To generate a database backup, follow these steps:

1.       Select the Backup Tools tab.

2.      Click the ‘Create Backup’ button.

3.       To create a zip file containing the backup file, select ‘Yes’ in the ‘Zip Backup’ drop-down.

4.      If the user selects ‘Yes’ a nag message will appear stating that zipping the file will take longer. Click ‘OK’ to the message that appears to proceed.

5.       Click the ‘Create Backup’ button.

6.      Click ‘OK’ to the message that appears to proceed.

To download a backup, follow these steps:

1.       Use the drop-down for ‘Existing Backup’ and select the backup to download.

2.      Click the ‘Download Backup’ button.

3.       Click ‘OK’ to the message that appears to proceed.

4.      You will have the option to save the backup file in the location of your choice.

To delete a backup, follow these steps:

1.       Use the drop-down for ‘Existing Backups’ and select the backup to delete.

2.      Click the ‘Delete’ button.

3.       Click ‘OK’ to the message that appears to proceed.