in

myITforum.com
All Tags » SMS 2003 » SMS » SMS Web Reports (RSS)

Browse by Tags

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

    THIS IS THE CODE FOR THIS ARTICLE 1) SCRIPT TO CREATE SCALAR-VALUED USER DEFINED FUNCTION : udf_ItemExtract() -- ============================================= -- Author: John Nelson (Number2) -- Create date: 2007-05-26 -- Description: Given a delimited list, a position and a delimiter, extract the string...
    Posted to Number2 Blog - MyITForum.com (Weblog) by jnelson on 11-15-2007
    Filed under: SMS, UDF, user defined functions, SMS 2003, SMS Web Reports, web report, webreport, smsschm_users, grant select, scalar-valued user defined function, webreport_approle, grant, outlook, grant execute

  • SMS 2003 Database - Where can I find things?

    Here is a list of common items that people want to query for and some locations they're found in the SMS database I'm basing this on SMS 2003, we have SP3+ Depending on your setup, you may not have some of these views in your environment or they may be empty. You may also find other places where...
    Posted to Number2 Blog - MyITForum.com (Weblog) by jnelson on 01-22-2008
    Filed under: SMS, SMS 2003, SMS Web Reports, web reports, views

  • 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
Page 1 of 1 (3 items)
Copyright - www.myITforum.com, Inc. - 2007 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems