SCCM Users report

[JO123]

Hi,

I need report in sccm having following information.

Computer name, user name, location and department.

Please share.

Thanks.

 

[GarthMJ]

CM does not inventory location or department by default. So.....

[JO123]

Hi,

I need computer , user names , location and dept names in sccm sql query.

I already enabled attributes for these.

Please update.

[GarthMJ]

12 minutes ago, JO123 said:

Hi,

I need computer , user names , location and dept names in sccm sql query.

I already enabled attributes for these.

Please update.

What EXACTLY do you have now?  What EXACTLY doesn't work for you? I will NOT write this for you. 

[JO123]

Hi,

I created query for username , location and dept names. It is working fine.

I want to add in this query the computer name.

I tried but not getting result. 

Can you provide what query should i add to get my result?

Thanks for your support.

 

[GarthMJ]

17 hours ago, JO123 said:

Hi,

I created query for username , location and dept names. It is working fine.

I want to add in this query the computer name.

I tried but not getting result. 

Can you provide what query should i add to get my result?

Thanks for your support.

 

Again let me repeat myself! What EXACTLY do you have now?  What EXACTLY doesn't work for you? I will NOT write this for you. 

[JO123]

Hi,

I have SQL query. I have added computer name in that query and its not working.

I used INNER join command to join user with system . But its not work.

Can you provide some help in script to do that.

Thanks.