How to determine who deleted what objects in the ConfigMgr 2012 console

~ Radu Tomoiaga | Support Engineer

 This article is a follow up to my original post titled How to determine who deleted what objects in the Configuration Manager console ( As in System Center 2012 Configuration Manager (ConfigMgr 2012), we have only SQL Reporting Services for the reporting component and I decided to write this article to fill in the blanks that were left behind from that first post.

Once in a while you may face an issue where you discover that some clients are missing in the Configuration Manager console and you’re not able to figure out what happened. You suspect that one of the ConfigMgr admins might have accidentally removed them but how can you figure out which one did what? Here’s a tip showing how you might be able to figure this out.

As in my original post, we want to look for a status message ID of 30066 or 30067. These mean that a user has either deleted a resource or all resources from a collection.


To do this we need to create a new report in Configuration Manager 2012 and we will use a custom SQL query to do it.

The SQL query is below:

SELECT     TOP (100) PERCENT dbo.v_StatMsgAttributes.AttributeValue AS 'User', dbo.v_StatusMessage.MessageID AS 'has deleted', dbo.v_StatMsgInsStrings.InsStrValue AS 'this computer', dbo.v_StatusMessage.RecordID , dbo.v_StatMsgAttributes.AttributeTime as 'on' FROM         dbo.v_StatusMessage INNER JOIN  dbo.v_StatMsgInsStrings ON dbo.v_StatusMessage.RecordID = dbo.v_StatMsgInsStrings.RecordID INNER JOIN dbo.v_StatMsgAttributes ON dbo.v_StatMsgInsStrings.RecordID = dbo.v_StatMsgAttributes.RecordID WHERE     ((dbo.v_StatusMessage.MessageID = 30066) OR (dbo.v_StatusMessage.MessageID = 30067))  AND (dbo.v_StatMsgInsStrings.InsStrValue LIKE @variable ) and (dbo.v_StatMsgInsStrings.InsStrIndex='2') ORDER BY 'this computer' DESC

We need to create a new report that will use the query above and it will look something like this:


When running the report we need to provide a search string which is the computer name of the client or clients that are missing:


This will show you the user name and the record they deleted. Below is another example with a % wildcard (which means all).


Hope this helps!

Radu Tomoiaga | Support Engineer | Microsoft

Get the latest System Center news on Facebook and Twitter:

clip_image001 clip_image002

System Center All Up:
System Center – Configuration Manager Support Team blog:
System Center – Data Protection Manager Team blog:
System Center – Orchestrator Support Team blog:
System Center – Operations Manager Team blog:
System Center – Service Manager Team blog:
System Center – Virtual Machine Manager Team blog:

Windows Intune:
WSUS Support Team blog:
The AD RMS blog:

App-V Team blog:
MED-V Team blog:
Server App-V Team blog:

The Forefront Endpoint Protection blog :
The Forefront Identity Manager blog :
The Forefront TMG blog:
The Forefront UAG blog:

Comments (3)
  1. Me says:

    Cool stuff

  2. says:

    there is already builtin report for this and you just need to enter the status message IDs to know who deleted what .default builtin report provides more information like what time user deleted the resource records from DB..more via

  3. Anonymous says:

    218 Microsoft Team blogs searched, 48 blogs have new articles. 97 new articles found searching from 25

Comments are closed.

Skip to main content