I come from Singapore but find myself now living and working in the Netherlands, specialising in SMS 2003 / Configmgr 2007. I enjoy working and connecting people with computers and I hope I can share as much information as I can here through this blog.
“Computers do not just work like that, at the press of a button. From the moment a computer is switched on in your office, magic happens. That’s why you need an IT department and they do more than crawling under your desk to plug in that wire you kicked out.”
Had to troubleshoot various client issues today with regard to discovery methods and this query came in handy. You can run this against the primary site SQL database to find out the discovery methods (i.e. AD System discovery, heartbeart etc) that are being found by a specific client in SCCM 2007.
select ssaa.SMS_Assigned_Sites0, sd.Itemkey, sd.name0, sd.SMS_Unique_Identifier0, sd.client0, sd.client_Type0,dia.AgentSite, dia.AgentTime, a.AgentName from system_disc as sd join discitemagents as dia ondia.itemkey = sd.itemkey join agents as a ondia.Agentid = a.Agentidjoin System_SMS_Assign_ARR as ssaaon ssaa.itemkey = sd.itemkeywhere name0 = '<computername>'