Asset Management Suite

Hi,

I have created a report with some general informations about  computers. Now I need to add a field with the "Computer Type" (desktop, laptop, etc) in my report. In Altiris 6 there was a specific field ([Inv_AeX_HW_Serial_Number].[Computer Type] that held this information. In Altiris 7.1 there is this information? If there is, in wich table is located?
I have seen this post:

https://www-secure.symantec.com/connect/forums/cmdb-tables-computer-type

but this report don't work for me. This is my actual query

SELECT distinct [v].[Name], [v].[Domain], [v].[User],  [v].[IP Address],  [v].[OS Name],[v].[System Type],[Inv_HW_ProcessorName].[Processor Name], ([Inv_OperatingSystem].[Total Visible Memory Size (Kilobytes)] / 1024) AS [Total Physical Memory Mb], ([Inv_OperatingSystem].[Total Visible Memory Size (Kilobytes)] / 1024) AS [Total Visible Memory],[Inv_Asset].[Manufacturer],[Inv_Asset].[Model],[Inv_Asset].[Identifying Number],[Inv_Asset].[Number Of Processors] AS [Nr. Processori]
   
FROM vcomputer v
LEFT OUTER JOIN [Inv_AeX_AC_TCPIP] AS [Inv_TCP_IP]
         ON ([v].[Guid] = [Inv_TCP_IP].[_ResourceGuid] and [v].[IP Address] = [Inv_TCP_IP].[IP Address])
LEFT OUTER JOIN [Inv_HW_Processor_Name_Windows] AS [Inv_HW_ProcessorName]
         ON ([v].[Guid] = [Inv_HW_ProcessorName].[_ResourceGuid])
LEFT OUTER JOIN [Inv_OS_Operating_System] AS [Inv_OperatingSystem]
         ON ([v].[Guid] = [Inv_OperatingSystem].[_ResourceGuid])
LEFT OUTER JOIN [vHWComputerSystem] AS [Inv_Asset]
    ON [Inv_Asset].[_ResourceGuid]=[v].[Guid]

WHERE

v.domain like '%' + '%Domain%' + '%'

AND

v.name like '%' + '%ComputerName%' + '%'

AND

 v.[OS Name] like '%' + '%OsName%' + '%'

AND

 [Inv_TCP_IP].[Subnet] like '%' + '%Subnet%' + '%'

AND

v.IsManaged = 1

ORDER BY v.name

Thank's in advance for the help.

It does exist when it displays it to you it shows notebook etc but when you run your query its stored in the database as a number. This link has a reference to types and their number

http://msdn.microsoft.com/en-us/library/aa394474(v=VS.85).aspx

The chassis is stored in dbo.Inv_HW_Chassis

We use this as a filter for all desktops 

It's in Inv_HW_Chassis

Use this chunk of SQL in your query.

Use this to call out only certain types that you know are Desktop/Laptop:

Case [Chassis Package Type]

WHEN 3 then 'Desktop'

When 7 then 'Desktop'

When 9 then 'Laptop'

ELSE 'Unknown'

END AS 'Desktop or Laptop',

Or use the standard definitions with no re-ranking as Desktop/Laptop/etc:

CASE [Chassis Package Type]

When 1 Then 'Other'

When 2 Then 'Unknown'

When 3 Then 'Desktop'

When 4 Then 'Low Profile Desktop'

When 5 Then 'Pizza Box'

When 6 Then 'Mini Tower'

When 7 Then 'Tower'

When 8 Then 'Portable'

When 9 Then 'Laptop'

When 10 Then 'Notebook'

When 11 Then 'Hand Held'

When 12 Then 'Docking Station'

When 13 Then 'All in One'

When 14 Then 'Sub Notebook'

When 15 Then 'Space-Saving'

When 16 Then 'Lunch Box'

When 17 Then 'Main System Chassis'

When 18 Then 'Expansion Chassis'

When 19 Then 'Sub Chassis'

When 20 Then 'Bus Expansion Chassis'

When 21 Then 'Peripheral Chassis'

When 22 Then 'Storage Chassis'

When 23 Then 'Rack Mount Chassis'

When 24 Then 'Sealed Case PC'

ELSE 'Other'

END AS 'Chassis Type'

We encountered the same thing today, and I found another way to more easily get those Chassis types in a friendly manner.  Check out my Blog on the topic.

It would help others if they could ready your blog or post your answer in the thread

For some reason Kyle's blog was set to "private" - it's viewable now!

Cheryl