Sign in
 
Home2012Previous VersionsLibraryForumsGallery
System Center TechCenter >
> 
> 
List out all software installed with corresponding hostname.

Answered List out all software installed with corresponding hostname.

  • Thursday, May 31, 2012 9:54 AM
     
     
    Sign In to Vote
    0

    Hi,

    I'm looking out for script where it lists out all software installed with corresponding hostname. ( finally I should get all organization host name with software installed in excel sheet )

    or

    atleast can somebody help me how to fetch certain software details with computer name & username.

    For example: If I want to get report of visual studio 2008 of all available machines along with computername & username, how do I generate.

    finally report should look like this

    Comptuername    username    Software
    testing1                 john1        Visual Studio 2008 Professional
    testing2                john2        Visual Studio 2008 Professional
    testing3                john3        Visual Studio 2008 Professional


     

All Replies

  • Thursday, May 31, 2012 11:18 AM
    Moderator
     
     
    Sign In to Vote
    0
    There is a built-in report for that already called "Computers with a specific product name and version"

    http://www.enhansoft.com/

     
  • Thursday, May 31, 2012 11:45 AM
     
     
    Sign In to Vote
    0

    thanks I saw that after posting, now Im expecting something else

    can we fetch more than 1 product name details @ a time.

    like below.

    Product Name: %visual%, %project%, %visio%

    Collection: All systems

     
  • Thursday, May 31, 2012 4:29 PM
    Moderator
     
     
    Sign In to Vote
    0

    Yes you can do that you will need to edit the query to look for each item. Something like this.

     Displayname0 like ‘%visio%’

    or displayname0 like ‘%project%’

    or displayname0 like ‘%visual%’

    http://www.enhansoft.com/

     
  • Friday, June 01, 2012 3:07 AM
     
     
    Sign In to Vote
    0

    somebody please help me with sql query, final out come should be like this


    Computer Name    username    Project                visio                 visual studio
    testing1                  john1    project 2007           visio 2010            visual studio 2010
    testing2                  john2                                    visio 2010           visual studio 2010
    testing3                  john3     project 2007        
    testing4                   john4                                                              visual studio 2010
    testing5                   john5    project 2007                                      visual studio 2010

     
  • Friday, June 01, 2012 10:53 AM
    Moderator
     
     
    Sign In to Vote
    0

    Putting the out into that format is not a simple task.

    Did you try to edit the query as I suggested above?

    I would show up in this format:

    Computer Name    username   

    testing1                  john1    project 2007          

    testing1                  john1    visio 2010

    testing1                  john1    visual studio 2010

    testing2                  john2    visio 2010           visual studio 2010

    testing2                  john2    visual studio 2010
    testing3                  john3    project 2007        

    http://www.enhansoft.com/

     
  • Friday, June 01, 2012 11:10 AM
     
     
    Sign In to Vote
    0
    even that is also fine, but im really new to to this query, could you please help me with complete sql query to fetch the result like above.
     
  • Friday, June 01, 2012 11:53 AM
    Moderator
     
     
    Sign In to Vote
    0

    Try this.

    http://tinyurl.com/c3vha4y

    http://www.enhansoft.com/

     
  • Friday, June 01, 2012 12:59 PM
     
     
    Sign In to Vote
    0
    I created the report query but getting page cannot be displayed.
     
  • Friday, June 01, 2012 1:05 PM
     
     
    Sign In to Vote
    0

    I want query where i can entire required multiple product atleast 5 products name( its not only visio or visual studio )

     
  • Friday, June 01, 2012 2:51 PM
     
     
    Sign In to Vote
    0

    I used your query & used with full product name, but for all  users against his hostname the product name is getting displayed twice.

    How to solve this.

    For ex:

    TESTPC1 JoHN1 Microsoft Visual Studio 2010 Professional - ENU   10.0.30319  
    TESTPC1  JOHN1 Microsoft Visual Studio 2010 Professional - ENU   10.0.30319  
    TESTPC1  JOHN1 Microsoft Office Project Standard 2007  12.0.6425.1000
    TESTPC1  JOHN1 Microsoft Office Project Standard 2007  12.0.6425.1000

     
  • Saturday, June 02, 2012 2:15 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    You shouldn’t get duplicated however Change

    Select

    To

    Select Distinct

    http://www.enhansoft.com/

    • Marked As Answer by Anil Kumar H Monday, June 04, 2012 8:26 AM
    •  
     
  • Saturday, June 09, 2012 4:44 AM
     
     Proposed Answer
    Sign In to Vote
    0

    Hello Anil,

    there are built in reports in SCCM 2007 using which you can find the information.

    You can get the info abt the host names with one particular software using this report

    Computers with specific software registered in Add Remove Programs 

    and also you can use this - Software 02D - Computers with a specific software product 

    You can get the list of softwares installed on a particular machine by using this report

    Software 02E - Installed software on a specific computer 

    You can use this report to target a collection to get the software details for the computers in that collection.

    Software 01A - Summary of installed software in a specific collection 

    let me know if this worked.

    Thanks

    Arvind

    • Proposed As Answer by ArvindBS Saturday, June 09, 2012 4:44 AM
    •