SSRS report for Co managed devices

Question

question

TusharDebnath-8752 asked May 11, '22 saldana-msft edited 3 days ago

SSRS report for Co managed devices

Hi ,

I am looking for a custom SSRS report to show me the SCCM Co-managed devices exist in a collection specific .Can someone help me to give me a SQL report please ?

mem-intune-device-configurations mem-cm-co-management mem-analytics-reporting

5 |1600 characters needed characters left characters exceeded

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

Answer 1 · 2022-05-11T14:35:16.807Z

EswarKoneti-MVP answered May 11, '22

you can add a new column/attribute with co-managed in the device section, it will show Yes or No. Have you tried this?

Regards,
Eswar
www.eskonr.com

image.png (9.7 KiB)

5 |1600 characters needed characters left characters exceeded

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

Answer 2 · 2022-05-11T17:39:27.197Z

TusharDebnath-8752 answered May 11, '22 EswarKoneti-MVP commented May 12, '22

Thanks a lot for the response .. Yes I am aware of this settings .. But My project needs a SSRS report so that unnecessary console access should be restricted .. :(

· 1

5 |1600 characters needed characters left characters exceeded

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

EswarKoneti-MVP · May 12 at 02:41 AM

For SSRS report, the co-management information is stored in SQL table ClientCoManagementState. You try something the SQL code something like below, but you can expand this further to get more data from various SQL views.

SELECT
sv.Netbios_Name0,
ClientCoManagementState.ComgmtEnabled,
ClientCoManagementState.CoMgmtWorkloadFlags,
ClientCoManagementState.MDMEnrolled,
ClientCoManagementState.ComgmtPolicyReceived,
ClientCoManagementState.LastMessageTime,
ClientCoManagementState.LastMessageStateID,
ClientCoManagementState.MDMRegistrationKind,
ClientCoManagementState.ScheduledEnrollTime,
ClientCoManagementState.EnrollmentBeginTime,
ClientCoManagementState.EnrollmentEndTime,
ClientCoManagementState.EnrollmentStatusCode,
ClientCoManagementState.EnrollmentErrorDetail
FROM
ClientCoManagementState
INNER JOIN v_R_System_Valid sv ON ClientCoManagementState.MachineID = sv.ResourceID

Thanks,
Eswar

1 ·

Answer 3 · 2022-05-12T13:50:35.057Z

TusharDebnath-8752 answered May 12, '22

Thank you for your help .. :)

5 |1600 characters needed characters left characters exceeded

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

question