Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 19 Next »

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

Collecting Audit 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.

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.

Generating Audit Reports

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

  • Open Schlage SMS Express.
  • Make sure you are in the correct facility file by opening the facility you want to work with.
  • Click "Audits" from the menu across the top of the window. Choose Door/Date.

  • There is a good chance the program will freeze during this process. Just give it time. It is processing a lot of data and it may take as long as 10 minutes before the program unfreezes.
  • Once the reports are generated, a window will pop-up like this.

  • There will be many, many pages of reports. Each page is a separate file.
  • Click on the folder in the upper left corner and the program will show you the location of the reports.

  • Open an Explorer Window and follow that path: Computer<OS Disk (C:)>Program files (x86)>Schlage>Schlage Express

  • Do not open the "Reports" folder. If you do, the folder will appear empty. You must do one more step first.
  • Notice how the Reports folder is faded? Click "Compatability files" on the bar near the top of the pane. The window will then change in appearance.

 

 

 

 

Instructions

  1. Take the HHD and autosync cable to the lock that you want to run the audit on. The Schlage Utility Software on the HHD needs to be open. 
  2. Connect the HHD to the lock and it will run the audit automatically. There is text confirmation that lets you know that it's collecting the audit data.
  3. At the study room coordinator's desk. Reconnect the HHD to the computer and the audit information will be uploaded. Windows Mobile Device Center should show that it has synced to the computer. You can check the time that the device last synced and it should be in the last few minutes.
  4. In SMS Express:
    1. First, make sure you are in the correct facility ("Valley Rooms") and not "Office Doors." We have no need at this time to collect audits from that facility.
      1. Click on the "Users" button. The first user listed should be "1159." Also, when you produce the report, the first room should be 1159. 
    2. Click on Audits. When you click on this menu option, it will create the reports. Sometimes, this can take a long time (10+ minutes). Just let the computer process it.
    3. Select Audits by Door/Date, which will bring up a new window that will have many pages of data. 
    4. Scroll through the list of rooms to find the desired room.
  5. Find the audit files on the computer and save them to the share drive.
    1. Go to desktop and open the shortcut for "Schlage Security Management System Express" folder.
    2. Open the "Reports" folder.
    3. Select all the files and copy them.
    4. Open the "Rooms" folder from the Circulation share drive. There is a shortcut for it on the desktop.
    5. Open "Research Room Audits"
    6. Create a new folder with the format: "Report Created Date"
    7. Open the new folder and paste the HTML files into it. 
    8. Voila! You're done.

Here are some overarching issues with audits:

If you transfer the program from one computer to another, you'll need to get the audit files from the doors before you switch the database file (you don't have to program the doors, just get the audit files, which is a bit faster), then transfer the program, and then program all the doors. Generate files for all the doors that you need data from. Click on Generate Program Files and then click on Show all doors and then select the desired doors.  

You have to program all the doors again because the computer that has the program installed assigns a unique number to the lock and that's what it uses to match the audit data to the lock. It will assign each lock a new number when you program 

If you program the lock, it will delete the audit data from the lock and it can't be retrieved again.

Here is how you lose data:

  1. Program the lock
  2. Don't produce the audit report
  3. Generate files
  4. Program the door again
  • No labels