Slashdot Mirror


Ask Slashdot: Automatically Logging Non-Computerized Equipment Use?

First time accepted submitter Defenestrar writes "I've recently taken a job at a large state university where I manage the laboratories for a couple of departments. We have a good system to pro-rate costs for shared use of big ticket items, but don't have anything in place for small to medium expense pieces which don't require software control (i.e. AD user authentication logs). It is much more efficient to designate a common room for things like water purifiers and centrifuges, but log books have a history of poor compliance. Also, abuse or neglect of communal property has been an issue in the past (similar to the tragedy of the commons).

Do any of you know of good automatic systems to record user/group equipment usage which would allow for easy data processing down the line (i.e. I don't want to go through webcam archives). Systems which promote accountability and care are a bonus, but for safety reasons we don't want the room's door locked (i.e. no pin/badged access). Most of these systems also require continuous power — so electrical interlocks are not a good option either.

I call on you, my fellow Slashdotters, to do your best and get quickly sidetracked while still including the occasional gem in the comments."

16 of 130 comments (clear)

  1. Why not badging of the doors ? by SirGeek · · Score: 2

    You can easily have the door "locked" from outside, But the room can be easily exited in the event of a power loss (crash bar on the inside door).

    1. Re:Why not badging of the doors ? by hawguy · · Score: 4, Interesting

      You can easily have the door "locked" from outside, But the room can be easily exited in the event of a power loss (crash bar on the inside door).

      And if the safety issue is that people on the outside need to get in the room, just put in a big red "Press button to unlock door in case off emergency" button that sets off an alarm (or calls campus security and/or EMS services) while unlocking the door so if someone needs to get in the room in an emergency, they can.

      If the equipment is hazardous enough that even trained users might need help, then having a lock on the door that only lets authorized personnel in the room is probably a good idea.

    2. Re:Why not badging of the doors ? by Immerman · · Score: 2

      There's always low-security turnstiles - they don't really *block* anyone, just require you to be obviously disrespectful of it's purpose to get past.

      --
      --- Most topics have many sides worth arguing, allow me to take one opposite you.
    3. Re:Why not badging of the doors ? by Spazmania · · Score: 2

      Maintenance staff already have badges and if they don't it's just another key on the ring. Filter out their codes when you audit the logs.

      For emergencies: use maglocked doors and include a big red button by the badge reader that both cuts power to the lock (releasing the door) and sets off an alarm ('cause it's an emergency, right?)

      --
      Moderating "-1, Disagree" is simple censorship. Have the guts to post your opinion.
  2. Yes.. by Lumpy · · Score: 5, Informative

    You hire someone to check it in and out. Honestly unless you put RFID tags on everything and then force them to be passed through a reader before use, you can not automate that stuff.

    --
    Do not look at laser with remaining good eye.
    1. Re:Yes.. by i.r.id10t · · Score: 2

      Yup, borrow some old tech from your campus library (barcode scanner, db backend) and "check out" the equipment just like they'd check out a book. Check with your campus financial aid department about putting in for a couple of workstudy positions (aka financial aid bs job) to do the actual checking in/out. For equipment that has parts that all go together (like a camera - camera, batteries, driver disc, manual, memory card or two) make a check sheet, laminate it, and attach to item or to the case the item should be in.

      This is what we do in my department (academic technologies) to let instructors check out dv cameras, still cameras, webcams, high quality headphone/mic set ups, classroom clickers, laptops, etc.

      --
      Don't blame me, I voted for Kodos
    2. Re:Yes.. by Nightwraith · · Score: 2

      You hire someone to check it in and out.

      Wish I had mod points for a 5-digit uid reply which should have been obvious to the OP.

      As mentioned below, surely there can be a work-study position funded for an inventory clerk. I'm sure there are already people being paid to check-in/check-out books & videos at the library or equipment at the gym/fitness center.

  3. RFID? by txoof · · Score: 2

    Adding RFID tags to equipment and encouraging people to swipe it out as it is used might be a good idea. But short of adding a supply clerk or using a badge system I don't see many other options. Maybe there's some work-study budget for a freshman to sit in the lab and check out equipment?

    I heard on Freakonomics about putting up web cams and paying someone in a far-off land to ensure hand-washing compliance. Perhaps a system like that might work.

    --
    This one's tricky. You have to use imaginary numbers, like eleventeen... --Hobbes
  4. Create a reservation system? by MasterOfGoingFaster · · Score: 3, Informative

    In cases like this, I create a resource in MS Exchange that can be reserved. Bill against that reservation. It isn't perfect, but after someone gets kicked off by someone who reserved it, they begin to use the system. This makes the guy that pays for usage the prefered user.

    --
    Place nail here >+
  5. I can read the future! by s.petry · · Score: 3, Insightful

    I was about to post this same thing, but in a different way.

    As an Oracle of the Bordland Delphi, I look into my magical book of syntax. I breath deeply the fumes of the mighty Pascalious Flowerus. Your future is very clear. I see a person, at a desk with a book. No wait! Two books!. The person sitting asks people for identification, and validates this against one book. If their name is found, they ask them to sign in to the other book. There is more! The desk sits sideways, so this person not only controls who enters the room, but also asks those leaving to sign out.

    This will be as it must be due to your mighty constraints of continual lightning and desire to have doors without locks!

    --

    -The wise argue that there are few absolutes, the fool argues that there are no probabilities.

  6. From working in labs: addressing common solutions by SuperBanana · · Score: 5, Insightful

    To people who haven't worked in labs:

    First off, generally the issue isn't tracking usage for the purposes of billing, or actual inventory (ie preventing people from walking off with things.) Most expensive stuff can and is plated and then cabled down to tables. The issue is often more tracking down who screwed up something so they're told not to do it again/given additional instruction, or their lab/PI is billed for the repair.

    Why? All manner of equipment isn't cleaned after use, or toxic stuff is used on equipment that can't be cleaned of it easily, or equipment that is shared with other experiments that would be damaged by certain chemicals or contaminants. Centrifuges have the wrong rotors installed or mis-balanced loads, destroying the bearings or worse. Cryo vacuum traps don't get cleaned and can accumulate liquid gas and explode. Microscope objectives get damaged from impacting the slide or overuse of oil for immersion objectives. Microscope light sources get left on and burn out (some of them have lifetimes measured in hundreds or a few thousand hours.) The list goes on.

    You can't always control power, because a number of instruments have long warm-up times before they stabilize, or require a bunch of parameters be entered on power-on.

    Access control via keycards works until you discover that someone left the lab, dropped off their ID, security for some reason never cancelled their card, and now it's become a shared resource in the lab. This happens so often it's not funny, except in places that take access control VERY seriously, like hospitals that have research groups. Or people swipe others in.

    It often really comes down to solving people problems with people, not technology...and having a culture of following procedures and policies. If someone can't follow procedure, lies, cheats, etc - they're a liability/danger to your lab/center/school reputation because they could be (and probably are) doing the same thing in their research. Why are you still employing/collaborating with them? Kick their ass to the curb.

    That said, a lot of equipment manufacturers could recognize this need, and provide lockout contacts that can be interfaced with various access control and logging solutions.

    Lastly, a reminder to Slashdotters: please think critically about the solutions you offer. If some random guy can think up a "solution", then chances are it's occurred to, and maybe even been tried by, someone with actual experience. At least recognize that possibility...

  7. Re:Internal billing is dumb by Spamalope · · Score: 2

    The problem is the management structure leading to internal billing sounding like a good idea! Flat rate the costs unless they're really significant and you can't gauge who the users are. Make the flat rate based on 'reserved' units. i.e. a portion of the resources have 'priority' access for a dept. based on the amount the dept. allocated to the budget. They are still shared, but the sponsoring dept. has priority access. Infrequent users use the 'free' equipment or any 'reserved' unit not currently in use. Frequent users can fund additional 'sponsored' units if they need more. While imperfect, it's better than treating each bit of equipment like a rent-way rental.

    The AC's idea of an RFID timeclock in the room is great if you must internally bill. A crude measure of usage should work if your office politics aren't toxic. If you really have problems with equipment abuse, you can use a webcam and review it only if there is unreported damage. Review the footage only with a managers approval with public knowledge every time it happens (with penalties for snooping) and you'll make junior NSA drama less likely.

    Still, internal billing is very expensive operationally.

  8. Penny wise and pound foolish? by gstoddart · · Score: 2

    So, your university wants to monetize the usage of the basic infrastructure in order to leverage your synergies by applying an undue burden of usage and accounting on the people to more accurately ensure they spend most of their time accounting for the 2 cents it cost to use the device? So you're going to make me waste an hour of my expensive and limited time to account for a few sheckles?

    I had a PM once who wanted us to account for our time in 5 minute increments. Then he was surprised that 1 of every 5 minutes was recording what we did the last 4, despite us having told him that is exactly what would happen.

    This sounds about as stupid and counter productive.

    It sounds like cost recovery run amok, and usually marks the point at which an organization has been taken over by accountants who then work very hard to ensure the real work can't happen.

    Sorry sir, I couldn't do any actual engineering/science/work because I was filling out my time sheets in triplicate, filling in the TPS reports, and updating the spreadsheet to indicate that I've done all of those things.

    The 'solution' you think your finding is essentially creating a new kind of problem -- and that's one created from institutional stupidity.

    My advice? Just don't do it.

    --
    Lost at C:>. Found at C.
  9. Re:Random spot checks by Anrego · · Score: 2

    The "off with their head" method doesn't work because there is always some annoying thing that a company is trying to eliminate and no one wants to work in environment with a huge list of trivial shit that gets them immediately fired.

    As to how I'd fix the problem. Have time on the equipment scheduled in advance. Periodic surveillance video spot checks on unbooked spots to make sure no one is sneaking in. Internal billing or whatever you are doing based on the schedule. It's kinda like a log book, but different!

    If you go this route, it's important to determine what the penalty is for violators. This is important, because you probably can't just off with their head, and a stern talking to probably won't cut it for repeat offenders. Billing teams caught using the equipment outside of schedule at a higher rate or doing this indirectly by assuming they were there for the entire contiguous unbooked block might work.

  10. Re:Not worth it .. by gb · · Score: 2

    This is all true, and in particular, most Universities in my experience (based on a representative sample of directors of research, research support IT types and tame academics like myself at research intensive UK Universities) are incredibly bad at managing the inter-departmental billing. In my institution even for the big-ticket items like electron microscope, the technical support people spend more time chasing down bills than actually supporting users on the kit. Any cost-benefit analysis conducted by people who actually known how a lab works quickly shows the whole thing to be a complete waste of time and money.

    Even for catching the idiot users who've broken something it can be difficult to make it pay. So you catch gormless post-doc whose just crashed a microscope stage into a sensitve detector, shorted out the HT and blown several boards in the back of the instrument. What happens - the HR people won't let you recover the costs from the salary (on the grounds that the post-doc would be destitute), the PI whose post-doc it was will refuse to pay because they've not been allowed to factor a charge for gormless post-docs into their grant application. Neither the host department nor the user's department will pay and will dispute liability (on the grounds that your system should have been interlocked against gormless users). You can ban said gormless post-doc from using the instrument again, but that's rather academic as right now nobody can use it all.

    In more industrial/manufacturing evironments one can lock down the processes which reduces this sort of mayhem, but in academic research environments that's much harder. If you can keep the userbase small (10 users on any bit of kit) you can jsut about manage to sport the gormless ones before they do damafe, but when you go to larger userbases it just gets to be a hard problem.

  11. Enforce it socially by jpvlsmv · · Score: 2

    Feel free to continue open access, but place a social stigma on using the equipment without recording your use.

    For example, imagine that when you sit down at the desk, a light goes on that says "Thanks for logging in" (if you have). Now, tomorrow, you find three other people in the lab who don't have the sign lit. You say "Hey, I can see that you didn't sign in to indicate that you're using the system-- here, let me help you"

    Another way to encourage self-policing from the users is to tie maintenance or upgrades to the logged use of the system. Say "Sorry, we're not going to upgrade that oscilloscope because nobody logs that they use it. We're going to spend grant money on the bench power supply in room 6B that has lots of log entries."

    Put these two things together, and the people who care about using the equipment will help you keep the other users under control.

    --Joe