Stores properties related user (SAM account) IDs. Attributes consist of user (SAM account) IDs and common related properties (i.e., name, department, title).
| Column Name | Column Datatype | Column Null Option | Column Comment |
| samid | nvarchar(255) | not null | User (SAM account) ID |
| fn | nvarchar(255) | not null | User's first name |
| ln | nvarchar(255) | not null | User's last name |
| mgr | nvarchar(255) | with null | Manager's user (SAM account) ID |
| company | nvarchar(255) | with null | Company name |
| dept | nvarchar(255) | with null | Department identifier |
| office | nvarchar(255) | with null | Office identifier |
| title | nvarchar(255) | with null | User's title |
| orgnm | nvarchar(255) | with null |
Product Name: Unicenter Asset Intelligence
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| samid | ai_hwdef_login_maxscan_rel | samid |
| samid | ai_hwdef_login_lscandate_rel | samid |
| samid | ai_hwdef_login_all_rel | samid |
| samid | userhasreports | samid mgr |
| samid | userdirectscomputers | samid mgr |
| samid | ai_usrdef_orgtree_prop | samid |