Client Management Suite

Hi there,

Can anyone help me create a hardware report?.  I've managed to get the majority of the information (computer name, Manufacturer, model, OS, OS service pack) but am struggling getting processor type/speed, total memory (MB) and max available memory (MB).  

Requirements: computer name, Manufacturer, model, operating system, service pack, processor and memory

Thanks for help.

See this thread

https://www-secure.symantec.com/connect/forums/help-query

Check the attach forum

https://www-secure.symantec.com/connect/forums/new-symantecaltiris

Do you need more help here ?

post up what you got so I can add to it... all but for max memory as I dont know of a way for Altiris to be smart enough to know all systems and max memory it can handle. With that though I can do the rest...

Here is one of mine..

Hostname, CPU, RAM, OS Name and OS Revision

select DISTINCT t0.[Name] as 'Hostname', t3.[Processor Name] as 'CPU', t2.[Total Physical Memory (Bytes)] / (1024 * 1024) as [RAM],
         t4.[Size (Bytes)]  / (1024 * 1024 * 1024) as [Disk Space (GB)], t0.[OS Name], t0.[OS Revision]  
from vComputer t0
left join vHWComputerSystem t2 on t0.[Guid] = t2.[_ResourceGuid]
left join Inv_HW_Processor_Name_Windows t3 on t2.[_ResourceGuid] = t3.[_ResourceGuid]
left join Inv_HW_Logical_Disk t4 on t3.[_ResourceGuid] = t4.[_ResourceGuid]
        

Thanks!

guess you dont need anything added... if so just ask..