Client Management Suite

 View Only

  • 1.  Software inventory report

    Posted Jan 31, 2014 02:13 PM

    I need help writing an Altiris Report, we dont have the Asset Management piece, but I need to be able to pull a software report with the serial number, install date, product key, user name.  Any help will be helpful.



  • 2.  RE: Software inventory report

    Posted Jan 31, 2014 03:06 PM

    Is the serial number from the software or from the machines hardware?  If the former, then this will most likely require a custom inventory scan.  If the latter, it is brought in by our hardware inventory, and possibly even by the SMA's basic inventory.

    The softwares product key will most likely be encrypted, so you will need to use a tool like Belarc's Advisior in conjunction with a custom inventory scan.

    Software installed date is gathered by the software inventory.

    The above factors will require you to either four or five inventory type table together in order to craete the report, which is relatively easy to do.



  • 3.  RE: Software inventory report

    Posted Feb 02, 2014 10:29 PM

    The below mentiond query will help you toget the Computer Name, User, Application Name and Install Date.

     

    For serial number- You mean Hardware serial number for the computer?

     

    SELECT name as 'Computer Name',

    [user],

    DisplayName as 'Application Name',

    InstallDate

    FROM vComputer ID

    INNER JOIN Inv_AddRemoveProgram ARP

    On ARP._ResourceGuid = ID.Guid

    Where (ARP.DisplayName) Like 'Microsoft Office%' And

    (ARP.Publisher) Like 'Microsoft%' And

    (ARP.DisplayName) Not Like '%Service%' And

    (ARP.DisplayName) Not Like '%Security%' And

    (ARP.DisplayName) Not Like '%Validation%' And

    (ARP.DisplayName) Not Like '%Component%' And

    (ARP.DisplayName) Not Like '%Lab%' And

    (ARP.DisplayName) Not Like '%Sound%' And

    (ARP.DisplayName) Not Like '%Add-in%' And

    (ARP.DisplayName) Not Like '%MUI%' And

    (ARP.DisplayName) Not Like '%Project%' And

    (ARP.DisplayName) Like '%Visio%' And

    (ARP.DisplayName) Not Like '%Disc 2%' And

    (ARP.DisplayName) Not Like '%Communicator%' And

    (ARP.DisplayName) Not Like '%Viewer%' And

    (ARP.DisplayName) Not Like '%Visual%' And

    (ARP.DisplayName) Not Like '%Resource%' And

    (ARP.DisplayName) Not Like '%Share%' And

    (ARP.DisplayName) Not Like '%Publisher%' And

    (ARP.DisplayName) Not Like '%Producer%' And

    (ARP.DisplayName) Not Like '%proof%' And

    (ARP.DisplayName) Not Like '%Powerpoint%' And

    (ARP.DisplayName) Not Like '%outlook%' And

    (ARP.DisplayName) Not Like '%onenote%' And

    (ARP.DisplayName) Not Like '%live%' And

    (ARP.DisplayName) Not Like '%infopath%' And

    (ARP.DisplayName) Not Like '%frontpage%' And

    (ARP.DisplayName) Not Like '%converter%' And

    (ARP.DisplayName) Not Like '%access%' And

    (ARP.DisplayName) Not Like '%web%' And

    (ARP.DisplayName) Not Like '%excel%' And

    (ARP.DisplayName) Not Like '%groove%' And

    (ARP.DisplayName) Not Like '%word%' And

    (ARP.DisplayName) Not Like '%interop%'

    order by [user]

     



  • 4.  RE: Software inventory report

    Posted Feb 03, 2014 07:45 AM

    I mean the license serial number for the software, IE AutoCad, Microsoft Project etc



  • 5.  RE: Software inventory report

    Posted Feb 03, 2014 03:10 PM

    So does this mean that your serial number and product key requirements are actually the same?

    Have you looked at the previous points I mentioned?



  • 6.  RE: Software inventory report

    Posted Jul 26, 2014 03:24 AM
    Hi westur999, Did you fond the way to collect the information on collecting Software licences serial number or product key ,am also trying to find the same . I want to know the serial key of perticuler software installed to find weather it is install using the softwar purched serial key.