PENDING Clearing Required PXE Deployments

[RJONA]

Hey All,

Well aware that I can Clear Required PXE Deployments from the console itself, But is there a way that I can clear it using a SQL Query?

 

[Prajwal Desai]

You may try this :-

$Computer = "Server1"
$ResourceIDQuery = Get-WmiObject -Namespace "ROOT\SMS\SITE_TRT" -class "SMS_R_System" -Filter "NAME='$Computer'" -ErrorAction STOP
$Array = (,$ResourceIDQuery.ResourceID)
Invoke-WmiMethod -Namespace "ROOT\SMS\SITE_TRT" -class "SMS_Collection" -name ClearLastNBSAdvForMachines -ArgumentList (,$Array)