PENDING SQL Query for All SCCM Clients System Name and IP Address

[Anji]

Dear All,

I need some SQL from SCCM Server , Regarding All SCCM Clients where connected USB Devices, USB Manufacturer, USB Description, Computer Name, like...

Please find below SQL query coloums. How make the SQL Query and how can i get the report.

Computer Name

USB Device Manufacturer

USB Device Description

SMS Site

Top Console User

Computer Serial Number

Asset Tag

Computer Manufacturer

Computer Model

Number of Devices

Please help me regarding this , Because I troubled last one week on words.


Thank You All,

Ananeyulu.

 

[Garth]

Have you looked at the built-in report for this.

 

[Mahmoud87]

Dear All,

I need some SQL from SCCM Server , Regarding All SCCM Clients where connected USB Devices, USB Manufacturer, USB Description, Computer Name, like...

Please find below SQL query coloums. How make the SQL Query and how can i get the report.

Computer Name

USB Device Manufacturer

USB Device Description

SMS Site

Top Console User

Computer Serial Number

Asset Tag

Computer Manufacturer

Computer Model

Number of Devices

Please help me regarding this , Because I troubled last one week on words.


Thank You All,

Ananeyulu.

You won't be able to acheive everything unless you target something specifically to get, for example you will have to target the computer models eqaul "Latitude" then you will be able to list the rest of the stuff otherwise I don't think you will be able to get everything you have included in your post, this is the best I could get.

select SMS_G_System_DISK.SystemName, SMS_G_System_DISK.Model, SMS_G_System_DISK.Size, SMS_G_System_DISK.InterfaceType from SMS_G_System_DISK where SMS_G_System_DISK.InterfaceType = "USB"

Good luck