Client from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM. Name from SMS_R_System inner join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS. This could generally happend if you have an unoptimized query , querying big tables like 'software files.' There are multiple ways to look at it including with sql enabled logging. you have some experience with SQL you could try looking if the Query is a long runner. Operating System Nameand Version like "Microsoft Windows NT Workstation 6.0%" select SMS_R_SYSTEM. Operating System Nameand Version like "Microsoft Windows NT Workstation 5.1%" select distinct SMS_G_System_COMPUTER_SYSTEM. Model from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM. Operating System Nameand Version like "select SMS_R_SYSTEM.
This might happen if when the collection was deleted there was a backlog on the collection evaluator or it was stopped and thus not able to process the file at that time.If you find that your System Center Configuration Manager 2007 (Config Mgr 2007) or System Center 2012 Configuration Manager (Config Mgr 2012) collections are updating slowly or maybe even not updating at all, take a look at your file.You may find that there are many entries such as ‘’ alerts.Use the SQL Management Studion and Connect to your SCCM/SMS Database insert into #Coll Temp (Machine ID, Architecture Key, Name, SMSID, Domain , Is Client) select all SMS_R_SYSTEM. Hi everyone Roberto Rodriguez here with a Configuration Manager support tip for you. Operating System Nameand Version like "Microsoft Windows NT Server%" OR SMS_R_System. Operating System Nameand Version like "Microsoft Windows NT Advanced Server 10.0%" select SMS_R_SYSTEM. ADSite Name = "PS1" AND client=1 select SMS_R_SYSTEM. Client Version like "4.00.6487.2187" or SMS_R_System. Client Version like "4.00.6487.2157" select SMS_R_SYSTEM. To fix this, check and see if the file mentioned is in the like it is in the screen shot below.If this file exists and you no longer need this update, simply move the file to a temp location and delete it.