Request query to find out windows-7 and windows-10 computers with AD site information

Question

please provide sql query to find out windows-7 and windows-10 computers with AD site and user id information. Thank you.

solved 0
nanda kumar 7 months 2020-08-10T13:52:06+05:30 5 Answers 63 views Beginner 0

Answers ( 5 )

    0
    2020-08-19T03:05:17+05:30

    No response hence closing this thread.

    0
    2020-08-12T08:04:03+05:30

    Hello, Did you get any chance to check and update!

      0
      2020-08-12T19:30:22+05:30

      Hi Jitesh and Anoop,

      Thank you for the response and apologize for the delay in response.

      In this post, i had actually meant that i am looking for the below information. Please help

      1. i want a query or i like to create a separate device collection with a query that will automatically fetch all windows-10 PC’s from network.

      2.i want a query or i like to create a separate device collection with a query that will automatically fetch all windows-7 PC’s from network.

    0
    2020-08-10T14:19:10+05:30

    You can use the following query to get AD Site as well ?

    https://www.anoopcnair.com/configmgr-custom-report-for-chrome-browser-sccm-sql-query/

    Best answer

Leave an answer

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