none
List of machines with Microsoft Office, Visio and Project installed

    Question

  • Hi SCCM friends!

    Asking for you help again. Could somebody help me to make a script to report the list of machines with Microsoft Office, Microsoft Visio, Microsoft Project.

    What is the best way to perform this?

    Friday, October 04, 2013 10:17 PM

All replies

  • There's a pre-defined reports which does what you want 'Computers with specific software registered in Add Remove Programs'
    (Note: this is collected by Hardware Inventory)
    Edit the below query if you want to cover office, Visio & Project at the same time
    Visio

    select SMS_R_System.NetbiosName,
    SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName from
    SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on
    SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceId =
    SMS_R_System.ResourceId where
    SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Visio%"

    Or Check this link for multiple program http://www.acupofit.com/2013/07/sccm-sql-query-multiple-program.html?m=1



    • Proposed as answer by Ayman Yassine Friday, October 04, 2013 11:42 PM
    • Unproposed as answer by Ayman Yassine Friday, October 04, 2013 11:42 PM
    • Edited by Ayman Yassine Friday, October 04, 2013 11:44 PM Add query code
    Friday, October 04, 2013 11:09 PM
  • The best way to handle this is to use 3 sub-select queries within the main query.

    http://www.enhansoft.com/

    Friday, October 04, 2013 11:10 PM
  • the query which was posted by ayman is WQL (collections) NOT SQL query(reports). do you want to find list of machines that has all 3 apps installed OR either of 3 apps installed ?

    use the SQL quires available here on to create one http://eskonr.com/2012/05/sccm-linked-report-ms-office-version-with-service-pack-installed-machines/



    Eswar Koneti | Configmgr blog: www.eskonr.com | Linkedin: Eswar Koneti | Twitter: Eskonr

    Saturday, October 05, 2013 2:13 AM
  • Hi! I need a report to find the list of machines with any of the 3 app iinstaled, Right now I´m traying with the SQL included in the link...
    Monday, October 07, 2013 3:51 PM
  • It didn't work, Actually I realized that the sql code always send me an error, so I have to use a WQL query. Could you help me? Thanks
    Tuesday, October 08, 2013 2:48 PM
  • What error did it give you?

    http://www.enhansoft.com/

    Tuesday, October 08, 2013 11:54 PM