My SCCM 2007 SQL Web Report is not displaying results -


i created sccm sql report using sql management studio. created following prompts asset management office use on web report: publisher, display name, , version.

the display name , version prompts both optional.

i receive no syntax errors or anything, receive absolutely no results whatsoever when click on display button produce web report.

here sql code:

==================================================================================

select dbo.v_r_system.netbios_name0, dbo.v_gs_add_remove_programs.displayname0, dbo.v_gs_add_remove_programs.version0, dbo.v_gs_add_remove_programs.publisher0

from dbo.v_r_system inner join dbo.v_gs_add_remove_programs on dbo.v_r_system.resourceid = dbo.v_gs_add_remove_programs.resourceid

where dbo.v_gs_add_remove_programs.displayname0 = @displayname , dbo.v_gs_add_remove_programs.version0 = @version , dbo.v_gs_add_remove_programs.publisher0 = @publisher

order by dbo.v_gs_add_remove_programs.displayname0 asc

==================================================================================

i run report , in publisher prompt, type in %autodesk% , click display button, , absolutely nothing displayed. can go report , autodesk products, not one. not versed sql guy, if can me great.

thanks

% signs mean wildcards. used keyword. have equal signs. in other words,

where displayname '%fred%' 

will return fred, freddie, frederick, etc. however,

where displayname = '%fred%' 

will return %fred%


Comments

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

css - Make div keyboard-scrollable in jQuery Mobile? -

ruby on rails - Seeing duplicate requests handled with Unicorn -