Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Need to create a report of all laptops

Created: 23 Nov 2012 • Updated: 29 Nov 2012 | 5 comments
This issue has been solved. See solution.

Hi

I am trying to create a report of all the laptops in NS. One approach I tried is to use the chassis type but the results were not satisfactory.

Could someone help me create a SQL query possibly that includes all the laptops and other similar types like portables etc. I believe chassis types 8,9,10,11,12 should be included.

Thanks,

Husein.

Comments 5 CommentsJump to latest comment

mclemson's picture

If chassis type is not acceptable, I'd suggest creating a report based on model.

SELECT vc.Guid, hwc.Model
FROM vComputer vc
JOIN vHWChassis hwc ON hwc._ResourceGuid=vc.Guid
WHERE
hwc.Model LIKE '%Latitude%' OR
hwc.Model LIKE '%ThinkPad%' OR
hwc.Model IN ('Model123','ModelABC','Model-etc')
 
It requires more upkeep but allows you to be more granular.  I guess Chassis Package Type would look like this:
 
SELECT vc.Guid, hwc.[Chassis Package Type]
FROM vComputer vc
JOIN vHWChassis hwc ON hwc._ResourceGuid=vc.Guid
WHERE hwc.[Chassis Package Type] IN ('8','9','10','11','12')
 
Does this help?

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com

SOLUTION
huseinm's picture

Thanks Mike, I worked off your query and used model names and manufacturers to come up with what I was looking for!

Vigersand's picture

An easy way to create a report with laptops is to check for a battery. Its not as granular as defining each model, but might be quicker if you have a lot of different hardwares.

In the SQL below you might want to exclude server OS if you have servers in your Altiris enviroment. This is because UPS devices sometimes shows up as batteries.

SELECT
   [vri2_Computer].[Guid] AS [_ItemGuid],
   [vri2_Computer].[Name]
 FROM
   [vRM_Computer_Item] AS [vri2_Computer]
      INNER JOIN [Inv_HW_Battery] AS [dca3_HW Battery]
         ON ([vri2_Computer].[Guid] = [dca3_HW Battery].[_ResourceGuid])
 

mclemson's picture

Great method.  I'd never considered defining mobile devices indirectly.  I'll have to try this next time I need to write a report like this!

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com