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.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Answers ( 5 )
No response hence closing this thread.
Hello, Did you get any chance to check and update!
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.
This is what I was trying to say.
Let me know what are the things you tried then we will try to help you further.
Does that make sense ?
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/