Overview

Electronic locks record every time a credential is used to open the lock. Schlage SMS Express refers to this data as "audits". The data can then be used to generate reports through Schlage SMS Express and analyzed in Excel. Because the Grad Commons reports are HTML format, it is possible to read the raw data in the reports as well, but it is tedious. That is why we use Excel and Pivot Charts to analyze the data from the  research rooms to enforce minimum usage policies. 

...

• HHD
• Autosync cable with the serial prongs
• Programming credential
• Room Checklist
• Master Key card for research rooms (You will NOT be entering the rooms though.)

Collecting Audit Data

Of all the processes required to manage electronic locks, collecting audit data is probably the most automated. To collect the data:

1. Open the Schlage Utility program on the HHD and login.
2. Make sure the serial icon is showing on the lower right corner of the screen. If the USB icon is being displayed, tap the icon once and it should switch to the serial icon.
3. Plug the prongs into the two holes on the front of the electronic lock. Make sure the prong end is facing so that the two circles on the prongs are facing upwards (almost like a little face).
4. Now you wait while the HHD does it's thing. Several messages will appear. This is not necessarily all-inclusive but to give you a general idea:
   1. "No door data available"
   2.  The door you are plugged into will eventually pop up
   3. "Gathering Audit data"
   4. "Audit data successfully gathered"
5. Remove the prongs from the lock and go to the next door.
6. If something else happens, see the Troubleshooting section below.

Downloading Audit Data

After you have collected the data, it needs to be downloaded onto the computer. 

• Plug the HHD into the computer.  Open Schlage SMS Express. Make sure you open the correct facility fileMake sure it is turned on and active.
• Also plug it into the AC adaptor cable so that it can charge it's battery.
• Open the Windows Mobile Device Utility.
• The HHD should automatically sync. If it doesn't, you may have to unplug the HHD and try again.
• Allow the HHD to sync the files to the computer using Windows Mobile Device Utility.Close Schlage
• SMS Express. This will force the file to be backed up and saved.That's it. That's all you have to do. 

Troubleshooting When Collecting Audit Data

Date/Time doesn't match HHD message

Locks have an internal clock. However, because they are battery operated, over time the clocks begin to lose time. If they are off by even as little as a minute, a message will pop up asking if you want to correct this. This is why you bring the programming credential. When this message pops up, do the following.

1. Tap "yes". You always want to tap "yes" because if you don't, you won't be able to collect the audit data.
2. The program will ask you to present a programming credential.
   1. Hold the fob in front of the oval shaped indentation. This is the credential reader.
   2. Hold it steadily and be patient. These locks are old and it takes awhile to recognize the credential.
   3. If it just isn't doing anything, change the angle of the front of the fob so it is pointing towards different areas of the oval but do not remove the credential from the oval.
   4. Eventually the red and green LED lights should start flashing.
3. Tap "ok" on the screen. 
4. The program should do it's thing and eventually it will tell you it has successfully corrected the time. 
5. You can hit "ok" if you want or you can just wait and it will start downloading the audits.

Generating Audit Reports

Schlage SMS will generate Audit report files. These files contain a massive amount of data. 

...