Computer model and name Report

[jeaostro]

Hello

 

Im trying to create a report that shows the computer name for every computer in the domain, but also what model(brand) it is.

For example Computer Name: XP-44 Computer Model: 245828G (Lenovo)

 

Can anyone point me in the right direction?

 

Thanks

[jeaostro]

If possible:

 

Computer Name Computer User Computer Model Computer Manufacture Total Disk Space Free Disk Space Total Memory

 

 

Im not any god at sql query so thanks for all I can get from you guys

[wmmayms]

Hi

 

Here is a report i created a while back.

If a computer has more then 1 disk or more then 1 ip adress you will get another row for that computer.

 

SELECT 
A.Name0, 
B.SerialNumber0, 
A.Manufacturer0, 
A.Model0, C.Name0 AS 'Processor', 
D.TotalPhysicalMemory0 AS 'Memory (KBytes)', 
E.Size0 AS 'Disk Size (MBytes)', 
F.MACAddress0, 
F.IPAddress0, 
G.AD_Site_Name0 AS 'AD Site', 
A.UserName0 AS 'Last user logged in', 
H.Caption0 AS 'Operating System', 
H.CSDVersion0 AS 'Service Pack', 
G.Creation_Date0 AS 'Creationdate in SMS', 
I.LastHWScan

FROM 
v_GS_COMPUTER_SYSTEM A,
v_GS_PC_BIOS B,
v_GS_PROCESSOR C,
v_GS_X86_PC_MEMORY D,
v_GS_DISK E,
v_GS_NETWORK_ADAPTER_CONFIGUR F,
v_R_System G,
v_GS_OPERATING_SYSTEM H,
v_GS_WORKSTATION_STATUS I

WHERE
A.ResourceID = B.ResourceID AND
A.ResourceID = C.ResourceID AND
A.ResourceID = D.ResourceID AND
A.ResourceID = E.ResourceID AND
A.ResourceID = F.ResourceID AND
A.ResourceID = G.ResourceID AND
A.ResourceID = H.ResourceID AND
A.ResourceID = I.ResourceID AND

F.IPAddress0 != NULL AND 
F.IPAddress0 != '0.0.0.0'

GROUP BY A.Name0, B.SerialNumber0, A.Manufacturer0, A.Model0, C.Name0, D.TotalPhysicalMemory0, E.Size0, F.MACAddress0, F.IPAddress0, G.AD_Site_Name0, A.UserName0, H.Caption0, H.CSDVersion0, G.Creation_Date0, I.LastHWScan

 

Example:

 

[jeaostro]

thank u

[jeaostro]

Can i just copy paste this into a new Custom made report?

in the SQL statement filed? Trying to run it but nothing happens?

[jeaostro]

well something happens, its doesnt show any information when i run the report Do I need to link to another report?

[sreeni]

well something happens, its doesnt show any information when i run the report Do I need to link to another report?

 

Hi

 

I did a try to modify the code and to execute. I Just modified the code which wmmayms given....Thanks for this useful code wmmayms

 

@jeaostro Just try this... Hope it works....

 

-------------------

 

SELECT

A.Name0,

B.SerialNumber0,

A.Manufacturer0,

A.Model0, C.Name0 AS 'Processor',

D.TotalPhysicalMemory0 AS 'Memory (KBytes)',

E.Size0 AS 'Disk Size (MBytes)',

F.MACAddress0,

F.IPAddress0,

G.AD_Site_Name0 AS 'AD Site',

A.UserName0 AS 'Last user logged in',

H.Caption0 AS 'Operating System',

H.CSDVersion0 AS 'Service Pack',

G.Creation_Date0 AS 'Creationdate in SMS',

I.LastHWScan

 

FROM

v_GS_COMPUTER_SYSTEM A,

v_GS_PC_BIOS B,

v_GS_PROCESSOR C,

v_GS_X86_PC_MEMORY D,

v_GS_DISK E,

v_GS_NETWORK_ADAPTER_CONFIGUR F,

v_R_System G,

v_GS_OPERATING_SYSTEM H,

v_GS_WORKSTATION_STATUS I

 

WHERE

A.ResourceID = B.ResourceID AND

A.ResourceID = C.ResourceID AND

A.ResourceID = D.ResourceID AND

A.ResourceID = E.ResourceID AND

A.ResourceID = F.ResourceID AND

A.ResourceID = G.ResourceID AND

A.ResourceID = H.ResourceID AND

A.ResourceID = I.ResourceID and

 

F.IPAddress0 is not NULL AND

F.IPAddress0 not like '0.0.0.0'

 

GROUP BY A.Name0, B.SerialNumber0, A.Manufacturer0, A.Model0, C.Name0, D.TotalPhysicalMemory0, E.Size0, F.IPAddress0, F.MACAddress0, G.AD_Site_Name0, A.UserName0, H.Caption0, H.CSDVersion0, G.Creation_Date0, I.LastHWScan

 

 

Thanks

Sreeni

[m0ck]

Does SCCM inventors all the data from clients' WMI?

In the Win32_ComputerSystemProduct wmi class there's a Version string which holds "friendly" model name of the computer, instead of model numbers in case of Lenovos.

Does anyone know if this wmi data inventoried? It would be much better to use that for the Count of Models report... Was looking in the DB tables for a clue.. no go..

 

Anyone?

 

Thanks,

Dmitry

[Eswar Koneti]

Does SCCM inventors all the data from clients' WMI?

In the Win32_ComputerSystemProduct wmi class there's a Version string which holds "friendly" model name of the computer, instead of model numbers in case of Lenovos.

Does anyone know if this wmi data inventoried? It would be much better to use that for the Count of Models report... Was looking in the DB tables for a clue.. no go..

 

Anyone?

 

Thanks,

Dmitry

 

SCCM will inventory all the values based on sms_def.mof .If you need additional values to be extended, you can check this by sms_def.mof file from your SCCM installation drive:\inboxes\clifiles.src\hinv\sms_def.mof ?