Windows way to Digital Learning……


To generate the report for the non Config Manager client PCs.

select
V_R_System.ResourceID,
V_R_System.ResourceType,
V_R_System.Name0,
V_R_System.SMS_Unique_Identifier0,
V_R_System.Resource_Domain_OR_Workgr0,
V_R_System.Client0
from
V_R_System
where
V_R_System.ResourceID not in (Select V_R_System.ResourceID from V_R_System where V_R_System.Client0 = 1)

 

Generated Report

SMSReporting

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Tag Cloud

%d bloggers like this: