Lookup User in SCCM and systems user have been log in on.
0
/ConfigMgr_P01/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602}
None
efb25c8b-ee4e-4b48-aed0-ae77634aecc9
DataSource1
=Parameters!username.Value
select top 10
s.ResourceID
,S.Name0 System
,OS.Caption0 'Operating System'
,Last_Logon_Timestamp0 as LastLogonDay
,S.User_Name0 UserID
,(select top 1 C.Name
from v_FullCollectionMembership M
left join v_Collection C on C.CollectionID = m.CollectionID
where M.ResourceID = s.ResourceID
and c.Name like 'Site - %'
) Site
,U.Full_User_Name0 'User Name'
,U.Mail0 eMail
from v_R_System S
Left Join v_R_User U on u.User_Name0 = S.User_Name0
left join v_GS_OPERATING_SYSTEM OS on os.ResourceID = S.ResourceID
--where S.Name0 = 'zabevspr5273d'
--where s.User_Name0 = 'dngc006'
where s.User_Name0 = @username
Order by s.Last_Logon_Timestamp0 desc
true
System
System.String
ResourceID
System.Int32
LastLogonDay
System.DateTime
Operating System
System.String
UserID
System.String
Site
System.String
User Name
System.String
eMail
System.String
DataSource1
=Parameters!User.Value
select distinct U.User_Name0
from v_R_User U
where U.User_Name0 not like '$%'
and U.User_Name0 like ( '%' + @User + '%')
User_Name0
System.String
39.2875mm
40.875mm
54.89791mm
54.89791mm
6mm
true
true
Known Computer Systems
Textbox1
#69be28
2pt
2pt
2pt
2pt
4
6mm
true
true
Date
Textbox11
#69be28
2pt
2pt
2pt
2pt
true
true
System Name
Textbox25
#69be28
2pt
2pt
2pt
2pt
true
true
Operating System
Textbox1
#69be28
2pt
2pt
2pt
2pt
true
true
Site
Textbox27
#69be28
2pt
2pt
2pt
2pt
6mm
true
true
=Fields!LastLogonDay.Value
name
2pt
2pt
2pt
2pt
true
true
=Fields!System.Value
AD
System Lookup
=Fields!System.Value
=Fields!ResourceID.Value
2pt
2pt
2pt
2pt
true
true
true
=Fields!Operating_System.Value
Operating_System
2pt
2pt
2pt
2pt
true
true
=Fields!Site.Value
SCCM
2pt
2pt
2pt
2pt
After
After
Computers
31.93194mm
0mm
18mm
189.95832mm
39.2875mm
95.77291mm
6.08542mm
true
true
User Information
Textbox3
#69be28
2pt
2pt
2pt
2pt
2
6mm
true
true
User ID
Textbox9
#69be28
2pt
2pt
2pt
2pt
true
true
=Fields!UserID.Value
UserID
2pt
2pt
2pt
2pt
6mm
true
true
User Name
Textbox14
#69be28
2pt
2pt
2pt
2pt
true
true
=Fields!User_Name.Value
User_Name
2pt
2pt
2pt
2pt
6mm
true
true
User email
Textbox16
#69be28
2pt
2pt
2pt
2pt
true
true
=Fields!eMail.Value
eMail
2pt
2pt
2pt
2pt
Computers
2.3495mm
0mm
24.08542mm
135.06041mm
1
53.10694mm
226.86459mm
14.55208mm
true
true
true
true
User lookup
Textbox13
0mm
39.2875mm
11.64167mm
133.47291mm
#69be28
2pt
2pt
2pt
2pt
25.05mm
true
true
true
true
Please note:
--
Blank means no data availible.
--
The date is the last known logon. Some deviations are expected.
Textbox35
1.05833mm
0mm
23.99167mm
179.23959mm
2pt
2pt
2pt
2pt
297mm
210mm
20mm
20mm
20mm
20mm
0.13cm
String
UserName
True
String
UserName
UserNames
User_Name0
User_Name0
Mm
http://zapdsqlsccm01/ReportServer
93e7e180-6894-4461-9033-f67983546358