JO123 0 Posted January 25 Report post Posted January 25 Hi, I need report in sccm having following information. Computer name, user name, location and department. Please share. Thanks. Quote Share this post Link to post Share on other sites
GarthMJ 125 Posted January 25 Report post Posted January 25 CM does not inventory location or department by default. So..... Quote Share this post Link to post Share on other sites
JO123 0 Posted January 30 Report post Posted January 30 Hi, I need computer , user names , location and dept names in sccm sql query. I already enabled attributes for these. Please update. Quote Share this post Link to post Share on other sites
GarthMJ 125 Posted January 30 Report post Posted January 30 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. Quote Share this post Link to post Share on other sites
JO123 0 Posted January 31 Report post Posted January 31 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. Quote Share this post Link to post Share on other sites
GarthMJ 125 Posted February 1 Report post Posted February 1 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. Quote Share this post Link to post Share on other sites
JO123 0 Posted February 1 Report post Posted February 1 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. Quote Share this post Link to post Share on other sites