SCCM Query to identify who imported OSD Computers

Benoit LecoursSCCM, SQL, SSRSLeave a Comment

This query might be helpful to know who imported a specific computer. You can view this information in the Status Message Queries and search for MessageID #30213. But this query will target only the information you need. You can use this query to create a report or directly in SQL MS. select CASE smsgs.Severity WHEN -1073741824 THEN ‘Error’ WHEN 1073741824 THEN ‘Informational’ WHEN -2147483648 THEN ‘Warning’ ELSE ‘Unknown’ END As ‘SeverityName’, smsgs.MessageID, smsgs.Time, smwis.InsString1 as Username, smwis.InsString4 as ComputerName, smwis.InsString5 as MAC from v_StatusMessage smsgs join v_StatMsgWithInsStrings smwis on smsgs.RecordID = smwis.RecordID join v_StatMsgModuleNames modNames on smsgs.ModuleName = modNames.ModuleName where smsgs.MessageID … Read More

SCCM 2007 : Hardware Inventory Failed at the Central (Badmif)

Nicolas PilonSCCMLeave a Comment

I recently face an issue regarding replication between primary and central site. The hardware inventory information was push to the primary but not to the central. We have SCCM 2007 R3 Build 6487 installed. Client version is 4.00.6487.2207. The problem occured not on all resources. Symptoms Client side: No error in the inventoryagent.log. Sucessfully sent report to primary. Primary side: No error in the dataldr.log, no badmif and SQL database contains HW inventory information. Central side: Error in the dataldr.log with a badmif. SQL databse don’t contains HW inventory information. Full resync HW inventory:  No sign in log on the central Delta HW inventory: Badmif at the … Read More