Hello,

In which table can I find the following information:

Computer(Client):

1. Domain
2. Operating System
3. Service Pack
4. System version
5. System build
6. System serial number
7. Network - Tags- 2 i 3 octet IP addres

Components:
for example name of processor, memory, HDD
Model
Type
parameters for example size
parameters for example frequancy

The software installed on computer

I need all that information to get them from SQL tables only.
I will be very thankful for any advice.

Regards
Artur Wjtowicz

• Edited by Artur W 33 minutes ago

you'll need to do a few joins for the information you need, here's a quick one to get you started:

Select *
from v_r_system rs
inner join v_gs_Operating_System OS on RS.resourceID = OS.resourceID
inner join v_gs_Computer_System CS on RS.resourceID = CS.ResourceID
inner join v_GS_NETWORK_ADAPTER_CONFIGURATION NC on RS.ResourceID = NC.ResourceID

For installed software you should look at v_GS_ADD_REMOVE_PROGRAMS and v_GS_ADD_REMOVE_PROGRAMS_64