Audit software installations r2

With this basic report you will be able to monitor any new applications installed and registrered in Add/Remove programs during the last 7 days on a client computer. 

Thanks to Claus Codam for helping out

The SQL code

The Report


By | 2009-11-02T09:23:32+00:00 November 2nd, 2009|Configuration Manager (SCCM)|17 Comments

About the Author:

Kent Agerlund

Microsoft Regional Director, Enterprise Mobility MVP. Microsoft Certified Trainer and Principal consultant. I have been working with Enterprise client management since 1992. Co-founder of System Center User Group Denmark in 2009.

Certified MCITP: Enterprise Administrator, MCSA+Messaing, and much more.

Member of: Microsoft Denmark System Center Partner Expert Team The Danish Technet Influencers program System Center Influencers Program.


  1. Amnon November 6, 2009 at 20:51 - Reply

    Great site, i am happy I found it..
    I am trying to figure out a way to find a if a specific service is NOT running, for example, if I have any windows 2003 machines that do not have SNMP installed?

  2. Kent Agerlund November 8, 2009 at 13:01 - Reply

    Hi Amnon,
    For a solution to your question check out this post written by Sherry Kissinger –

  3. jeremy pearce December 1, 2009 at 17:01 - Reply

    I have tried using the audit software sql code but get these errors
    Server: Msg 242, Level 16, State 3, Line 1
    The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
    Server: Msg 241, Level 16, State 1, Line 1
    Conversion failed when converting datetime from character string.
    any ideas on how this can be solved

  4. Kent Agerlund December 1, 2009 at 17:26 - Reply

    Send me a mail and I will return the report.mof file for you to import

  5. jeremy pearce December 2, 2009 at 11:27 - Reply

    Hi kent Did you get my mail?

  6. Jason Scott December 4, 2009 at 15:27 - Reply

    I’ve tried this but getting the error:

    Conversion failed when converting datetime from character string

    Any tweaks needed if the server has a non-US time/date format?

  7. Kent Agerlund December 5, 2009 at 14:25 - Reply

    the problem is the way data is stored in the db. I just found a few examples to illustrate it. I will try and find a work around.

  8. Sachin April 6, 2010 at 0:37 - Reply

    Hi Kent,

    I got same error as mentioned above as “Conversion failed when converting datetime from character string”

    Is there any way to fix this ?


  9. Tharanga Weerakkody June 17, 2010 at 8:02 - Reply

    Hi Kent,

    I get the above error mentioned above is there a fix for it?

  10. Kent Agerlund June 23, 2010 at 14:58 - Reply

    The report has been updated and will eliminate the errors you have seen

  11. TJ October 12, 2011 at 17:07 - Reply

    Could you modify the report to show just the count for software installed in the last 7 days. Example: Office 2007 – 34 installs

  12. CS January 12, 2012 at 12:58 - Reply

    When I execute this query I am getting this error message

    Msg 208, Level 16, State 1, Line 1
    Invalid object name ‘dbo.v_R_System’

  13. Travis February 18, 2012 at 21:54 - Reply

    Awesome, thanks for the info.
    Do you think there is any way to filter out what was installed by a task sequence?
    I am more interested in unapproved software installs.

  14. SoftHandheld June 28, 2012 at 19:12 - Reply

    Change “date” to “Datetime” to avoid: “Type date is not a defined system type. Error Number: -2147217900”

  15. charles June 28, 2012 at 22:23 - Reply

    is there a way to do this with status filter rules to send generate email for service desk each time software is installed?

  16. Santhosh Reddy September 19, 2013 at 9:42 - Reply

    This report doesn’t give the actual data. It shows if any update is installed for specific software as a software installed.

    For the result we can see that ..many office products which is wrong.

    How to avoid this issue.??

  17. Nice Post Your Blog Gained A New Fan 415255703 of times !! Great Post 🙂

Leave A Comment