Symantec Management Platform (Notification Server)

 View Only
  • 1.  Report For Software CheckPoint

    Posted Dec 02, 2014 12:42 PM

    Hi ,

    Need help to get a report in Altiris 7.1 to show the fields, Machine Name, User Name, OS type, Software Name, Date Installed where Software  is  like

    "Check Point"   and list the count of all entries for it. I started on the query below but it is incomplete . I appreciate your help and time on this.

     

    SELECT vc.Guid,vc.Name, arp.DisplayName,arp.DisplayVersion

    FROM vComputer vc

    JOIN Inv_AddRemoveProgram arp ON arp._ResourceGuid=vc.Guid

    WHERE DisplayName LIKE ' Check Point%' AND arp.InstallFlag=1



  • 2.  RE: Report For Software CheckPoint

    Trusted Advisor
    Posted Dec 02, 2014 01:04 PM

    What about this?

     

    SELECT vc.Guid,
      vc.Name,
      vc.[user],
      vc.[os name],
      arp.DisplayName,
      arp.DisplayVersion,
      arp.InstallDate
    FROM vComputer vc
    JOIN Inv_AddRemoveProgram arp ON arp._ResourceGuid=vc.Guid
    WHERE DisplayName LIKE 'Checkpoint%' AND arp.InstallFlag=1

     

    (you'll need to elaborate on the 'count' bit as it's not clear what you want to group on for that)



  • 3.  RE: Report For Software CheckPoint

    Posted Dec 02, 2014 01:20 PM

    Thanks, the count will be based on the specific versions to tally the count of each version this way I will have the information showing the machines that have it and tally of each version count . I hope that calrifies it and once again thanks for the assistance and time

     

     



  • 4.  RE: Report For Software CheckPoint

    Trusted Advisor
    Posted Dec 02, 2014 01:31 PM

    A tally then means grouping by name and version...  which will be a different query as the grouping (counting) means your getting more of an overview which means you loose the detail. Something like this...

    select count(*),DisplayName,DisplayVersion from Inv_AddRemoveProgram
    where DisplayName like 'Checkpoint%'
    AND Inv_AddRemoveProgram.InstallFlag=1
    group by DisplayName,DisplayVersion


  • 5.  RE: Report For Software CheckPoint
    Best Answer

    Posted Dec 02, 2014 03:41 PM

    Thanks



  • 6.  RE: Report For Software CheckPoint

    Posted Dec 02, 2014 03:46 PM

    Did you get the solution? Can you please mark the correct one. Thanks.



  • 7.  RE: Report For Software CheckPoint
    Best Answer

    Trusted Advisor
    Posted Dec 03, 2014 04:38 AM

    Hi SamAdmin,

    The way Symantec Connect works is that people post questions (as you did), people answer, and then the original poster says thankyou to the helpful answers by using the "Mark as solution" scheme.

    Marking your "thanks" as the solution is silly in this context.

    If my replies indeed answered your question and help you out, just clear your solution and then mark mine as the answer.

    Kind Regards,
    Ian./

     



  • 8.  RE: Report For Software CheckPoint

    Posted Dec 03, 2014 04:21 PM

    Sorry but I forgot to mention that is more nfo needed. Basically I need to get the count of all Adobe Acrobat versions from Altiris and would be something like noted below to show Software Display Name, Display Version, Manufacturer, Count.  I appreciate the help

         
    Adobe Acrobat Professional     8     Adobe Systems, Inc.     4
    Adobe Acrobat Professional     9     Adobe Systems, Inc.     11
    Adobe Acrobat Standard         7     Adobe Systems, Inc.     9
    Adobe Acrobat Standard         8     Adobe Systems, Inc.     18
    Adobe Acrobat Standard         9     Adobe Systems, Inc.     37
    Adobe Acrobat X Standard             Adobe Systems, Inc.     2