SMS Web Reports – Using a list to run a report or defining more than one variables for the web report prompt
From the archive (2009). Written for the tools of the time, so some details may be out of date.
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