none
How to Know Total of Microsoft Lync Installed on Computers in SCCM 2012

    Question

  • Dear,

    I have installed Microsoft Lync 2010 and Lync 2013 on computers in my company and I have different types of version like 32 and 64 bits, I want to make query in SCCM 2012 to tell me the number of Microsoft Lync Installed on machines in my company, is there a best way to do this I need your advice..

    Thanks

    Monday, September 30, 2013 8:49 AM

Answers

  • Hi Dana,

    I'm fern, not Garth...

    Yes, the query provided on the previous reply is for both 31/64 bit. As you can see from the query, there is an "OR" statement..

    • "select SMS_G_System_ADD_REMOVE_PROGRAMS" : this is for 32 bit
    • "select SMS_G_System_ADD_REMOVE_PROGRAMS_64" : this is for 64 bit

    Always test to ensure that the code is returning accurate results.

    • Marked as answer by Dana.Kadi Tuesday, October 01, 2013 1:26 PM
    Tuesday, October 01, 2013 12:36 PM

All replies

  • Have you looked at the built-in report they can tell you this information.

    http://www.enhansoft.com/

    Monday, September 30, 2013 10:10 AM
  • Yes but it not give me the report it is empty..
    Monday, September 30, 2013 10:27 AM
  • I personally like the Asset Intelligence feature. I often run report "Software 06A - Search for installed software". 

    Monday, September 30, 2013 10:35 AM
  • Dear how can I do this? Can you guide me where shall I go step by step?
    Monday, September 30, 2013 10:42 AM
  • You have multiple options. You can use Hardware / Software Inventory or Asset Intelligence... Then use a built-in report or create a new one...

    For example, Hardware Inventory data comes from Add/Remove Programs - very easy.

    Hardware / Software Inventory

    Did you enable/schedule hardware and/or software inventory (client settings)?

    e.g. http://bscexp.blogspot.ca/2013/06/sccm-reports-under-software-companies.html

     

    Enable and Configure Asset Intelligence

    http://technet.microsoft.com/en-us/library/gg712322.aspx



    • Edited by fernsantos Monday, September 30, 2013 11:46 AM
    Monday, September 30, 2013 11:45 AM
  • Yes but it not give me the report it is empty..

    Exactly which report are you looking at?

    I would suggest that you look at Count of all instances of software registered with Add or Remove Programs or Computers with specific software registered in Add Remove Programs


    http://www.enhansoft.com/

    Monday, September 30, 2013 12:38 PM
  • You have multiple options. You can use Hardware / Software Inventory or Asset Intelligence... Then use a built-in report or create a new one...

    As and aside I never recommend enabling Software Inventory for a few reason,

    1. It shouldn’t be called Software Inventory, it should be called file inventory.
    2. It is extremely slow. It takes over 4 hours on my laptop and I have a fast SSD drive in my laptop.

    I actually have a blog post schedule to be post on Thursday on this topic. You can find post around noon at http://be.enhansoft.com/



    http://www.enhansoft.com/

    Monday, September 30, 2013 12:39 PM
  • Garth, I wasn't recommending one option over the others. Just listing them :)

    I am aware of the issues with Software Inventory and I only use it when I need, and disable it afterwards. It is not something to leave active all the time, but when it's required... I agree with you; MS should rename it to File Inventory.

    Hardware inventory is for sure the easiest method. However, if a user has local admin rights and deletes the software GUID under the Uninstall reg key, there goes hardware inventory reliability.

    All options have advantages/disadvantages. One has to do research and pick the best suited option.

    Looking forward to reading your blog on Friday; you are one of 36 SCCM individuals that I follow (RSS)  :)

    Monday, September 30, 2013 12:52 PM
  • I did but this is not working for me, can you give me SQL query to do this job example count all Microsoft Lync installed on machines?
    Monday, September 30, 2013 1:09 PM
  • I did but this is not working for me, can you give me SQL query to do this job example count all Microsoft Lync installed on machines?

    If the reports aren’t working for you then neither will the SQL query, since they will all use SQL queries.

    What exactly isn’t working for you? What error do you get, post a screenshot of what you are getting.


    http://www.enhansoft.com/

    Monday, September 30, 2013 1:17 PM
  • Garth is right...

    Just in case you're curious; using Hardware Inventory... Tweak to your needs:

    SELECT ARP.DisplayName0 As 'Software', Count (Distinct ARP.ResourceID) As 'Count'
    FROM v_Add_Remove_Programs ARP
    WHERE ARP.DisplayName0 Like '%Microsoft Lync 201%'
    GROUP BY ARP.DisplayName0
    ORDER BY ARP.DisplayName0 Asc

    Monday, September 30, 2013 1:23 PM
  • Dear Garth when I add this query in new collection it keep give me this error

    

    Tuesday, October 01, 2013 5:47 AM
  • That query is for reporting and not used for collections.

    You will need to create a report using ssrs.


    http://www.enhansoft.com/

    Tuesday, October 01, 2013 10:24 AM
  • Dear thanks, but I need query for collection not report if you can provide me I will be appreciate.
    Tuesday, October 01, 2013 11:24 AM
  • Why would you use a collection to find the total usage of a  software? Are you deploying anything to it?

    If you just need to know who/how many, use a report. If you are not deploying anything to the resultant systems and you don't want to use a report, at least use a Query (Monitoring node).

    Collections use more resources, and if you don't intend to use it, it's a waste.

    WQL code (Query) to get a list of which systems have the software... It can be modified to get a count or whatever you need. This requires Hardware inventory to be running.

    SELECT DISTINCT
    	SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client
    FROM  
    	SMS_R_System 
    WHERE 
    	SMS_R_System.ResourceId in ( 
    		select SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID 
    		from SMS_G_System_ADD_REMOVE_PROGRAMS 
    		where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName Like "%Microsoft Lync 201%"
    	) OR SMS_R_System.ResourceId in(
    		select SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID 
    		from SMS_G_System_ADD_REMOVE_PROGRAMS_64 
    		where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName Like "%Microsoft Lync 201%"
    	)
    
    


    Tuesday, October 01, 2013 11:56 AM
  • Dear Garth, thanks for support the query is working now but we have 32 bit and 64 bit, is this query for both?
    Tuesday, October 01, 2013 12:32 PM
  • Hi Dana,

    I'm fern, not Garth...

    Yes, the query provided on the previous reply is for both 31/64 bit. As you can see from the query, there is an "OR" statement..

    • "select SMS_G_System_ADD_REMOVE_PROGRAMS" : this is for 32 bit
    • "select SMS_G_System_ADD_REMOVE_PROGRAMS_64" : this is for 64 bit

    Always test to ensure that the code is returning accurate results.

    • Marked as answer by Dana.Kadi Tuesday, October 01, 2013 1:26 PM
    Tuesday, October 01, 2013 12:36 PM
  • Sorry Fern for this mistake, and thanks for helped me now it is solved...
    Tuesday, October 01, 2013 1:27 PM
  • Sorry Fern for this mistake, and thanks for helped me now it is solved...

    No problem; I just don't want to see Garth get all the credit. He already has tons of points :)

    Just kidding... Garth is an awesome MVP / king of reports.

    Tuesday, October 01, 2013 1:39 PM
  • Thanks for both
    Wednesday, October 02, 2013 6:04 AM
  • FYI the blog post about why SW inventory is slow, is up now.

    http://be.enhansoft.com/post/2013/10/03/Slow-Software-Inventory-Cycle-in-SCCM-2012.aspx


    http://www.enhansoft.com/

    Friday, October 04, 2013 9:31 PM