SQL query

Question

Need SQL query to fetch machine information with country,department and department.

Please help.

solved 0
aamir ansari 2021-09-22T19:13:41+05:30 4 Answers 38 views Beginner
4

Answers ( 4 )

  2. aamir ansari
    0
    2021-10-02T21:35:07+05:30
    Reply

    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

  4. aamir ansari
    0
    2021-09-27T19:42:35+05:30
    Reply

    I got such query , thank you

  6. Anoop C Nair
    0
    2021-09-23T23:50:32+05:30
    Reply

    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/

    Best answer

Leave an answer

Sorry, you do not have permission to answer to this question .