Hi , I am using SCCM 2012. Trying to create a WQL query to get list of computers with department name and netbios names,etc. these are in USER  and SYSTEM RESOURCE  object type seperately. The query wizard doesn't allow me to choose sytem resource and USER attribute at same time. In JOIN, the inner join also doesn't have SYSTEM RESOURCE attribute class for me to join it with USER attribute class. Any way to resolve this issue so that I can get a query as mentioned?
I tried the wql below and pasted to my test query, it gave an error. I guess it's because that wql is on sccm2007.

Please advise,thanks!

http://social.technet.microsoft.com/Forums/en-US/8c47f069-5390-45bd-a619-5f5498947baa/sccm-query-which-joins-system-resource-and-user-resource?forum=configmgrgeneral

http://social.technet.microsoft.com/Forums/en-US/8c47f069-5390-45bd-a619-5f5498947baa/sccm-query-which-joins-system-resource-and-user-resource?forum=configmgrgener

Why WQL? What's your goal? Why not using SQL?

I am not familiar with SQL query, but I some WQL before. I want to use wql to query and generate a report with both USER attribute class and System REsource attribute class,e.g. a report with department name, CPU,Memory, Last logon use, location.... then copy/paste a excel file. it's easier to manage. any advice please?

There is no difference between CM07 and CM12, what error do you get? For reports you need to use SQL.

I copy/paste the query to my test query , when I click show query design, I got that error above. When I run this query,the result it blank . any advice please?thanks

departmentNumber is not a default attribute for users. You will need to either remove it from the query or add it to your discovery.

Hi,

Try the suggestion by Garth Jones or post a new thread at http://social.technet.microsoft.com/Forums/en-US/home?forum=ITCG

I am not familiar with WQL, maybe you could get better help at the forum above.

Hi Mr. Jones,

Unfortunately I have the same issue with WQL query to join User Resource Class and System Resource Class please let me know if anyone have the script or the WQL, thanks