PENDING Script for Sccm client online machines

[Sridharrandy]

Hi Everyone,

I need your help on the below.

Please provide me the script for taking only sccm client online machines.

How to fetch this report through script?

 

[Youssef Saad]

I don't think if there is a script to have only online devices, but you can have a collection with active clients (customers who are connected for 7 days (by default).

 

[Prajwal Desai]

Hi Everyone,

I need your help on the below.

Please provide me the script for taking only sccm client online machines.

How to fetch this report through script?

What Configuration Manager version are you using ?.

 

[Sridharrandy]

1806

 

[Sridharrandy]

help me

 

[Prajwal Desai]

You can use the below script and let me know if that is what you wanted.

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.ResourceId in (select SMS_R_System.ResourceID from SMS_R_System inner join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceID = SMS_R_System.ResourceID where DATEDIFF(dd,SMS_G_System_WORKSTATION_STATUS.LastHardwareScan,GetDate()) < 90)