SoftwarePublisher (Internal)¶
OctoSAM internal query
Internal queries are advanced queries for analysis of the inner workings of the OctoSAM application. These queries are geared towards administrators with an in-depth knowledge of OctoSAM.
All rows and columns from the SoftwarePublisher table.
Fields¶
| Name | Type | Visible | Description |
|---|---|---|---|
| ID | numeric | true | OctoSAM internal ID of this entity |
| Guid | guid | true | Unique identifier for objects that are synchronized with the master catalog |
| Predefined By Octopus | bool | true | True if publisher is to be synchronized with the master catalog |
| Name | string | true | Software publisher's name |
| Url | string | true | Link to the Website |
| Notes | string | true | Customer's notes about the publisher. Not synchronized from the master catalog. |
| Master Notes | string | true | Notes that are synchronized from the master catalog |
| Auto Assign Enabled | bool | true | True if signature publishers are to be discovered |
| Auto Assign Regex | string | true | Regex to discover the publisher in signatures |
| Auto Assign Test Like Pattern | string | true | SQL LIKE type filter used to select signatures for auto assign testing |
| Auto Assign Notes | string | true | Notes about the discovery rules from master catalog |
| Junk Filter Enabled | bool | true | True if junk signatures are to be discovered |
| Junk Filter Regex | string | true | Regex to discover junk signatures per publisher |
| Junk Filter Test Like Pattern | string | true | SQL LIKE type filter used to select signatures for junk filter testing |
| Created | date | true | Date/Time this entity was created |
| Created By | string | true | User that created the entity |
| Last Modification | date | true | Date/Time this entity was last updated. In most cases, this is the time of the last import. In case of re-import of older scan files, LastModification can differ significantly from LastScan. |
| Last Modified By | string | true | User that last modified the entity |
| Master Last Modified | date | true | DateTime the master catalog entity got last modified |
| Master Last Modified By | string | true | User that last modified the master catalog information (not replicated) |
| Last Update From Master | date | true | DateTime the entity got last updated from master |
| Last Synch With Master | date | true | DateTime the entity last synchronized with master |
| Custom Field1 | string | true | Not used by OctoSAM |
| Custom Field2 | string | true | Not used by OctoSAM |
| Custom Field3 | string | true | Not used by OctoSAM |
| Custom Field4 | string | true | Not used by OctoSAM |
| Hint Has Software Items | bool | true | True if software items assigned to this publisher exist |
| Object State ID | numeric | true | Internal ID that references the ObjectState entity (Foreign Key) |
| Current Date Time | date | false | Date and time the query was run. For reference if you use and save query results. |
Main entities referenced from this query¶
Query information¶
| Property | Value | Description |
|---|---|---|
| Query Guid | ac662813-43e0-4654-be15-20330d590b1d | The internal id of the query. Must be unique |
| SupportsDesktop | true | If true, the query can be started from the OctoSAM Windows GUI |
| SupportsWeb | false | If true, the query can be started from the OctoSAM Web UI |
| LastUpdate | 2025-09-10 17:27:37 | Last change to this document |
| Build | 1.11.6.94 | OctoSAM build that last changed this document |