Close Menu
    Facebook X (Twitter) Instagram
    Sunday, October 12
    X (Twitter) LinkedIn Reddit RSS
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»CM2012»SCCM Configmgr 2012 way to find Who Created modified Deleted the collection using SSRS Reports

    SCCM Configmgr 2012 way to find Who Created modified Deleted the collection using SSRS Reports

    Eswar KonetiBy Eswar KonetiAugust 23, 1:51 pm2 Mins Read CM2012 17,919 Views
    Share
    Facebook Twitter LinkedIn Reddit

    Quick Post: There was a question on TechNet forum asking,about who created the collection ,More read http://social.technet.microsoft.com/Forums/en-US/e5ea645e-84ec-49ce-82f5-e5d92b0f49a5/details-on-sccm-collection-creation?forum=configmanagergeneral

    I have seen few cases in Configmgr 2007 and less in Configmgr 2012 due to RBA ,that Configmgr guys will try to do something on collection but it ends at something that causes the resources to disappear from Configmgr database and later you know the consequences from top management. The easiest way to get the resources into Configmgr is,to run the discovery.

    Recently peter posted a blog about Who created that deployment and who deleted that deployment but these posts mainly focus on the deployment part using Reports.

    Through this post,i will provide you the information about collections like who created,who Modified ,who deleted and who deleted resources from the collection etc using Reports.

    Unlike Configmgr 2007 ,Configmgr 2012 also have few ways to get the information about this 1) using Status messages queries 2 ) Default reports 3) Using SQL queries

    I always prefer to use the Default report in Configmgr called ‘All messages for a specific message ID’ under status messages folder from your Configmgr SSRS reports folder to know who created ,deleted as other 2 methods are little complicated to search for the required information(compared to reports) and to write SQL queries.

    So coming to the subject,you can run the default report but you need to know the description of the status message ID what you are looking for.

    You can use below status message ID’s to know who did what on collections.

     

    Message ID

                                                                 Description

    30015

    User "<>" created a collection named "Coll Name" (CollID)

    30016

    User "<>" modified the Collection Properties for a collection named "Coll Name" (CollID)

    30017

    User "<>" deleted a collection named "Coll Name" (CollID)

    30067

    User "<>" deleted all of the resources that belong to collection "Coll Name" (CollID)

    30104

    User "<>" requested that the membership be refreshed for collection "Coll Name" (CollID)

    30107

    User "<>" requested that the CCRs be generated for collection "Coll Name" (CollID)

    30066

    User "<>" deleted a discovered resource named "ComputerName" ResourceID

     

    Report Results for Who deleted what Collections ?

    image

    If you are looking for information about Configmgr 2007,refer this post http://blogs.technet.com/b/configurationmgr/archive/2013/10/01/how-to-determine-who-deleted-what-objects-in-the-configuration-manager-console.aspx

    Hope it helps.

    CM12 Collections Configmgr 2012 deleted modified SCCM 2012 SSRS Report who created collection
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    SCCM SQL Report – Compare Installed Apps on TWO Different Computers

    July 13, 10:35 am

    Optimize Your Intune Workflow with a Powerful Browser Extension

    March 22, 10:39 am

    Migrate Microsoft 365 Updates from SCCM/MECM to Intune for Co-Managed Devices

    February 11, 9:50 pm

    7 Comments

    1. Dominique Duchemin on April 17, 2019 6:29 AM

      Hello,
      Is there a trace of old-new / before-after record in case of modification?
      Thanks,
      Dom

      Reply
    2. Mohan Reddy on April 11, 2018 4:14 PM

      300016 - User "" modified the Collection Properties for a collection named "Coll Name" (CollID)
      300017 - User "" deleted a collection named "Coll Name" (CollID)
      300067 - User "" deleted all of the resources that belong to collection "Coll Name" (CollID)

      Message ID's are 30016, 30017, 30067.. Please update it

      Reply
      • Eswar Koneti on July 8, 2018 8:46 PM

        Hi Mohan,
        thanks for pointing out the extra 0 ,appreciate it. I have updated the post now.

        Regards,
        Eswar

        Reply
    3. SCCM Admin on December 6, 2016 2:34 AM

      Thanks for your chart however you have a typo in the first entry id, 30015 should be 300015.

      Reply
      • Eswar Koneti on December 21, 2016 1:50 PM

        Hi,
        I see it is 30015 and is correct.Where do you see 300015 ? did you get any results with 300015 ?

        Regards,
        Eswar

        Reply
    4. saritha on September 17, 2014 5:09 PM

      Hi Eswar,

      I want to run a script for given condition, please help me...........

      I deployed sccm 2012 client using group policy, it should run in end user machine, if the client is not present or if the client version is lower than present version.

      Thanks in advance
      Saritha

      Reply
      • Eswar Koneti on September 19, 2014 1:42 PM

        i would recommended to use /look at Jason sandys client start-up script ,it really works good http://blog.configmgrftw.com/configmgr-client-startup-script/

        Reply

    Leave a ReplyCancel reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Sign Up

    Get email notifications for new posts.

    Author

    I’m Eswar Koneti ,a tech enthusiast, security advocate, and your guide to Microsoft Intune and Modern Device Management. My goal? To turn complex tech into actionable insights for a streamlined management experience. Let’s navigate this journey together!

    Support

    Awards

    Archives

    © Copyright 2009-2025 Eswar Koneti, All rights reserved.

    Type above and press Enter to search. Press Esc to cancel.