Skip to content

SoftwarePublisher

Normalized publisher information from the catalog.

erDiagram
    ObjectState ||--o{ SoftwarePublisher : "ObjectStateID"
    SoftwarePublisher ||--o{ Machine : "OperatingSystemSoftwarePublisherID"
    SoftwarePublisher ||--o{ MachineOfficeAddIn : "SoftwarePublisherID"
    SoftwarePublisher ||--o{ MachineUserOfficeAddIn : "SoftwarePublisherID"
    SoftwarePublisher ||--o{ SoftwareItem : "SoftwarePublisherID"
    SoftwarePublisher ||--o{ SoftwarePackage : "SoftwarePublisherID"
    SoftwarePublisher ||--o{ SoftwarePublisherLegacyName : "SoftwarePublisherID"
    SoftwarePublisher ||--o{ SoftwarePublisherSwidRegid : "SoftwarePublisherID"
    SoftwarePublisher ||--o{ SoftwareSignature : "SoftwarePublisherID"

Fields

Field Type Description
AutoAssignEnabled boolean True if signature publishers are to be discovered
AutoAssignNotes string Notes about the discovery rules from master catalog
AutoAssignRegex string Regex to discover the publisher in signatures
AutoAssignTestLikePattern string SQL LIKE type filter used to select signatures for auto assign testing
Created datetime Date/Time this entity was created
CreatedBy string User that created the entity
CustomField1 string Not used by OctoSAM
CustomField2 string Not used by OctoSAM
CustomField3 string Not used by OctoSAM
CustomField4 string Not used by OctoSAM
Guid guid Unique identifier for objects that are synchronized with the master catalog
HintHasDocuments boolean True if the software publisher has associated documents
HintHasSoftwareItems boolean True if software items assigned to this publisher exist
ID numeric Internal ID for the SoftwarePublisher entity (Primary Key)
JunkFilterEnabled boolean True if junk signatures are to be discovered
JunkFilterRegex string Regex to discover junk signatures per publisher
JunkFilterTestLikePattern string SQL LIKE type filter used to select signatures for junk filter testing
LastModification datetime Date/Time this entity was last modified
LastModifiedBy string User that last modified the entity
LastSynchWithMaster datetime Date/Time the entity last synchronized with master
LastUpdateFromMaster datetime Date/Time the entity was last updated from master
MasterLastModified datetime Date/Time the master catalog entity was last modified
MasterLastModifiedBy string User that last modified the master catalog information (not replicated)
MasterNotes string Notes that are synchronized from the master catalog
Name string Software publisher's name
Notes string Customer's notes about the publisher. Not synchronized from the master catalog.
ObjectStateID numeric Internal ID that references the ObjectState entity (Foreign Key)
PredefinedByOctopus boolean True if publisher is to be synchronized with the master catalog
Url string Link to the website

References

Column Name Referenced Table Description
ObjectStateID ObjectState Object states for various OctoSAM entities

Referenced by

Table Column Name Description
Machine OperatingSystemSoftwarePublisherID Basic machine information. A machine is a physical or virtual device that can be scanned by OctoSAM Inventory. A machine can also be a mobile device such as a phone or tablet.
MachineOfficeAddIn SoftwarePublisherID Information about Microsoft Office add-ins registered on the machine (for all users)
MachineUserOfficeAddIn SoftwarePublisherID Information about Office Add-Ins installed for a specific user on a specific machine
SoftwareItem SoftwarePublisherID Software items hold customer specific information about software objects
SoftwarePackage SoftwarePublisherID A software package defines a logical software entity. A software package can own 0 to n software signatures.
SoftwarePublisherLegacyName SoftwarePublisherID Reserved for future use
SoftwarePublisherSwidRegid SoftwarePublisherID Reserved for future use
SoftwareSignature SoftwarePublisherID A software signature is a unique pattern detected by software scan, like a fingerprint that a particular software leaves on machines.