Tracker Products Home » Support files » Technical documents » Admin reset script

Open a support ticket

Welcome!

Introduction

Help files

Basic functions

Cases, persons and items

Location setup

System customization

Chain-of-custody

PDA mobile tracking

System tools

User administration

Miscellaneous features

Technical documents

General technical info

Installation guides

Hardware

Software version guide

Additional info

News and articles

Admin reset script

If you have locked out/deleted your administrative account, the following script will reset/restore the admin account.

This script requires direct access to the Tracker database.

WARNING: Modification of this script can cause undesired results, including loss of data integrity or complete data loss. Do not modify this script or run any other SQL commands or SQL scripts against the Tracker database without first consulting an Tracker representative.

/*----------------------------------------------*\
| Admin Account Reset Script                     |
|                                                |
| ==TO USE==                                     |
| Execute the entire contents of this text       |
| document in SQL Server Management Studio,      |
| or SQL Query Analyzer                          |
|                                                |
| ==BEHAVIOR==                                   |
| If 'admin' account exists, resets              |
| password to 'password' and forces              |
| change on next login.                          |
|                                                |
| If 'admin' account does not exist,             |
| creates account with password of               |
| 'password' and forces change on next login.    |
|                                                |
|           -support@trackerproducts.com         |
\*----------------------------------------------*/


IF EXISTS(select * From users where txtusername = 'admin')
 BEGIN
	UPDATE Users SET txtPassword = '5f4dcc3b5aa765d61d8327deb882cf99', 
              txtForcePassword = 1, intPwdFails = 0 
              WHERE txtusername = 'admin'
	UPDATE tblEmployees SET active = 1 
              WHERE userid in (select [id] from Users where txtusername = 'admin')
 END
ELSE
 BEGIN
	INSERT INTO Users (intPwdFails, accesskey, txtusername, txtpassword, 
                          txtForcePassword, txtDateCreated, txtDateLastLogin, 
                          NumLoggedIn)
	       VALUES (0, 'app_user', 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 
                      1, GETDATE(), NULL, 0)

	INSERT INTO tblEmployees (UserID, LocID, FirstName, LastName, Badge, EmailAddress, 
                                 Archive, Active, Admin, SiteAdmin, Power_User, Add_Evidence, 
                                 Edit_Evidence, Add_Custody, Run_Reports, ReadOnly, 
                                 eAlert_Admin, eAlert_Password, eAlert_Aged, eAlert_Audit, 
                                 eAlert_ItemRequest, txtDateCreated, Notes)
	       VALUES (@@IDENTITY, 1, 'Admin', 'Account' , '00', 'change@me.com', 0, 1, 1, 0, 
                      1, 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, GETDATE(), ' ')
 END