Skip to end of metadata
Go to start of metadata


Records of computer hardware, ownership, network addresses, and problem reports


  • Notes for troubleshooting and problem tracking
  • name assignment
  • matching computers to owners

Restricted Information

Personal identifiersName, email

Imports from central system(s)

  • No automated imports
  • Has scripts to lookup records in netreg, clearpass and LDAP.

Exports to central system(s)

  • none

Relation to Workday Project

  • unrelated to Workday

The Biocomputers database contains my working notes about past and present computers in various labs, including some computers belonging to students and staff.

Some other accessible databases maintained by LTS that are also very useful in tracking down information about computers are:

  1. Clearpass: /
    1. use for tracking what computers have what IP address
  2. EfficientIP:

This database provides buttons that open those databases by script for a particular computer.

  • note, this will only work for accounts that have access to those databases.

Old databases no longer primary

Databases no longer in use - the interfaces can be removed from SciComputers.
  1. Netreg: this is the new registration database. This also creates the dynamic DNS names See
  2. Norm; this was the old registration database used so that computers can get IP addresses via DHCP. Though no longer in use for that purpose, it is still functioning for the assignment of DNS names, and for polling the arp tables to see what HW address has been at what IP. See
    • no longer exists; Somewhere or other I think I kept a copy of the "last seen" information
    • DNS is controlled via Route 53 / AWS. 
  3. Secscan: this is the result of the periodic vulnerability scans. I believe this is slated for replacement Summer 2011. See
    • also no longer exists, I think. Not replaced by anything directly accessible.

Databases that still are there but are not primary

  1. Route53: no longer the primary source of DNS information, but I can still log into it and maybe still in use? (Feb 2019)


Getting System Information

generally want to do this from command line so I can do it remotely and can cut and paste results into the DB


The psinfo command from PsTools is very convenient

  • psinfo \\COMPUTERNAME



  • system_profiler SPHardwareDataType

-- KarelSF - 05 Aug 2008

  • No labels