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 = 30213
Order by smsgs.Time DESC

Results

sccm query computer name

 

SCCM Query Computer Name for OSD

Leave a Reply

Your email address will not be published. Required fields are marked *