Skip to content

Computer model and name Report

Featured Replies

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 :)

  • Author

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 :)

  • 1 month later...

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:

 

post-2500-12604528634516_thumb.jpg

  • 1 month later...
  • Author

thank u :)

  • Author

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

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

  • Author

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

  • 4 weeks later...

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

  • 8 months later...

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

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 ?

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.