locked
SCCM 2012 report/query to list all the applications RRS feed

  • Question

  • Hi guys, I need a report or some way of listing all the applications available in my SCCM 2012 environment. I'm not after a list of apps that have been deployed as there are a number of applications which haven't been deployed yet.

    The list I'm after appears from within SCCM under "Software Library \ Application Management \ Applications". I need a list of all the apps under there.

    If I click on the search bar and select "All subfolders", hit enter, it shows all the apps, but how do I get this list exported?                           
    Thursday, April 4, 2013 10:37 PM

Answers

  • Ctrl+A, then Ctrl+C; paste to Excel or whatever program.
    Or query the database: select * from fn_ListLatestApplicationCIs(1033)

    Torsten Meringer | http://www.mssccmfaq.de

    • Proposed as answer by YPae Monday, April 8, 2013 5:14 AM
    • Marked as answer by Ronni PedersenMVP Monday, May 20, 2013 8:32 PM
    Friday, April 5, 2013 6:27 AM

All replies

  • Ctrl+A, then Ctrl+C; paste to Excel or whatever program.
    Or query the database: select * from fn_ListLatestApplicationCIs(1033)

    Torsten Meringer | http://www.mssccmfaq.de

    • Proposed as answer by YPae Monday, April 8, 2013 5:14 AM
    • Marked as answer by Ronni PedersenMVP Monday, May 20, 2013 8:32 PM
    Friday, April 5, 2013 6:27 AM
  • Thanks, didn't even think about copy/paste! Thanks.
    Sunday, April 7, 2013 11:29 PM
  • You can use the PowerShell Cmdlets in SCCM 2012.

    This should give you a text file with all the applications in your hierarchy.

    Get-CMApplication|SelectLocalizedDisplayName|Out-File'D:\ApplicationList.txt'-Encodingascii

    Wednesday, October 16, 2013 9:44 PM
  • I ran the  below query and exported to excel and i got all the applications and packages created on my SCCM environment. 

    SELECT   [Name],[Version] ,[Manufacturer] ,[SourceSite],[SourceDate] FROM [SCCMSQLDBNAME].[dbo].[SMSPackages_G]

    Regards,

    Santhosh B S


    Regards, Santhosh B S

    • Proposed as answer by EagleIJoe Wednesday, October 26, 2016 2:55 PM
    Tuesday, August 30, 2016 10:55 AM
  • Just being curious: why are you replying to a thread that's almost three years old and that's already answered?

    Torsten Meringer | http://www.mssccmfaq.de

    Tuesday, August 30, 2016 11:39 AM
  • I ran the  below query and exported to excel and i got all the applications and packages created on my SCCM environment. 

    SELECT   [Name],[Version] ,[Manufacturer] ,[SourceSite],[SourceDate] FROM [SCCMSQLDBNAME].[dbo].[SMSPackages_G]


    Keep in mind that it is NOT supported to query the tables directly.  You should use the SQL views instead.

    Garth Jones

    Blog: http://www.enhansoft.com/blog Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleased

    Tuesday, August 30, 2016 3:57 PM