Overview
Examine the properties and structure of WMI classes to understand available data fields and plan targeted queries. This command is essential for understanding class schemas before performing detailed data extraction.Syntax
Parameters
The WMI class to examine (e.g., “SMS_R_System”)
The IP address, FQDN, or NetBIOS name of the SMS Provider to connect to
The three-character site code (e.g., “PS1”)
Examples
Required Permissions
SMS Admins local group membership on the SMS Provider server
Output Format
The command displays properties with their data types and characteristics:Property Analysis
Data Types
Data Types
String Types:
- Text data and identifiers
- User and system names
- Network addresses and paths
- UInt32: Resource IDs and counts
- DateTime: Timestamps and dates
- Boolean: True/false flags
- String arrays: Multiple values (IP addresses, software)
- Numeric arrays: Collections of numbers
Property Characteristics
Property Characteristics
Key Properties:
- Unique identifiers for instances
- Used for object relationships
- Critical for data correlation
- Optimized for searching and filtering
- Better query performance
- Common filter targets
- Required properties always have values
- Optional properties may be null
- Impact filtering and data quality
Common Class Properties
SMS_R_System Properties
SMS_R_System Properties
Identity Properties:
Name: NetBIOS computer nameResourceID: Unique system identifierSMSID: SCCM unique identifier
LastLogonUserName: Last logged-on userLastLogonTimestamp: Last logon timePrimaryUserName: Primary user assignment
IPAddresses: Network IP addressesMACAddresses: Hardware MAC addressesIPSubnets: Network subnet information
OperatingSystemNameandVersion: OS detailsArchitecture: System architectureDomain: Active Directory domain
SMS_Admin Properties
SMS_Admin Properties
Account Information:
LogonName: Domain\usernameDisplayName: Friendly display nameAdminSid: Security identifier
RoleNames: Assigned security rolesPermissions: Effective permissionsSecurityScopes: Administrative scopes
CreatedDate: Account creationLastModifiedDate: Last modificationSourceSite: Site where defined
SMS_Collection Properties
SMS_Collection Properties
Collection Identity:
Name: Collection display nameCollectionID: Unique identifierComment: Description or notes
CollectionType: 1 (User) or 2 (Device)MemberCount: Number of membersIsBuiltIn: Microsoft default collection
LimitToCollectionID: Parent collectionRefreshType: Refresh schedule typeLastRefreshTime: Last refresh timestamp
Query Planning
Property Selection
Property Selection
Essential Properties:
- Key properties for identification
- Security-relevant properties
- Relationship properties for correlation
- Select only needed properties
- Use indexed properties for filtering
- Avoid large array properties when possible
Filtering Strategies
Filtering Strategies
String Properties:
- Use LIKE for pattern matching
- Case-insensitive comparisons
- Wildcard and substring matching
- Range comparisons
(>, <, BETWEEN) - Equality and inequality tests
- NULL checks for optional properties
- Date range filtering
- Recent activity analysis
- Timeline-based queries
Use Cases
Query Development
Query Development
Schema Understanding:
- Identify available data fields
- Understand data types and formats
- Plan efficient query structures
- Verify expected properties exist
- Understand property relationships
- Validate data quality assumptions
Security Analysis
Security Analysis
Sensitive Data Identification:
- User authentication properties
- Network configuration data
- Administrative role information
- System identification details
- Available data for reconnaissance
- Properties useful for targeting
- Information disclosure opportunities
Property Examples by Category
Related Commands
get classes- List available WMI classesget class-instances- Query class instances with discovered propertieslocal class-properties- Examine local WMI class propertieslocal query- Execute queries using property information