SMS Web Reports – Using a list to run a report or defining more than one variables for the web report prompt
I was recently working on trying to find a way to return the computer names for a given set of user names. This is pretty easy to do from query analyzer, but i wanted to create a web report that anyone could run.
The web report prompt would allow a pasted value of:
John.doe,jane.moe
And the resultant query to be executed would be:
select sys.user_name0, sys.netbios_name0
from v_r_system sys
where sys.user_name0 IN ('john.doe','jane.moe')
I wasn’t quite sure how to do this and i knew there were some limitations from the SQL standpoint and SMS web reports standpoint.
Below is a fantastic post from Number 2 that pretty much answers all the questions i had.
http://myitforum.com/cs2/blogs/jnelson/archive/2008/01/16/111355.aspx