SQL query
Question
Need SQL query to fetch machine information with country,department and department.
Please help.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Need SQL query to fetch machine information with country,department and department.
Please help.
Answers ( 4 )
Query mentioned below.
SELECT SYS.User_Name0 as UserName, USR.Mail0 as ‘EMail ID’,
USR.company0 as ‘Company’,
USR.department0 as ‘Department’,
SYS.Netbios_Name0 as Machine,
Operating_System_Name_and0 as OS FROM v_R_System SYS
JOIN v_R_User USR on USR.User_Name0 = SYS.User_Name0
–WHERE SYS.User_Name0 LIKE ‘Username’
ORDER BY SYS.User_Name0, SYS.Netbios_Name0
I got such query , thank you
can you paste the query here so that others can also benefit from it
country,department, and department are not discovered by default in SCCM. Have you already collecting these details into SCCM? But you can use AD data and discovery to get this working using the following guide
https://www.anoopcnair.com/sccm-application-deployment-based-on-system-description-configmgr/