| Organization ID |
numeric |
false |
Internal ID that references the Organization entity (Foreign Key) |
| Organization Guid |
guid |
false |
|
| Organization |
string |
true |
Name of the organization |
| Organization Description |
string |
false |
Description |
| Organization Custom Field1 |
string |
false |
Available for custom data, not used by OctoSAM Inventory, |
| Organization Custom Field2 |
string |
false |
Available for custom data, not used by OctoSAM Inventory, |
| Organization Custom Field3 |
string |
false |
Available for custom data, not used by OctoSAM Inventory, |
| Organization Custom Field4 |
string |
false |
Available for custom data, not used by OctoSAM Inventory, |
| Object State ID |
numeric |
false |
Internal ID that references the ObjectState entity (Foreign Key) |
| Object State |
string |
false |
Object state name |
| Object State Octopus Id |
string |
false |
Octopus technical name of this state |
| User ID |
numeric |
false |
Internal ID for the User entity (Primary Key) |
| User Guid |
guid |
false |
A unique ID that can be used to link to this user object by external applications, |
| User |
string |
true |
Combination of attributes for consisten naming on screen or in reports |
| Login Name |
string |
false |
SAMAccount name, |
| Domain Name |
string |
false |
Domain of the logged on user, |
| Display Name |
string |
false |
DisplayName attribute from the directory service, |
| User Description |
string |
false |
Description attribute from the directory service, |
| Directory Title |
string |
false |
Title (JobTitle) attribute from Active Directory |
| Directory Employee ID |
string |
false |
EmployeeID attribute from Active Directory (updated on import and housekeeping) |
| Directory Company |
string |
false |
Directory attribute from Active Directory |
| Directory Mail |
string |
false |
Mail attribute from Active Directory |
| Directory Proxy Addresses |
string |
false |
ProxyAddresses attribute from Active Directory |
| Directory Telephone Number |
string |
false |
TelephoneNumber attribute from Active Directory |
| Directory Postal Code |
string |
false |
PostalCode attribute from Active Directory |
| Directory City |
string |
false |
City attribute from Active Directory |
| Directory Street |
string |
false |
Street attribute from Active Directory |
| Directory Street Address |
string |
false |
StreetAddress attribute from Active Directory |
| Directory Department |
string |
false |
Department from Active Directory |
| Directory Department Number |
string |
false |
DepartmentNumber from Active Drectory |
| Directory Home Directory |
string |
false |
HomeDirectoy attribute from Active Directory |
| Directory Home Drive |
string |
false |
HomeDrive attribute from Active Directory |
| Directory Physical Delivery Office Name |
string |
false |
PhysicalDeliveryOfficeName attribute from Active Directory |
| User Principal Name |
string |
true |
UserPrincipalName from the directory service, |
| Printable Name |
string |
false |
Combination of attributes for consisten naming on screen or in reports |
| Created |
date |
false |
Date/Time this user object was created |
| First Scan |
date |
false |
Date/Time this user was scanned first |
| User Last Scan |
date |
true |
Date/Time this user was scanned last |
| Deleted In Directory |
bool |
true |
True, if the user object was deleted from the directory. |
| Deleted In Directory First Detected |
date |
false |
Date/Time the DeletedInDirectory flag was set, |
| Directory Ext1 |
string |
false |
Site specific data, can optionally be used to load site-specific extended schema properties. |
| Directory Ext2 |
string |
false |
Site specific data, can optionally be used to load site-specific extended schema properties. |
| Directory Ext3 |
string |
false |
Site specific data, can optionally be used to load site-specific extended schema properties. |
| Directory Ext4 |
string |
false |
Site specific data, can optionally be used to load site-specific extended schema properties. |
| Last Found In Directory |
date |
false |
Date/Time the user object was last found in Active Directory, |
| Last Found In Entra ID |
date |
false |
Date/Time this user was last found in Entra ID |
| Directory Path |
string |
false |
Path of the user object in the directory service |
| Directory Container Path |
string |
false |
Path to the container objct of this user |
| Directory Extension Attribute1 |
string |
false |
ExtensionAttribute from Active Directory |
| Directory Extension Attribute2 |
string |
false |
ExtensionAttribute from Active Directory |
| Directory Extension Attribute3 |
string |
false |
ExtensionAttribute from Active Directory |
| Directory Extension Attribute4 |
string |
false |
ExtensionAttribute from Active Directory |
| Directory Extension Attribute5 |
string |
false |
ExtensionAttribute from Active Directory |
| Directory Extension Attribute6 |
string |
false |
ExtensionAttribute from Active Directory |
| Directory Extension Attribute7 |
string |
false |
ExtensionAttribute from Active Directory |
| Directory Extension Attribute8 |
string |
false |
ExtensionAttribute from Active Directory |
| Directory Extension Attribute9 |
string |
false |
ExtensionAttribute from Active Directory |
| Directory Extension Attribute10 |
string |
false |
ExtensionAttribute from Active Directory |
| Directory Extension Attribute11 |
string |
false |
ExtensionAttribute from Active Directory |
| Directory Extension Attribute12 |
string |
false |
ExtensionAttribute from Active Directory |
| Directory Extension Attribute13 |
string |
false |
ExtensionAttribute from Active Directory |
| Directory Extension Attribute14 |
string |
false |
ExtensionAttribute from Active Directory |
| Directory Extension Attribute15 |
string |
false |
ExtensionAttribute from Active Directory |
| Directory Last Logon Timestamp |
date |
false |
LastLogonTimestamp attribute from Active Directory (updated on import and housekeeping). Resolution: 14 days. |
| Directory Preferred Language |
string |
false |
User's preferred language from ActiveDirectory |
| Directory When Created |
date |
false |
WhenCreated attribute from Active Directory |
| Directory When Changed |
date |
false |
WhenChanged attribute from Active Directory (updated on import and housekeeping) |
| Directory User Account Control |
numeric |
false |
UserAccountControl attribute from Active Directory (updated on import and housekeeping) |
| Directory Disabled |
bool |
false |
True if the UserAccountControl attribute has the disable bit set |
| Directory Type |
string |
false |
Directory type that this user was found in., |
| Entra Id Cost Center |
string |
false |
Cost center from Entra ID |
| Entra Id Creation Type |
string |
false |
Entra ID creation type |
| Entra Id Created Date Time |
date |
false |
Date/Time created in Entra ID |
| Entra Id Deleted Date Time |
date |
false |
Date/Time this user object was deleted in Azure AD |
| Entra Id Division |
string |
false |
Division from Entra ID |
| Entra Id Employee Hire Date |
date |
false |
Date this employee was hired |
| Entra Id Employee Leave Date Time |
date |
false |
Date/Time this employee was left or will leave |
| Entra Id Given Name |
string |
false |
Given name of the user |
| Entra Id On Premises Distinguished Name |
string |
false |
Distinguished name that got replicated from on-site to Entra ID |
| Entra Id On Premises Domain Name |
string |
false |
Domain name that got replicated from on-site to Entra ID |
| Entra Id On Premises Last Sync Date Time |
date |
false |
Date/Time this object was last synchronized from on-site AD |
| Entra Id On Premises Sync Enabled |
bool |
false |
If true the user object gets synchronized from an on-size AD |
| Entra Id On Premises User Principal Name |
string |
false |
UPN that got synchronized from on-prem AD |
| Entra Id Preferred Data Location |
string |
false |
Preferred data location from Entra ID |
| Entra Id Surname |
string |
false |
Surname of the user |
| Entra Id Tenant Id |
guid |
false |
Entra ID tenant Id |
| Entra Id User Type |
string |
false |
Entra ID user type |
| Entra Id Last Sign In Date Time |
date |
false |
Date/Time this user last signed in to Entra ID. This information may not be available depending on your Entra ID license. |
| Entra Id Last Non Interactive Sign In Date Time |
date |
false |
Date/Time of the last non-interactive sign in to Entra ID. This information may not be available depending on your Entra ID license. |
| Mapping Tag |
string |
false |
A field that can be used for custom organization mapping |
| Custom Field1 |
string |
false |
Available for custom data, not used by OctoSAM Inventory, |
| Custom Field2 |
string |
false |
Available for custom data, not used by OctoSAM Inventory, |
| Custom Field3 |
string |
false |
Custom Data - not used by OctoSAM Inventory |
| Custom Field4 |
string |
false |
Custom Data - not used by OctoSAM Inventory |
| Most Frequently Used Machine ID |
numeric |
false |
Internal ID that references the Machine entity (Foreign Key) |
| Most Frequently Used Machine |
string |
true |
Use this name in reports for consistency and to avoid having to build the printable name from its parts |
| Most Frequently Used Machine Guid |
guid |
false |
A unique ID that can be used to link to this machine object by external applications |
| Most Frequently Used Machine Organization ID |
numeric |
false |
Internal ID that references the Organization entity (Foreign Key) |
| MFUM Network Address |
string |
false |
Network address, usually the IP number. |
| MFUM Operating System |
string |
false |
Full name of the OS |
| MFUM Operating System Server |
bool |
false |
True if this OS is a server version |
| MFUM Operating System Version |
string |
false |
|
| MFUM Operating System Display Version |
string |
false |
DisplayVersion for operating systems that support this attribute. Newer Windows versions use this instead of ReleaseID. |
| MFUM Operating System Build |
string |
false |
|
| Most Frequently Used Machine Last Scan |
date |
false |
Date/Time of last scan that updated this relation, |
| MFUM Last Login Was Local Administrator |
bool |
false |
True if the referenced user is member of the referenced machine's Administrators group, |
| MFUM Last Login Was Remote |
bool |
false |
True if scan was during a remote session, |
| Res1 |
string |
false |
Reserved for internal use by future versions |
| Res2 |
string |
false |
Reserved for internal use by future versions |
| Service Now Sys ID |
guid |
false |
Service Now: sys_id of the replicated object, |
| Service Now Last Export |
date |
false |
Date/Time of last export to ServiceNow, |
| Service Now Last Import |
date |
false |
Date/Time of last import from ServiceNow |
| Synch Last Synch |
date |
false |
Timestamp of last synchoronization of this User with the partner CMDB. Not used by OctoSAM Inventory. |
| Synch Token ID |
string |
false |
Can be used for synchronization with another inventory or CMDB system. Holds the key to the identical item in the CMDB. Not used by OctoSAM Inventory. |
| Current Date Time |
date |
false |
Date and time the query was run. For reference if you use and save query results. |