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 90 day the research rooms to enforce minimum usage policies.
...
- 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.
Supplies you will need:
- HHD
- Autosync cable with the serial prongs
- Programming credential
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
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.
Generating Audit Reports
Schlage SMS will generate Audit report files. These files contain a massive amount of data.
...
Unfortunately, it is very easy to lose audit data. Especially if you transfer the Schlage SMS Express software from one computer to another.
Here are some overarching issues with audits:
...