PENDING List User, Hostname and devices

[NABILIT]

hi Team
looking for report sccm to get user connected , ip, hosname and version OS please,
*
exampel i have this quiers to get all desktop using chassi , missing users
select SMS_R_System.Name, SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client, SMS_R_System.OSBranch, SMS_R_System.OperatingSystemNameandVersion from SMS_R_System inner join SMS_G_System_SYSTEM_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes in ("3","4","5","6","7","15","16")

 

[NABILIT]

i have this query report, how to add ip plz ?

Select distinct vrs.Name0, SCU.TopConsoleUser0, USR.User_Name0, -- USR.department,
CS.Manufacturer0, CS.Model0
from v_R_System VRS
JOIN v_UserMachineRelationship UMR ON vrs.ResourceID = UMR.MachineResourceID
JOIN v_GS_COMPUTER_SYSTEM CS on vrs.ResourceId = CS.ResourceID
JOIN v_R_User USR ON UMR.UniqueUserName = USR.Unique_User_Name0
JOIN v_GS_SYSTEM_CONSOLE_USAGE SCU on SCU.ResourceID = VRS.ResourceId
where SCU.TopConsoleUser0 = USR.Unique_User_Name0
ORDER BY VRS.Name0

 

[Garth]

i have this query report, how to add ip plz ?

Select distinct vrs.Name0, SCU.TopConsoleUser0, USR.User_Name0, -- USR.department,
CS.Manufacturer0, CS.Model0
from v_R_System VRS
JOIN v_UserMachineRelationship UMR ON vrs.ResourceID = UMR.MachineResourceID
JOIN v_GS_COMPUTER_SYSTEM CS on vrs.ResourceId = CS.ResourceID
JOIN v_R_User USR ON UMR.UniqueUserName = USR.Unique_User_Name0
JOIN v_GS_SYSTEM_CONSOLE_USAGE SCU on SCU.ResourceID = VRS.ResourceId
where SCU.TopConsoleUser0 = USR.Unique_User_Name0
ORDER BY VRS.Name0

What is wrong with this query? What is NOT working for you?

 

[NABILIT]

What is wrong with this query? What is NO working for you?

Hi this query works , and my need to add ip adresse

fing other query


select SMS_R_System.Name, SMS_R_System.SMSAssignedSites, SMS_R_System.IPAddresses, SMS_G_System_OPERATING_SYSTEM.Caption, SMS_R_System.OperatingSystemNameandVersion, SMS_G_System_SYSTEM_ENCLOSURE.Manufacturer, SMS_G_System_COMPUTER_SYSTEM.Model, SMS_G_System_SYSTEM_ENCLOSURE.SerialNumber, SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory, SMS_R_System.LastLogonUserName, SMS_R_System.ADSiteName from SMS_R_System inner join SMS_G_System_SYSTEM_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_X86_PC_MEMORY on SMS_G_System_X86_PC_MEMORY.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId


just remove memory and cpu usage , so this query it ok for me

 

[Garth]

The listed of supported SQL views can be found here https://docs.microsoft.com/en-us/me...ardware-inventory-views-configuration-manager

 

[NABILIT]

The listed of supported SQL views can be found here https://docs.microsoft.com/en-us/me...ardware-inventory-views-configuration-manager

thanks garth