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.
Discussion Filed Under:
Comments 5 Comments • Jump to latest comment
If chassis type is not acceptable, I'd suggest creating a report based on model.
Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com
Thanks Mike, I worked off your query and used model names and manufacturers to come up with what I was looking for!
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])
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
Thanks Vigersand, that also works.
Would you like to reply?
Login or Register to post your comment.