Sign in
 
Home2012Previous VersionsLibraryForumsGallery
System Center TechCenter >
> 
> 
SCCM SOULTION ACCELARTOR DASH BOARD FOR ADOBE

Proposed Answer SCCM SOULTION ACCELARTOR DASH BOARD FOR ADOBE

  • Thursday, May 10, 2012 4:24 AM
     
     
    Sign In to Vote
    0

    HI im making a dash board for adobe version and count .here i need to put all adobe version no in sql query ,insted of this 'adobe reader *.' is not working for me it is diffcult to put all verstion manuly i have lot of adove version in my comapny

    below is the query

    select DisplayName0 ,

    COUNT(distinct ResourceID) as 'client count'

    from dbo.v_GS_ADD_REMOVE_PROGRAMS

    where DisplayName0  in('Adobe Reader 7.0','Adobe Reader 8','Adobe Reader 8.1.0','Adobe Reader 9','Adobe Reader 9.3','Adobe Reader 9.3.4','Adobe Reader 9.4.5','Adobe Reader 9.5.0','Adobe Reader 7.0.5','Adobe Reader 7.0.8','Adobe Reader 7.1.0','Adobe Reader 8.1.0','Adobe Reader 8.1.2','Adobe Reader 8.1.3','Adobe Reader 8.2.0','Adobe Reader 8.3.1')

    group by DisplayName0

    order by count(*)desc

    select 

    Count (ResourceID) AS 'Total Count'

    from dbo.v_GS_ADD_REMOVE_PROGRAMS

    where DisplayName0  in('Adobe Reader 7.0','Adobe Reader 8','Adobe Reader 8.1.0','Adobe Reader 9','Adobe Reader 9.3','Adobe Reader 9.3.4','Adobe Reader 9.4.5','Adobe Reader 9.5.0','Adobe Reader 7.0.5','Adobe Reader 7.0.8','Adobe Reader 7.1.0','Adobe Reader 8.1.0','Adobe Reader 8.1.2','Adobe Reader 8.1.3','Adobe Reader 8.2.0','Adobe Reader 8.3.1')

    regards

    ankit

     

All Replies

  • Thursday, May 10, 2012 7:30 AM
     
     
    Sign In to Vote
    0
    This should get you started:
    select DisplayName0 ,
    COUNT(distinct ResourceID) as 'client count'
    from dbo.v_GS_ADD_REMOVE_PROGRAMS
    where DisplayName0  like 'Adobe Reader%'
    group by DisplayName0
    order by count(*)desc

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


     
  • Thursday, May 10, 2012 10:56 AM
     
     
    Sign In to Vote
    0
    Also keep in mind that your query will only find x86 systems. You need to use dbo.v_Add_Remove_Programs for both x86 and x64.

    http://www.enhansoft.com/

     
  • Friday, May 11, 2012 8:35 AM
     
     
    Sign In to Vote
    0

    hi

    thanks torsten

    but now i need combine all similar version into one how it is possible like

    8.1.3 , 8.2.0  8.3.1 need to show as adobe reader 8  what query can help this

    regards

    ankith

     
  • Sunday, May 13, 2012 3:07 PM
     
     Proposed Answer
    Sign In to Vote
    0
    Try this. http://tinyurl.com/7wzybhg

    http://www.enhansoft.com/

    • Proposed As Answer by S.Bro Tuesday, May 15, 2012 7:41 PM
    •  
     
  • Tuesday, May 15, 2012 2:59 PM
     
     
    Sign In to Vote
    0

    If you use the Normalize CM plug-In http://sccm.bdna.com, you can do it in a simple WQL or SQL query

    List of machines with Adobe Reader

    WQL

    select System.Name, Software.Publisher, Software.Family, Software.SoftwareName, Software.Component, Software.MinorVersion, Software.MajorVersion, Software.Edition, Software.Category1, Software.Category2 from SMS_R_System inner join SMS_G_System_BDNA_BDNASOFTWAREDATA_1_1 as Software on Software.SMSUniqueIdentifier = SMS_R_System.SMSUniqueIdentifier inner join SMS_R_System as System on System.SMSUniqueIdentifier = Software.SMSUniqueIdentifier where Software.Publisher = "Adobe Systems" and Software.SoftwareName = " Reader (Acrobat Reader)"

    SQL

    SELECT v_R_System.Name0 as Name, Software.Publisher0 as Publisher, Software.Family0 as Family, 

    Software.SoftwareName0 as SoftwareName, Software.Component0 as Component, Software.MinorVersion0 as MinorVersion, 

    Software.MajorVersion0 as MajorVersion, Software.Edition0 as Edition,Software.ServicePack0 as ServicePack, 

    Software.Category10 as Category1, Software.Category20 as Category2

    FROM v_R_System

    INNER JOIN v_GS_BDNA_Software_Data0 Software ON Software.SMSUniqueIdentifier0 = v_R_System.SMS_Unique_Identifier0

    WHERE Software.Publisher0 = ‘Adobe Systems’ AND Software.SoftwareName0 = ‘Reader (Acrobat Reader)’


    Content provided by myITforum. Read the rest: http://myitforum.com/myitforumwp/2012/03/29/list-of-machines-with-adobe-reader/




     
  • Tuesday, May 15, 2012 7:40 PM
     
     
    Sign In to Vote
    0

    also, if you need to get some detailed reports by version, you can try this; 

    http://anotherblabla.wordpress.com/2012/05/15/sccm-dashboard-for-adobe-reader-version/

    note that the dashboard query is based on Garth query.