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.
WHEN -1073741824 THEN ‘Error’
WHEN 1073741824 THEN ‘Informational’
WHEN -2147483648 THEN ‘Warning’
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 = 30213
Order by smsgs.Time DESC
SCCM Query Computer Name for OSD
Founder of System Center Dudes. Based in Montreal, Canada, Senior Microsoft SCCM Consultant, 5 times Enterprise Mobility MVP. Working in the industry since 1999. His specialization is designing, deploying and configuring SCCM, mass deployment of Windows operating systems, Office 365 and Intunes deployments.