Report of workgroup computers with sccm

Yekta b 1 Reputation point
2021-01-31T12:04:52.433+00:00

We need to know which computers are workgroup and what are their computer names with sccm, (Sccm Agent are not install on workgroup PCs).
How can we get this report?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,793 questions
Microsoft Configuration Manager
0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Youssef Saad 3,401 Reputation points
    2021-01-31T20:05:19.207+00:00

    Hi @Yektab-9996,

    You can check with your Network team to give you the list of devices with their hostname, then match them with the domain-joined ones, the delta will be your workgroup computers.

    Regards,

    Youssef Saad | New blog: https://youssef-saad.blogspot.com
    Please remember to ** “Accept answer” ** or upvote for useful answers, thank you!

    2 people found this answer helpful.
    0 comments
  2. Eswar Koneti 2,196 Reputation points
    2021-01-31T13:22:20.017+00:00

    There are default reports which will tell you about the count of computers in workgroup or domain and drill down further to see the device list

    Hardware - General Computers in a specific workgroup or domain

    OR

    if computer is in workgroup or domain can be retrieved from v_r_System for reporting.

    select name0 [Computer Name], Resource_Domain_OR_Workgr0
    from v_R_System

    you can use case statement to expand the query.

    Regards,
    Eswar
    www.eskonr.com
    If the response is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.
  3. Garth Jones 2,071 Reputation points
    2021-01-31T14:36:12.667+00:00

    Errr if there is no cm client installed on the workgroup computers, then there is no way to report on them.

    1 person found this answer helpful.
    0 comments
  4. AllenLiu-MSFT 40,076 Reputation points Microsoft Vendor
    2021-02-01T06:47:54.843+00:00

    @Yekta b
    Thank you for posting in Microsoft Q&A forum.
    If we do not install sccm agent on workgroup computers, then we can not get the info by sccm.
    If we do not install sccm agent on domain computers, we can get the info by sccm with discovery.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments
  5. Gary Blok 1,736 Reputation points
    2021-02-02T06:41:52.34+00:00

    As others have said, if you don't have the CM Client, you can't use CM to get you the information.

    Potential Ideas: (Not claiming they are easy or even good)

    Semi Easy, and Low amount of Work: Hopefully you have a inventory system of all your purchased devices, you could then compare serial numbers of your devices against the devices in ConfigMgr

    Super Easy.... but a lot of work: Manually send a team member on a mission to do a physical inventory, then compare results against CM.

    1 person found this answer helpful.
    0 comments