SCCM and database not in sync
I am running Windows 2008 server 32Bit, SCCM2007 SP1 and SQL 2005 SP3. I have several clients that are showing up in the SCCM console but for some reason are not in the SCCM database. I uninstalled the client (to include deleting the cert and deleting the smscfg.ini file) on one of the problem clients and removed it from the SCCM console. I re-installed and approved on the SCCM console. The server is still not in the database. Any suggestions would be appreciated.
February 4th, 2010 7:33pm
If you see a client in the console it is definitely in the database. Period.
Free Windows Admin Tool Kit Click here and download it now
February 4th, 2010 9:54pm
I agree that is how it should be. Maybe i am querying it wrong, but the query can pull up all my other clients.
Select * FROM v_R_System sys
JOIN
v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
JOIN
v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
WHERE
sys.Netbios_Name0= 'myserver'
February 4th, 2010 9:59pm
You just need this:Select * FROM
v_R_System sys WHERE sys.Netbios_Name0= 'myserver'
Free Windows Admin Tool Kit Click here and download it now
February 4th, 2010 10:40pm
That worked.I was trying to run reports on installed software and noticed servers missing on the report, guess I am having a software scan issue. Appreciate the help.
February 4th, 2010 11:08pm
Glad to be of help :)By the way, the content of Add/remove programs is collected by hardware inventory, not software inventory.
Free Windows Admin Tool Kit Click here and download it now
February 4th, 2010 11:15pm