Philadelphia Security User Group

 View Only

  • 1.  Licensed Programs in computer inventory question

    Trusted Advisor
    Posted Jan 04, 2012 01:45 PM
      |   view attached

    Where does Altiris get the info it provides in console under a computer record, licensed programs?

    I'm asking because it seems like as we update software using patch, multiple versions are being listed there (the multiple versions don't show under add/remove programs, however).  In the programs themselves, they all report current (latest) versions.

    See screenshot of an example of machine with updated flash/shockwave/adobe reader all of which have had patches or upgrades sent to replace them.

    We are running CMS 7.1 SP2 (or is that 7.2?)



  • 2.  RE: Licensed Programs in computer inventory question
    Best Answer

    Posted Mar 19, 2012 02:16 PM

    Hi Sally,

    This query is used:

    Licensed programs:

    Method: GetFullPageLicencedProgramsSection

    select isnull( a.[Name], N''), isnull( a.[Product ID], N'')
    from vResource r
    LEFT OUTER JOIN Inv_AeX_OS_Add_Remove_Programs a ON a._ResourceGuid = r.Guid
    LEFT OUTER JOIN Inv_AeX_AC_Identification i on r.Guid = i._ResourceGuid
    where r.Guid = @ResourceGuid
    and a.[Product ID] <> ' '
    and upper(a.[Product ID]) not like upper('%none%')

    http://www.symantec.com/docs/HOWTO1150 (SQL Queries from the Resource Summary page)

    Regards,