SOLVED SQL Views that need to server details

[dj3094]

Hello all,
I am trying get information of all servers, what views do I need?
Virtual machine type(hyper V, Vmware,physical)
cores
free space
machine name
RAM
total console user
created date
OS
common user
mode
manufacturer
drive size....

goal is get info of the all the view.

Regards
Anche

 

[Garth]

here is the listed of SCCM SQL views.

Software updates views - Configuration Manager

Information about the software updates metadata, software update groups, and software update bundles.

docs.microsoft.com

 

[dj3094]

Thanks Garath,

I have checked the link but couldnt find all I need, Here are some views I came up
v_RA_System_Ipaddress
v_GS_Logical_disk
v_r_system
v_gs_system_enclosure
v_gs_network_adapttor
v_gs_processor

required fields are atatched
Is there any other views I can use to get all information?

Thanks in advance

 

[Garth]

Thanks Garath,

I have checked the link but couldnt find all I need, Here are some views I came up
v_RA_System_Ipaddress
v_GS_Logical_disk
v_r_system
v_gs_system_enclosure
v_gs_network_adapttor
v_gs_processor

required fields are atatched
Is there any other views I can use to get all information?

Thanks in advance

What columns are you missing?

 

[dj3094]

I am missing the manufacturer, last hardware scan, last logged on user, data source, most common user, serial number, cpu speed, cpu type, created date, etc,,

 

[Garth]

You will find them all with this section of the docs. https://docs.microsoft.com/en-us/co...ardware-inventory-views-configuration-manager

 

[dj3094]

Thanks Garath,

Is it recommended to create new custom view that pull all the fields I required?

 

[Garth]

No it is NOT supported to do that adn it MIGHT cause upgrades to fail.