question

Yekta-9996 avatar image
0 Votes"
Yekta-9996 asked saldana-msft edited

Report of workgroup computers with sccm

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?

mem-cm-generalsql-server-reporting-servicesmem-analytics-reporting
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

EswarKoneti-MVP avatar image
1 Vote"
EswarKoneti-MVP answered Yekta-9996 commented

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

There is no cm client installed on the workgroup computers, I tried this query but it was not worked correctly and this report shows only computers with sccm agent (Active, Inactive). Do you have any idea to get this report from sccm?

0 Votes 0 ·
GarthJones-MVP avatar image
1 Vote"
GarthJones-MVP answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YoussefSaad avatar image
2 Votes"
YoussefSaad answered

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!

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AllenLiu-MSFT avatar image
1 Vote"
AllenLiu-MSFT answered

@Yekta-9996
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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GaryBlok avatar image
1 Vote"
GaryBlok answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.