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 | Customers notes to 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 signture publisher are to be discovered, |
| Auto Assign Regex | string | true | Regex to discover the publisher in signtures, |
| 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 |