PENDING List User, Hostname and devices

NABILIT

Member
5
0
1
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")
 
OP
NABILIT

NABILIT

Member
5
0
1
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

Well-Known Member
Staff member
1,187
104
63
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 NO working for you?
 
OP
NABILIT

NABILIT

Member
5
0
1
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
 

Forum statistics

Threads
4,615
Messages
18,061
Members
9,325
Latest member
ServerTUNAz