This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 5%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
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 ?
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
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 .. :(
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
Thank you for your help .. :)