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. 

This page will cover how to collect the data, generate reports, store those reports for analyzing, and avoid losing data.

...

Audit data can be collected in two ways.

• Every time you program a lock, audit data from that lock is automatically downloaded to the HHD.
• Plugging the HHD into a lock without programming a lock. This is much faster. Just plug in the HHD and let the locks do the rest. You will see a message telling you the HHD is downloading the audit data.

Gathering Supplies

Supplies you will need:

• HHD
• Autosync cable with the serial prongs
• Programming credential
• Room Checklist

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.

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 file.
• 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.

Troubleshooting When Collecting Audit Data

Date/Time doesn't match HHD message

...