SoftwareItem¶
Software items hold customer specific information about software objects.
Fields¶
| Field | Type | Description |
|---|---|---|
| Active | bit | Mark the Item as active. Inactive items can be hidden from most lists. |
| AdditionalInfoLink | nvarchar | Can contain a link to additional information |
| AdministratorNotes | nvarchar | Remarks that can only be read by a small group of users |
| AlertEndDate | bit | |
| ConsumedUnits | decimal | A universal field that can contain a number |
| Created | datetime2 | Date/Time the item got created |
| CreatedByRbacUserID | bigint | RBAC user that created the item |
| CustomField1 | nvarchar | Custom field 1, not used by OctoSAM. |
| CustomField2 | nvarchar | Custom field 2, not used by OctoSAM. |
| CustomField3 | nvarchar | Custom field 3, not used by OctoSAM. |
| CustomField4 | nvarchar | Custom field 4, not used by OctoSAM. |
| CustomField5 | nvarchar | Custom field 5, not used by OctoSAM. |
| CustomField6 | nvarchar | Custom field 6, not used by OctoSAM. |
| Description | nvarchar | Description of the item. Can be html formatted. |
| Enabled | bit | If not enabled, the Item cannot be edited. |
| EndDate | datetime2 | End date of the software item |
| ExtraData | nvarchar | Extra data for this software item |
| Guid | uniqueidentifier | Unique ID of the item, can be used for export/import or for the web UI. |
| ID | bigint | Internal ID for the SoftwareItem entity (Primary Key) |
| InitialCost | decimal | Initial Cost |
| InitialCostCurrencyID | bigint | Internal ID that references the Currency entity (Foreign Key) |
| LastAlerted | datetime2 | |
| LastModification | datetime2 | Date/Time the item was last modified |
| LastModifiedByRbacUserID | bigint | RBAC user that last modified the item |
| Name | nvarchar | Name of the software Item |
| Notes | nvarchar | Remarks that are visible to all users that have read access to the item |
| OwnerNotes | nvarchar | Remarks that can only be read by software package owners |
| PrintableName | nvarchar | Name of this item for reports and queries |
| RecurringCost | decimal | Recurring Cost |
| RecurringCostCurrencyID | bigint | Internal ID that references the Currency entity (Foreign Key) |
| Res1 | nvarchar | Reserved for future use |
| Res2 | nvarchar | Reserved for future use |
| SiteUniqueID | nvarchar | A site defined unique id for each item. Must be unique if not empty. |
| SoftwareInstallationApproval | bit | Installation approval logic is active for this software item |
| SoftwarePublisherID | bigint | Internal ID that references the SoftwarePublisher entity (Foreign Key) |
| Spla | bit | True, if the Software Item describes a Microsoft SPLA item |
| StartDate | datetime2 | Start date of the software item |
| Units | decimal | A universal field that can contain a number |
| Version | nvarchar | Version of the software item |
| Visible | bit | Item is visible |
| VisibleStartDate | datetime2 | Item becomes automatically visible after this date |