Lookup a system in SCCM and shows last login data
0
/ConfigMgr_P01/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602}
None
efb25c8b-ee4e-4b48-aed0-ae77634aecc9
DataSource1
=Parameters!systemname.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 n.IPAddress0
FROM v_GS_NETWORK_ADAPTER_CONFIGURATION N
where N.IPAddress0 <> ''
and N.ResourceID = S.ResourceID
order by N.TimeStamp desc
) as 'IP Address'
,(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.ResourceID = @systemname
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
IP Address
System.String
User Name
System.String
eMail
System.String
DataSource1
=Parameters!system.Value
select distinct s.ResourceID,S.Name0
from v_R_System S
where s.Name0 not in ('','NULL')
and s.Name0 like ('%' + @system + '%' )
Name0
System.String
ResourceID
System.Int32
DataSource1
=Parameters!systemname.Value
select CM.ResourceID
,C.CollectionID
,C.Name
,d.PackageID
from v_FullCollectionMembership CM
left join v_Collection c on C.CollectionID = CM.CollectionID
left join v_DeploymentSummary D on D.CollectionID = C.CollectionID
--where CM.Name = 'ZABEVSPR1500D'
where CM.ResourceID = @systemname
-- and d.PackageID is not null
and
(C.Name like 'SD -%'
or C.Name like 'SU -%'
or C.Name like 'CG -%'
)
Order by C.Name
CollectionID
System.String
ResourceID
System.Int32
Name
System.String
PackageID
System.String
39.2875mm
40.875mm
54.89791mm
44.17918mm
54.89791mm
6mm
true
true
Computer Systems
Textbox1
#69be28
2pt
2pt
2pt
2pt
5
6mm
true
true
Last Logon
Textbox11
#69be28
2pt
2pt
2pt
2pt
true
true
System Name
Textbox25
#69be28
2pt
2pt
2pt
2pt
true
true
Operating System
Textbox15
#69be28
2pt
2pt
2pt
2pt
true
true
IP Address
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
2pt
2pt
2pt
2pt
true
true
=Fields!Operating_System.Value
Operating_System
2pt
2pt
2pt
2pt
true
true
=Fields!IP_Address.Value
IP_Address
2pt
2pt
2pt
2pt
true
true
=Fields!Site.Value
SCCM
2pt
2pt
2pt
2pt
After
After
Computers
31.93194mm
0mm
18mm
234.1375mm
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
194.85mm
6mm
true
true
Collections
Textbox1
#69be28
2pt
2pt
2pt
2pt
6mm
true
true
=Fields!Name.Value
name
2pt
2pt
2pt
2pt
6mm
true
true
SD - Software Distribution
SU - Software Updates
CG - Container Group
Textbox12
2pt
2pt
2pt
2pt
After
Before
Collections
55.38889mm
39.2875mm
18mm
194.85mm
2
73.74444mm
244.85623mm
14.55208mm
true
true
true
true
System lookup
Textbox13
0mm
39.2875mm
11.64167mm
139.95209mm
#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
234.1375mm
2pt
2pt
2pt
2pt
297mm
210mm
20mm
20mm
20mm
20mm
0.13cm
String
System Name
True
String
System Name
SystemNames
ResourceID
Name0
Mm
http://zapdsqlsccm01/ReportServer
93e7e180-6894-4461-9033-f67983546358