yes, the 5 tables(views) mentioned contain the information you requested

 so I just can select the table from SCCM, 

Please don't use tables, but views instead.

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 Friday, September 11, 2015 7:04 AM

Hello,

Thank You, but I cant use SQL script because the ServiceDesk has own functionality to do the import, so I just can select the table from SCCM, attributes, and then map interesting me attributes with SD attributes.
So I just should check that 5 tables that You mentioned?

Thanks a lot.

Regards

Hello again,

Can You just help me a little more?
In which view Can I find that information for sure, because in that views there are so many similar attributes, can anyone copy my needs list and map the views and attributes to my list?

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

And thank You a lot for help.

Regards

#1: v_R_System
#2: v_R_System and v_GS_OPERATING_SYSTEM
#3: v_GS_OPERATING_SYSTEM
#4/5: what attribute are you referring to technically?
#6: v_GS_SYSTEM_ENCLOSURE
#7: v_GS_NETWORK_ADAPTER_CONFIGUR