WQL query for ARP Display name

ARP display name, add remove

SMS_R_SYSTEM.ItemKey, SMS_R_SYSTEM.DiscArchkey, SMS_R_SYSTEM. Namee, SMS_R_SYSTEM. SMS_Unique Ident ifiere, SMS_R_SYSTEM. Resource_Domain_OR_Workgre, SMS_R_SYSTEM.Cliente from VSMS_R_System AS SMS_R_System INNER JOIN Add_Remove_Programs_DATA AS __System_ADD_REMOVE_PROGRAMSO ON System_ADD_REMOVE_PROGRAMSØ.Machine ID = SMS_R_System. Itemkey where __System_ADD_REMOVE_PROGRAMS.DisplayName00 = N'Desk Utilization Monitoring Client'

ARP display name, add remove64bit

select all

SMS_R_SYSTEM. ItemKey, SMS_R_SYSTEM.DiscArchKey, SMS_R_SYSTEM. Name, SMS_R_SYSTEM. SMS_Unique Ident ifiere, SMS_R_SYSTEM. Resource_Domain_OR_Workgro, SMS_R_SYSTEM. Cliente from VSMS_R_System AS SMS_R_System where (SMS_R_System. ItemKey not in (select all

__tem_ADD_REMOVE_PROGRAMS_640.Machine ID from Add_Remove_Programs_64_DATA AS __tem_ADD_REMOVE_PROGRAMS_640 where __tem_ADD_REMOVE_PROGRAMS_640.DisplayName00 = N' Lumension

Endpoint Security Client') AND SMS_R_System. Itemkey not in (select all __System_ADD_REMOVE_PROGRAMSØ.Machine ID from Add_Remove_Programs_DATA AS __System_ADD_REMOVE_PROGRAMSO where __System_ADD_REMOVE_PROGRAMSO.DisplayName00 = N' Lumension Endpoint Security Client'))

Read More

SCCM Patch scan Status SQL Query

Select

Distinct VRS.Name0 as 'MachineName',

Os.Caption0 as 'OperatingSystem',

St.SystemType00 as 'OSType',

VRS.AD_Site_Name0 as 'ADSite',

VRS.Full_Domain_Name0 as 'Domain',

VRS.User_Name0 as 'UserName',

UI.ArticleID as 'ArticleID',

UI.BulletinID as 'BulletinID',

UI.Title as 'Title',

CASE WHEN UCS.Status = 2 THEN 'Required'

WHEN UCS.Status = 3 THEN 'Installed'

ELSE 'Unknown' END AS 'KBStatus',

UI.InfoURL as 'InformationURL'

FROM v_UpdateComplianceStatus UCS

INNER JOIN v_UpdateInfo UI ON UCS.CI_ID = UI.CI_ID

INNER JOIN v_CICategories_All CIC ON UI.CI_ID = CIC.CI_ID

INNER JOIN v_CategoryInfo CI ON CIC.CategoryInstanceID = CI.CategoryInstanceID

INNER JOIN v_R_System VRS ON UCS.ResourceID = VRS.ResourceID

INNER JOIN v_GS_OPERATING_SYSTEM Os on UCS.ResourceID = Os.ResourceID

INNER JOIN Computer_System_DATA St on UCS.ResourceID = st.MachineID

INNER Join v_FullCollectionMembership Col on UCS.ResourceID = Col.ResourceID

WHERE 

--Col.CollectionID = xxxxxxxx and 

VRS.Name0 in(' xxx', 'xxx') and

UI.articleid in ('4561600','4557957','4025338')

Read More

SCCM Agent WMIC commands

Hardware Inventory :

WMIC /namespace:\\root\ccm path sms_client CALL TriggerSchedule "{00000000-0000-0000-0000-000000000001}" /NOINTERACTIVE

Software Inventory :

WMIC /namespace:\\root\ccm path sms_client CALL TriggerSchedule "{00000000-0000-0000-0000-000000000002}" /NOINTERACTIVE

Machine Policy Retrieval Cycle:

WMIC /namespace:\\root\ccm path sms_client CALL TriggerSchedule "{00000000-0000-0000-0000-000000000021}" /NOINTERACTIVE

Software Update Scan Cycle :

WMIC /namespace:\\root\ccm path sms_client CALL TriggerSchedule "{00000000-0000-0000-0000-000000000113}" /NOINTERACTIVE

Software Updates Assignments Evaluation Cycle :

WMIC /namespace:\\root\ccm path sms_client CALL TriggerSchedule "{00000000-0000-0000-0000-000000000108}" /NOINTERACTIVE

Hard reset client policy :

WMIC /Namespace:\\root\ccm path SMS_Client CALL ResetPolicy 1 /NOINTERACTIVE

Trigger DataDiscoverRecord (DDR) update:

WMIC /namespace:\\root\ccm path sms_client CALL TriggerSchedule "{00000000-0000-0000-0000-000000000003}" /NOINTERACTIVE

For Powershell usage: Invoke-WMIMethod -ComputerName $Server -Namespace root\ccm -Class SMS_CLIENT -Name TriggerSchedule "{00000000-0000-0000-0000-000000000###}"

Trigger Codes:

{00000000-0000-0000-0000-000000000001} Hardware Inventory

{00000000-0000-0000-0000-000000000002} Software Inventory

{00000000-0000-0000-0000-000000000003} Discovery Inventory

{00000000-0000-0000-0000-000000000010} File Collection

{00000000-0000-0000-0000-000000000011} IDMIF Collection

{00000000-0000-0000-0000-000000000012} Client Machine Authentication

{00000000-0000-0000-0000-000000000021} Request Machine Assignments

{00000000-0000-0000-0000-000000000022} Evaluate Machine Policies

{00000000-0000-0000-0000-000000000023} Refresh Default MP Task

{00000000-0000-0000-0000-000000000024} LS (Location Service) Refresh Locations Task

{00000000-0000-0000-0000-000000000025} LS (Location Service) Timeout Refresh Task

{00000000-0000-0000-0000-000000000026} Policy Agent Request Assignment (User)

{00000000-0000-0000-0000-000000000027} Policy Agent Evaluate Assignment (User)

{00000000-0000-0000-0000-000000000031} Software Metering Generating Usage Report

{00000000-0000-0000-0000-000000000032} Source Update Message

{00000000-0000-0000-0000-000000000037} Clearing proxy settings cache

{00000000-0000-0000-0000-000000000040} Machine Policy Agent Cleanup

{00000000-0000-0000-0000-000000000041} User Policy Agent Cleanup

{00000000-0000-0000-0000-000000000042} Policy Agent Validate Machine Policy / Assignment

{00000000-0000-0000-0000-000000000043} Policy Agent Validate User Policy / Assignment

{00000000-0000-0000-0000-000000000051} Retrying/Refreshing certificates in AD on MP

{00000000-0000-0000-0000-000000000061} Peer DP Status reporting

{00000000-0000-0000-0000-000000000062} Peer DP Pending package check schedule

{00000000-0000-0000-0000-000000000063} SUM Updates install schedule

{00000000-0000-0000-0000-000000000071} NAP action

{00000000-0000-0000-0000-000000000101} Hardware Inventory Collection Cycle

{00000000-0000-0000-0000-000000000102} Software Inventory Collection Cycle

{00000000-0000-0000-0000-000000000103} Discovery Data Collection Cycle

{00000000-0000-0000-0000-000000000104} File Collection Cycle

{00000000-0000-0000-0000-000000000105} IDMIF Collection Cycle

{00000000-0000-0000-0000-000000000106} Software Metering Usage Report Cycle

{00000000-0000-0000-0000-000000000107} Windows Installer Source List Update Cycle

{00000000-0000-0000-0000-000000000108} Software Updates Assignments Evaluation Cycle

{00000000-0000-0000-0000-000000000109} Branch Distribution Point Maintenance Task

{00000000-0000-0000-0000-000000000110} DCM policy

{00000000-0000-0000-0000-000000000111} Send Unsent State Message

{00000000-0000-0000-0000-000000000112} State System policy cache cleanout

{00000000-0000-0000-0000-000000000113} Scan by Update Source

{00000000-0000-0000-0000-000000000114} Update Store Policy

{00000000-0000-0000-0000-000000000115} State system policy bulk send high

{00000000-0000-0000-0000-000000000116} State system policy bulk send low

{00000000-0000-0000-0000-000000000120} AMT Status Check Policy

{00000000-0000-0000-0000-000000000121} Application manager policy action

{00000000-0000-0000-0000-000000000122} Application manager user policy action

{00000000-0000-0000-0000-000000000123} Application manager global evaluation action

{00000000-0000-0000-0000-000000000131} Power management start summarizer

{00000000-0000-0000-0000-000000000221} Endpoint deployment reevaluate

{00000000-0000-0000-0000-000000000222} Endpoint AM policy reevaluate

{00000000-0000-0000-0000-000000000223} External event detection

Read More