I recently had a problem with client inventory data not being present in the SCCM database. I was making a query to find machines running Windows XP with Service Pack 3, and it only reported back 4 or 5 clients, even though I knew that a lot more had the service pack installed.
I checked the logs on some of my clients and they seemed to report both hardware and software inventory just fine, and sent it to my management point. I checked the logs on my SCCM server and every time i recieved the inventory report from clients I got an SQL error saying that the rows in my table could not be updated. This lead me to believe that the client had never been in the table, and as suspected, my OperatingSystem table (the table that contains data about a client operating system, and in this case what service pack is installed) only had a few machines present. Somehow my management point had stopped inserting data into the tables.
I resolved this issue simply by removing and re-installing my management point role on my SCCM server, but it lead to several hours of head-scratching!
simple question:
Can you publish the query to determine windows xp sp3 clients?
thanks in advance
Andy
@andy
Of course. The following query will find Windows XP machines with Service Pack 3. You can tune it to receive the information you need.
select SMS_R_System.Name, SMS_R_System.SMSAssignedSites, SMS_R_System.IPAddresses, SMS_R_System.IPSubnets, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.LastLogonUserDomain, SMS_R_System.LastLogonUserName, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceId, SMS_R_System.NetbiosName, SMS_G_System_OPERATING_SYSTEM.CSDVersion from SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion like “%Workstation 5.1%” and SMS_G_System_OPERATING_SYSTEM.CSDVersion = “Service Pack 3″
Didn’t work, got a syntax error
Seems my WordPress outputs ‘ as “. Simply replace the quoations with ‘.
Thanks!
Worked like a charm.
Hi there,
” I checked the logs on my SCCM server and every time i recieved the inventory report from clients I got an SQL error saying that the rows in my table could not be updated”
Do you remember the log file name?
Thank you in advance,
Marco
I don’t recall which log file it was, but I suspect it could be Sinvproc.log. As the documentation states “Records client software inventory data processing to the site database in Microsoft SQL Server. “