sql 2005,Microsoft Systems Management Server - Number2 Blog

Browse by Tags

All Tags » sql 2005 » Microsoft Systems Management Server (RSS)

M@d Skillz - SMS Web Reports - Passing a delimited list to SMS Web Reports like a table - (also convert list to rows in SQL) by jnelson

BACKGROUND Pass multiple items into a single parameter? With SMS Web reports, there's a lot of power in being able to pass parameters to your report...

Filed under: SMS, UDF, user defined functions, SMS 2003 SP3, SMS 2003, SMS 2003 SP2, Microsoft Systems Management Server, SMS Web Reports, web report, webreport, smsschm_users, webreport_approle, sql 2005, web reports, user defined function, sms report, sms 2.0, sms 1.2, list to rows, udf_Split, delimited list, list to table, list to column

SMS Web Report - Outlook machine counts by version (Plus a trick to order by version PROPERLY) by jnelson

RECOMMENDED READING First of all, you should read this article I wrote entitled " How to get the CORRECT order when sorting on version numbers like...

Filed under: SQL, SMS, SMS 2003, Microsoft Systems Management Server, web report, webreport, outlook, v_ProductFileInfo, BIGINT, CAST, itemExtract, sql 2005, v_GS_SoftwareFile, v_GS_SoftwareProduct, GROUP BY, DISTINCT

Number2 Blog - myITforum

Search

Tags

News

Navigation

Archives

Browse by Tags

M@d Skillz - SMS Web Reports - Passing a delimited list to SMS Web Reports like a table - (also convert list to rows in SQL) by jnelson

SMS Web Report - Outlook machine counts by version (Plus a trick to order by version PROPERLY) by jnelson