PENDING Create SCCM Collection of computers with WSUS scan error

[Marek Belan]

Hi all how can i create collection of computerrs with WSUS scan error?

I have this querey but i need to add computers to dynamic colection.

SELECT v_GS_COMPUTER_SYSTEM.Name0, v_UpdateScanStatus.LastScanState, v_UpdateScanStatus.LastScanTime, v_UpdateScanStatus.LastStatusMessageID, v_UpdateScanStatus.LastErrorCode, v_UpdateScanStatus.LastScanPackageLocation, v_UpdateScanStatus.LastScanPackageVersion, v_UpdateScanStatus.LastWUAVersion,

v_UpdateScanStatus.LastLocalChangeTime

FROM v_UpdateScanStatus INNER JOIN

v_GS_COMPUTER_SYSTEM ON v_UpdateScanStatus.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceID

where LastErrorCode <> 0

order by Name0

 

[Garth]

you can can do that. Use v_collection for that.

Here is list of supported view. https://docs.microsoft.com/en-us/me...ardware-inventory-views-configuration-manager

This blog will give more details. https://www.recastsoftware.com/resources/how-to-create-a-collection-prompt-query/

 

[Marek Belan]

you can can do that. Use v_collection for that.

Here is list of supported view. https://docs.microsoft.com/en-us/me...ardware-inventory-views-configuration-manager

This blog will give more details. https://www.recastsoftware.com/resources/how-to-create-a-collection-prompt-query/

Can you show me WQL for UpdateScanStatus i really dont understat where to find this.

 

[Garth]

Can you show me WQL for UpdateScanStatus i really dont understat where to find this.

ok I get it. You want to create a collection, not add a collection to the SQL query.

I think what you are looking for is this one. You can see the Last enforcement state message ID
sms_updatecompliancestatus