A complete list of query parameters and attributes
Query Parameters
The Query Builder has four main parameters that can be used to assemble a query.
Source Attributes
The Attribute parameters allow you to select the what data attribute(s) you would like to build your query around. Select the Attribute field to begin defining this parameter.
The attributes menu is broken down into several areas:
At the top of the menu, there are Devices and User tabs. The tab corresponding to the Live Inventory page you are in is selected by default. These tabs are primarily used for cross-asset searches, which will be covered in a later section.
The left-panel contains a list Sources. If needed, use this section to specify if you would only like to include assets from a specific Source in your rule's condition.
The right-panel is where you will select what data Attribute(s) you would like to build your query around.
Condition
The Condition parameter is used to define the condition an attribute must meet to meet a rule's requirements. Only assets and telemetry events that satisfy your conditions will be displayed in your results.
Value
Once you've selected an attribute and condition, you will need to define the Value you will be using to determine if a condition is satisfied. Please note that this field will not display when the Exists or Does not exist condition is selected, as the value is already defined in the condition itself.
In some instances, you may be asked to select a value from a pre-defined list of values. This is dependent on the attribute you have chosen.
Source Attribute Definitions
This Attributes list excludes Source-specific attributes. For questions about these attributes, please contact our Support team.
Please review the tables below for a list of Source attributes for each query builder in the Sevco platform. You will also find every possible condition and value that can be applied to an attribute.
Live Inventory
Devices
Identify
Attribute
Definition
Example
Correlation ID
A unique ID assigned to a Device asset that is used to correlate it with other assets
Correlation ID equals 8a580770-6ec9-480b-b5dc-50508fbc6749
Distinguished Name
The name typically associated with or issued by Directory ServiceSource integrations.
Distinguished Name equals cn=fcfdlfs,ou=dpnqvufst oz,ou=bluth dpnqvufst,dc=bluth-dp,dc=com
Hostname
Any device name associated with a Device asset. Unlike an Object ID this attribute can change
Hostname equals victorias-macbook-pro
Hostnames
Any device names associated with a Device asset. Unlike Hostname this attribute can have multiple values per Device.
Hostnames equals victorias-macbook-pro
Hostnames equals victorias-laptop
ID
The unique asset ID used to identify a Device asset
ID equals ec1652be6765fd1d34394255c1c9c1ee
MAC Addresses
Any MAC address associated with a Device asset
MAC Address equals 02:FF:00:BA:C0:39
MAC Manufacturers
The MAC manufacturer who manufactured a piece of network hardware on a Device asset
MAC Manufacturer equals Intel Corporate
Serial Number
The serial number corresponding to a Device asset
Serial Number equals 3N326311QW-01
Describe
Attribute
Definition
Example
Associated Usernames
Any usernames associated with a Device asset
Associated Usernames is like `john`*
Category
The Category that a Source integration falls under
Category equals Enterprise Endpoint
Controls
The Enterprise Endpoint subcategory that identifies the type of source control present for a Device asset
Controls equals Configuration Management
Exposure Status
The remediation status of an Device asset that has been impacted by an Exposure vulnerability. Learn more
Exposure ID equals Open
Number of Sources
The total number of Sources that have identified a Device asset
Number of Sources equals 3
OS
The operating system of a Device asset
OS Release equals Windows 11 Professional (x64)
OS Platform
The operating system platform of a Device asset
OS Platform equals Windows
OS Release
The specific identity of a Device asset's operating system (if available)
OS Release equals Windows 11 Professional
OS Version
The specific version of a Device asset's operating system.
OS Platform equals MacOS OS Version is like `12.6`*
Source
The name of the Source Integration that has detected a Device asset
Source equals Crowdstrike
Source Configuration
The configuration ID of a Source Integration that has detected a Device asset
Source Configuration equals Microsoft Azure(01234567-0123-abcd-abcd-0123456789ab)
Tag
Any Tag that has been applied to a Device asset
Tag equals Password Expired
Locate
Attribute
Definition
Example
Active Directory Domain
The specific Active Directory domain name assigned to a Device asset.
Active Directory Domains equals company.com
City
The City corresponding to a Device asset's External IP address
City equals Brooklyn
Country
The Country corresponding to a Device asset's External IP address
Country equals Italy
Country Code
The Country Code of the country corresponding to a Device asset's External IP address
Country Code equals DE
External IPs
The External IP Address associated with any network a Device asset has connected to
IP Address between 192.158.1.10 (and) 192.158.1.40
GeoIP Associated IP
An IP Address that has been mapped to a specific physical or geolocation using IP geolocation data services.
GeoIP Associated IP equals 142.250.0.0
Internal IPs
The Internal IP Address associated with any network a Device asset has connected to.
IP Address equals 192.168.1.1
IP
The IP Address of the Device asset on a network.
IP Address equals 10.10.4.217
IPs
The IP Addresses of the Device asset on a network. Unlike IP Address this attribute can have multiple values per Device.
IP Address equals 10.10.4.217
IP Address equals 10.10.4.218
Latitude
The latitude corresponding to a Device asset's External IP address
Latitude equals 37.4221° N
Locality
The city or town associated with a Device asset's geolocation record, determined by a Geolocation Associated IP
Locality equals Pittsburg
Longitude
The longitude corresponding to a Device asset's External IP address
Longitude equals 122.0841° W
Network Location
The Network type a Device asset is associated with: On Premise, Cloud, or Unknown (typically listed as a location if available)
Network Location does not equal Cloud
Region
The world region corresponding to a Device asset's External IP address
Region equals Europe
Time
Attribute
Definition
Example
First Observed Timestamp
The first time a Device asset was identified as present in your environment by a Source Integration
First Observed Timestamp is before 05/17/23 12:00 AM
Last Activity Timestamp
The last time a Device asset was identified as active on a network
Last Activity Timestamp is after 05/18/23 12:00 AM
Last Observed Timestamp
The last time a Device asset was identified as present in your environment by a Source Integration
Last Observed is before 3 days ago
OS End of Life Timestamp
The date and time that a Device asset's operating system enters an end-of-life state (is no longer supported by its vendor)
OS End of Life Timestamp is on or before 30 days ago
Users
Identify
Attribute
Definition
Example
Correlation ID
A unique ID assigned to a User asset that is used to correlate it with other assets
Correlation ID equals 8a580770-6ec9-480b-b5dc-50508fbc6749
The total number of Sources that have identified a User asset
Number of Sources equals 3
Source
The name of the Source Integration that has detected an User asset
Source equals Crowdstrike
Source Configuration
The configuration ID of a Source Integration that has detected an User asset
Source Configuration equals Microsoft Azure(01234567-0123-abcd-abcd-0123456789ab)
Tag
Any Tag that has been applied to a User asset
Tag equals Password Expired
Time
Attribute
Definition
Example
First Observed Timestamp
The first time a User asset was identified as present in your environment by a Source Integration
First Observed Timestamp is before 05/17/23 12:00 AM
Last Activity Timestamp
The last time a User asset was identified as active on a network
Last Activity is after 05/18/23 12:00 AM
Last Observed Timestamp
The last time a User asset was identified as present in your environment by a Source Integration
Last Observed is before 3 days ago
Vulnerabilities
Identify
Attribute
Definition
Example
Correlation ID
A unique ID assigned to softwareVulnerabilities to correlate them with the assets they are impacting
Correlation ID equals 8a580770-6ec9-480b-b5dc-50508fbc6749
CVE
Any Common Vulnerabilities and Exposures (CVE) codes associated with a software Vulnerability. Please note that some vulnerabilities may contain multiple CVEs or none at all.
CVE equals CVE-2018-17456
ID
The unique asset ID used to identify a software Vulnerability
ID equals 9e9d7ceab5ef9972ba54f926ff08d146
Name
The name of a potential software Vulnerability that a Source integration has identified on a Device asset
Vulnerability is like `Adobe Flash`*
Vuln ID
[Couldn't query for this in product]
[Couldn't query for this in product]
Score
Attribute
Definition
Example
CVSS Score
A numerical rating from 0.0-10.0 that indicates the severity of a known software Vulnerability. Learn more
CVSS Score is greater than 4.5
CVSS v2 Base Score
A numerical rating from 0.0-10.0 that indicates the severity of a known software Vulnerability, using an older version of the Common Vulnerability Scoring System (CVSS). This score is determined when a software Vulnerability is first discovered. Sevco uses this score in conjunction with other CVSS scores to determine the overall severity of a vulnerability. Learn more
CVSS v2 Base Score is greater than 6.9
CVSS v2 Temporal Score
A numerical rating from 0.0-10.0 that indicates the severity of a known software Vulnerability, using an older version of the Common Vulnerability Scoring System (CVSS). This score may change depending on factors such as the time a software Vulnerability has been present on a Device asset. Sevco uses this score in conjunction with other CVSS scores to determine the overall severity of a vulnerability. Learn more
CVSS v2 Temporal Score is greater than or equal to 7.0
CVSS v3 Base Score
A numerical rating from 0.0-10.0 that indicates the severity of a known software Vulnerability, using the most recent version of the Common Vulnerability Scoring System (CVSS). This score is determined when a software Vulnerability is first discovered. Sevco uses this score in conjunction with other CVSS scores to determine the overall severity of a vulnerability. Learn more
CVSS v3 Base Score is greater than 6.9
CVSS v3 Temporal Score
A numerical rating from 0.0-10.0 that indicates the severity of a known software Vulnerability, using the most recent version of the Common Vulnerability Scoring System (CVSS). This score may change depending on factors such as the time a software Vulnerability has been present on a Device asset. Sevco uses this score in conjunction with other CVSS scores to determine the overall severity of a vulnerability. Learn more
CVSS v3 Temporal Score is greater than 8.9
EPSS Percentile
The relative ranking from 0.0 - 1.0 of a software Vulnerability's EPSS score compared to all other scored vulnerabilities.
EPSS Percentile is greater than .75
EPSS Score
A score from 0.0 - 1.0 that indicates the likelihood of a specific software Vulnerability (CVE) being exploited within the next 30 days(Learn more)
EPSS Score is greater than .5
Severity
The severity of a software Vulnerability on a Device asset, determined by a Source integration's software vendor
Severity equals High
Describe
Attribute
Definition
Example
Categories
The Category(ies) that represents the area of security hygiene that a software Vulnerability negatively impacts
Categories equals MacOS X Local Security Checks
CWE ID
The Common Weakness Enumeration ID assigned to a specific type of software or hardware security weakness in the CWE catalog. Learn more
CWE ID equals CWE-89
CWE Name
The name of a Common Weakness Enumeration. Learn more
CWE Name equals Password in Configuration File
Number of Sources
The total number of Sources that have identified a software Vulnerability
Number of Sources equals 3
NVD Status
The status of a software Vulnerability in the National Vulnerability Database. (Learn more)
NVD Status equals Received
Port
The port that is being impacted by a software Vulnerability
Port equals 445
Product
The product name of a piece of hardware or software that is being impacted by a software Vulnerability
Product equals 1password
Product Type
The category that an impacted piece of hardware or software falls under.
Product Type equals Application
Protocol
The network protocol used by a software Vulnerability to gain access to a Device asset
Protocol equals TCP
Source
The name of the Source Integration that has detected software Vulnerability
Source equals Qualys AssetView
Source Configuration
The configuration ID of a Source Integration that has detected a software Vulnerability
The Group ID of one or more Source Records that have been identified as a duplicate of a Source record that has been successfully processed, aggregated, and correlated with other Source records to form a unified asset. Learn more
Duplicate Group ID equals 4b4653f7-672e-4c7e-8c23-3cef83839158
First Collected
When a Source Device was first collected by a specific Source integration
First Collected is on or before 07/31/22 12:00 AM
FQDN
The fully qualified domain name associated with a Source Device
FQDNexists
Hostname
Any device name associated with a Source Device. Unlike an Object ID this attribute can change.
Hostname equals victorias-macbook-pro
IP Address
The IP Address of the Source Device on a network.
IP Address equals 10.10.4.217
Last Activity
The last time a Source Device was identified as active on a network
Last Activity is after 05/18/23 12:00 AM
Last Observed
The last time a Source Device was identified as present in your environment by a Source integration
Last Observed is before 3 days ago
MAC Address
Any MAC Address associated with a Source Device
MAC Address equals 02:FF:00:BA:C0:39
Object ID
A permanent ID number that is assigned by a Source integration to identify a Source Device. Each Source assigns its own Object ID.
SentinelOneObject ID equals 0123456789101112131
ManageEngineObject ID equals 1312111019876543210
OS Platform
The operating system platform of a Source Device
OS Platform equals Windows
OS Release
The specific identity of a Source Device's operating system (if available)
OS Release equals Windows 10 Enterprise
Record State
A state that indicates whether or not a Source Record has been successfully processed, aggregated, and correlated with other Source records to form a unified asset. Learn more
Record State equals Active
Serial Number
The serial number corresponding to a Source Device
Serial Number equals 3N326311QW-01
Users
Attribute
Definition
Example Query
Duplicate Group ID
The Group ID of one or more Source Records that have been identified as a duplicate of a Source record that has been successfully processed, aggregated, and correlated with other Source records to form a unified asset. Learn more
Duplicate Group ID equals 4b4653f7-672e-4c7e-8c23-3cef83839158
Emails
The Email(s) that have been identified in a Source Record with a Source User
When a Source User was first collected by a specific Source integration
First Collected is on or before 07/31/22 12:00 AM
First Name
The first name associated with a Source User
First Name equals John
Last Activity
The last time a Source User was identified as active on a network
Last Activity is after 05/18/23 12:00 AM
Last Name
The last name associated with a Source User
Last Name equals Smith
Last Observed
The last time a Source User was identified as present in your environment by a Source integration
Last Observed is before 3 days ago
Last Updated
When information about a Source User was last updated by a Source integration
Last Updated is before 30 days ago
Object ID
A permanent ID number that is assigned by a Source integration to identify a Source User. Each Source assigns its own Object ID.
Object ID equals S-1-5-21-0490701075-1614801754-3360177619-3252
Password Changed
When a Source integration last identified a password change by a user
Password Change is less than 30 days ago
Record State
A state that indicates whether or not a Source Record has been successfully processed, aggregated, and correlated with other Source records to form a unified asset. Learn more
Record State equals Active
Usernames
The username(s) associated with a Source User for a specific Source integration
Username equals janesmith
Software
Attribute
Definition
Example Query
Hostname
Any device name associated with a Source Device. Unlike an Object ID this attribute can change.
Hostname equals victorias-macbook-pro
Software Name
The name of a piece of software that has been installed on a Source Device
Software Name equals 1Password
Vendor
The vendor of a piece of software that has been installed on a Source Device
Software Vendor equals WindowsUpdate
Version
The version of a piece of software that has been installed on a Source Device
Software Name equals 1Password, and Software Version is like 7.*
Vulnerabilities
Attribute
Definition
Example Query
Vulnerability
The name of a Source software vulnerability that has been identified by a Source integration
Vulnerability is like CVE-2013*
CVE
Any Common Vulnerabilities and Exposures (CVE) codes associated with a Source software Vulnerability. Please note that some software vulnerabilities may contain multiple CVEs or none at all.
CVE equals CVE-2018-17456
OS Platform
The operating system platform associated with a Device asset impacted by a software Vulnerability
OS Platform equals Windows
OS Release
The specific operating system release installed on a Device asset that is being impacted by a Source software Vulnerability
OS Release equals Windows 10 Enterprise
Severity
The severity of a Source software Vulnerability on a Device asset. Sevco determines severity of software vulnerabilities using the CVSS3 and CVSS2 scores assigned to it by your Source integration's software vendor.
Severity equals High
Categories
The Category(ies) that represents the area of security hygiene that a Source software Vulnerability negatively impacts
Categories equals MacOS X Local Security Checks
First Found
When a Source software Vulnerability was first identified on a Device asset by your Source integration
First Found is on or before 06/07/23 12:00 AM
Last Found
The last time a Source software Vulnerability was identified on a Device asset by your Source integration
Last Found is on or after 06/10/23 12:00 AM
CVSS v3 Base
A numerical rating from 0.0-10.0 that indicates the severity of a known software Vulnerability, using the most recent version of the Common Vulnerability Scoring System (CVSS). This score is determined when a software Vulnerability is first discovered. Sevco uses this score in conjunction with other CVSS scores to determine the overall severity of a vulnerability. Learn more
CVSS v3 Base is greater than 6.9
CVSS v3 Temporal
A numerical rating from 0.0-10.0 that indicates the severity of a known software Vulnerability, using the most recent version of the Common Vulnerability Scoring System (CVSS). This score may change depending on factors such as the time a software Vulnerability has been present on a Device asset. Sevco uses this score in conjunction with other CVSS scores to determine the overall severity of a vulnerability. Learn more
CVSS v3 Temporal is greater than 8.9
CVSS v2 Base
A numerical rating from 0.0-10.0 that indicates the severity of a known software Vulnerability, using an older version of the Common Vulnerability Scoring System (CVSS). This score is determined when a software Vulnerability is first discovered. Sevco uses this score in conjunction with other CVSS scores to determine the overall severity of a vulnerability. Learn more
CVSS v2 Base is greater than 6.9
CVSS v2 Temporal
A numerical rating from 0.0-10.0 that indicates the severity of a known software Vulnerability, using an older version of the Common Vulnerability Scoring System (CVSS). This score may change depending on factors such as the time a software Vulnerability has been present on a Device asset. Sevco uses this score in conjunction with other CVSS scores to determine the overall severity of a vulnerability. Learn more
CVSS v2 Temporal is greater than or equal to 7.0
Control Attributes
Control State Awareness and Tracking is Sevco’s ability to normalize control attributes to a common field in order to monitor and provide context about a critical control states that affects its ability to deliver the function of the control.
Attribute
Definition
Example
Encryption Status
The current status and level of encryption being provided by a Control
Encryption Status equals [status]
Management State
The state or condition of a specific Control that indicates whether a device can be managed or how it is currently being managed
Rapid7 InsightVM``Management State equals Agent
Protection State
The state or condition of a Control that indicates the level of or how a device is being controlled
Microsoft Defender for Endpoints``Protection State equals Prevention
Status
The state or condition of a specific Control that indicates whether a device is online, active, or able to be controlled
Microsoft Defender for Endpoints``Status equals Active
Query Conditions
Qualitative
Condition
Definition
Query Example
contains
An attribute value contains a string of alphanumeric characters somewhere within it
Usernames contains tori
does not contain
An attribute value does not contain a string of alphanumeric characters somewhere within it
Vendor does not contain Adobe
exists
An attribute exists for an asset, regardless of its value
MAC Addressexists
does not exist
An attribute value does not exist for an asset
Hostnamedoes not exist
is like
Specifies that an attribute value must begin with certain combination of alphanumeric characters
CrowdstrikeAgent Version is like `6.4`
Note: This field requires the use of at least one wildcard ()
is not like
Specifies that an attribute value must not start with certain combination of alphanumeric characters
CrowdstrikeAgent Version is not like `6.42`
Note: This field requires the use of at least one wildcard ()
Quantitative
Condition
Definition
Query Example
between
An attribute value is between two specified numerical values
IP Address between 192.158.1.10 (and) 192.158.1.40
equals
An attribute value is equal (identical) to a specified value
First Name equals John
does not equal
An attribute value is not equal (identical) to a specified value
Last Name does not equal Smith
is greater than
An attribute value is greater than a numerical value specified by the user
CVSS3 Base is greater than 9.1
is greater than or equal to
An attribute value is greater than or equal to a numerical value
CVSS3 Base is greater than or equal to 9.1
is less than
An attribute value is less than a numerical value
CVSS3 Temporal is less than 8.8
is less than or equal to
An attribute value is less than or equal to a numerical value
CVSS3 Base is less than or equal to 8.8
Time
Condition
Definition
Query Example
is after
An event has taken place after a specified time
Last Activity is after 3 days ago
is on or after
An event took place at or after a specified time. We recommend using this if you are trying to identify an event that may have taken place at a specific time of day.
Last Activity is on or after 05/18/23 12:00 AM
is before
An event took place before a specified time
Last Observed is before 3 days ago
is on or before
An event took place at or before a specified time. We recommend using this if you are trying to identify an event that may have taken place at a specific time of day.