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)

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 query and have it substitute those values into the SQL code. It really saves you a lot of time not having to write your own front end for your SQL queries...

Posted to Number2 Blog - MyITForum.com (Weblog) by jnelson on 01-16-2008
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 2003 SP2+ - Tables named DWTbl%Del getting big or growing fast

So, if you saw my article on tracking table size growth/shrinkage (or if you've been doing that yourself) you may have noticed that one or more of the following SMS tables are getting quite big and you're not sure why or what they're used for: DWTbl_System_Disc_Del DWTbl_User_Disc_Del DWTbl_User_Group_DISC_Del...

Posted to Number2 Blog - MyITForum.com (Weblog) by jnelson on 10-15-2007
Filed under: SMS, Table size, TRUNCATE, DWTbl_CollectionMembers_Del, DWTbl_User_Disc_Del, SMS 2003 SP3, DWTbl_SoftwareInventory_Del, DWTbl_System_Disc_Del, SMS 2003, SMS 2003 SP2, Microsoft Systems Management Server, DWTbl_User_Group_DISC_Del, DWTbl_PatchStatusSummary_Del

Page 1 of 1 (2 items)

myITforum.com

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)

SMS 2003 SP2+ - Tables named DWTbl%Del getting big or growing fast