PENDING SQL Query to know list of installed patches

[syed sameer]

Hi Prajwal

can u provide me SQL Query to know list of installed patches in particular client machine ?

 

[Garth]

What is wrong with the built-in reports for this?

 

[syed sameer]

Hi Garath
Can you guide me which built in report need to open to know list of installed patches

 

[Garth]

Compliance 5 - Specific computer

 

[Edy]

Get-WmiObject -Query "SELECT * FROM CCM_UpdateStatus" -Namespace "root\ccm\SoftwareUpdates\UpdatesStore" | where {$_.status -eq "Installed"} | Select-Object title

 

[Noor Alam]

Get-WmiObject -Query "SELECT * FROM CCM_UpdateStatus" -Namespace "root\ccm\SoftwareUpdates\UpdatesStore" | where {$_.status -eq "Installed"} | Select-Object title

where i have to mention the system hostname in this query ?

 

[Garth]

where i have to mention the system hostname in this query ?

That is not a Sql query. What is wrong with the built in report for this?