0
/ConfigMgr_RDC/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602}
None
916c29cc-b2bb-44c4-9f6c-ca47b8737858
DataSource1
=Parameters!Software.Value
=Parameters!Version.Value
select
P.ResourceID
,S.Name0 'Computer Name'
,s.Operating_System_Name_and0 'Operating System'
,S.User_Name0 'User Name'
,P.DisplayName0 'Install application'
,P.Version0 'Version'
from v_Add_Remove_Programs P
left join v_R_System S on S.ResourceID = P.ResourceID
where (P.DisplayName0 like @Software)
--where (P.DisplayName0 like '%Java % Update %')
and p.Version0 like @Version
and s.Name0 is not null
ResourceID
System.Int32
Computer Name
System.String
Operating System
System.String
User Name
System.String
Install application
System.String
Version
System.String
DataSource1
=Parameters!Software.Value
=Parameters!Version.Value
select Distinct
P.DisplayName0 'Install application'
,P.Version0 'Version'
,Count(p.ProdID0) 'Count'
from v_Add_Remove_Programs P
left join v_R_System S on S.ResourceID = P.ResourceID
where (P.DisplayName0 like @Software)
--where (P.DisplayName0 like '%Java % Update %')
and p.Version0 like @Version
and s.Name0 is not null
gROUP BY p.ProdID0, P.DisplayName0,P.Version0
Install application
System.String
Version
System.String
Count
System.Int32
85.95158mm
57.9438mm
54.10416mm
6mm
true
true
Install application
Textbox5
#69be28
2pt
2pt
2pt
2pt
true
true
Version
Textbox2
#69be28
2pt
2pt
2pt
2pt
true
true
Count
Textbox3
#69be28
2pt
2pt
2pt
2pt
6mm
true
true
=Fields!Install_application.Value
Install_application
2pt
2pt
2pt
2pt
true
true
=Fields!Version.Value
Version
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Count.Value)
Count
2pt
2pt
2pt
2pt
After
Software
13.335mm
0mm
12mm
197.99954mm
true
true
Software on Systems
Title
ReportTitle
0mm
10.16mm
143.89538mm
1
2pt
2pt
2pt
2pt
85.95158mm
57.9438mm
54.10416mm
54.10416mm
45.90208mm
6mm
true
true
Computer Name
Textbox5
#69be28
2pt
2pt
2pt
2pt
true
true
User
Textbox2
#69be28
2pt
2pt
2pt
2pt
true
true
Operating System
Textbox3
#69be28
2pt
2pt
2pt
2pt
true
true
Install application
Textbox19
#69be28
2pt
2pt
2pt
2pt
true
true
Version
Textbox21
#69be28
2pt
2pt
2pt
2pt
6mm
true
true
=Fields!Computer_Name.Value
Install_application
2pt
2pt
2pt
2pt
true
true
=Fields!User_Name.Value
Version
2pt
2pt
2pt
2pt
true
true
=Fields!Operating_System.Value
Count
2pt
2pt
2pt
2pt
true
true
=Fields!Install_application.Value
Install_application1
2pt
2pt
2pt
2pt
true
true
=Fields!Version.Value
Version1
2pt
2pt
2pt
2pt
After
SystemsList
32.1mm
0mm
12mm
298.00578mm
2
48.15417mm
302.23911mm
11.43mm
true
true
true
true
=Globals!ExecutionTime
ExecutionTime
5.08mm
197.99954mm
6.35mm
100.00624mm
2pt
2pt
2pt
2pt
29.7cm
21cm
2cm
2cm
2cm
2cm
0.13cm
String
java%update %
Software
String
%
Version
Mm
http://zzzzzzzz/reportserver
909ed2dc-5eb1-44d7-b743-b4d8e3509754