Deployment and Imaging Group

 View Only
  • 1.  Need report to pull inventory of specific model laptop...

    Posted May 11, 2015 12:02 PM

    I've been looking through "All Reports" and have had not luck finding what I need. I am looking to pull a report that shows the total number of a specific model of laptop we have. 

    We have a number of HP Elitebook 8460's and 8470's that are at the end of their lifecycle. I was asked to pull a report for the total number of these models we have so that we can establish a budget to refresh them.

    Like I said, I tried searching through the various reports in the Altiris console but couldn't locate one for what I need. I'm not an SQL guru either so I'm sure it's probably a simple thing for someone here.

    Thanks in advance guys.



  • 2.  RE: Need report to pull inventory of specific model laptop...

    Posted May 11, 2015 12:22 PM

    I apologize guys, after some more digging and playing with the reports I believe I found what I was looking for.



  • 3.  RE: Need report to pull inventory of specific model laptop...

    Broadcom Employee
    Posted May 11, 2015 01:23 PM

    Seems like you've found a "Computer Summary" report and also "Group By" control to count computers per appropriate field

     

    ComputerSummary_Group.jpg



  • 4.  RE: Need report to pull inventory of specific model laptop...

    Trusted Advisor
    Posted May 12, 2015 11:54 AM

    In case you (or someone else) needs a filter to take action on certain groups of hardware, he's the sql I use for a filter for Dell model Optiplex 7010.  

     

    SELECT
       [vri1_Computer].[Guid],
       [vri1_Computer].[Name]
    FROM
       [vRM_Computer_Item] AS [vri1_Computer]
          LEFT OUTER JOIN [Inv_HW_Logical_Device] AS [dca2_HW Logical Device]
             ON ([vri1_Computer].[Guid] = [dca2_HW Logical Device].[_ResourceGuid])
    WHERE
       (
          (
             ([dca2_HW Logical Device].[Model] LIKE N'Optiplex 7010')
          )
       )