Found a script that does fix the issue most of the time. Copy this to .vbs, run it on the client machine having issues.
Then restart the sms service and re-run your cycle (software update, etc).
Replace %Visio% with the software package you want to query for. In this example, the query returns all computers with a Net BIOS name that begins with ABC.
Device types are stored in the Configuration Manager database under the resource class sms_r_system and the attribute name Agent Edition.
Use the following query to return the Net BIOS name and software package name of all computers that have a specific software package installed.
This example displays all computers with a version of Microsoft Visio installed. Display Name from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS. Resource Id where SMS_G_System_ADD_REMOVE_PROGRAMS. Display Name like "%Visio%" Use the following query to return the Net BIOS name of all computers that begin with a specific string of characters.
Local\Legal\Computers, the following query: Since we only want the full OU path that the computer is in to be listed, we have to use MAX and LEN to get the OU that is the longest.
Further, we have to use a subquery, otherwise we will only get the computers in the report with the longest OU name instead of the longest OU name for each computer (in the example above, we would only get AD. You need the following query to give you just the longest OU for each computer: select sys. System_OU_Name0 from v_RA_System_System OUName ou2 where ou.
I have issues where the configuration manager CAS server is showing the clients as "Pending System Restart".
When you look at the client it's referring to, it shows the status as having been sent, and no status of restarting pending is shown in the registry (client was restarted anyway).
Netbios_Name0 AS [Computer Name], v_R_System_Valid. Resource_Domain_OR_Workgr0 AS [Domain/Workgroup], (select top 1 ou2. System_OU_Name0 from v_RA_System_System OUName ou2 where ou.