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
CODE - SQL for SMS/SCCM - How to get the CORRECT order when sorting on version numbers like xx.xx.xx.xx

This is the SQL code for THIS ARTICLE SNIPPET #2 - UDF_ITEMEXTRACT - SQL FUNCTION TO EXTRACT AN ITEM OUT OF A DELIMITED LIST -- ============================================= -- Author: John Nelson (Number2) -- Create date: 2007-05-26 -- Description: Given a delimited list, a position and a delimiter...

Posted to Number2 Blog - MyITForum.com (Weblog) by jnelson on 11-13-2007
Filed under: SQL, SMS, SMS 2003, outlook, udf_ItemExtract, v_ProductFileInfo, INT, BIGINT, CAST, itemExtract, order by, sql 2005, v_GS_SoftwareFile, SUBSTRING, CHARINDEX, sorting, v_GS_SoftwareProduct
Sccm, Scom, Remote SQL 2005 & the Windows server 2008 firewall

Hi All, Let's start by saying that this blog post is probably more OpsMgr related, but all topics are valid for a remote SQL Install for Sms, SCCM or any of the other System center products, so I guess it's still ok to post it here. Look, I am not all that good with popular quotes, never seem...

Posted to SCUG (Weblog) by Anonymous on 07-29-2008
Filed under: smsv4, Operations Manager 2007, SCCM 2007, sms v4, configmgr2007, sccm2007, Configmgr 2007, SMS, Opsmgr 2007, SCOM 2007, MOM, Sms 2003
Building a custom Configmgr 2007 admin console

The work that needs to be done in the Configuration manager 2007 admin console is often spread out amongst different team members. Not all of these team members require access to the full admin console. Most environments do configure the permission set in a somewhat restrictive member so that team members...

Posted to SCUG (Weblog) by Anonymous on 07-16-2008
Filed under: smsv4, SCCM 2007, sms v4, configmgr2007, sccm2007, Configmgr 2007, SMS, Sms 2003
M@d Skillz - Use data outside the SMS DB in your SMS Web Reports

OVERVIEW (note: this is written with SMS 2003 & SQL 2005 in mind because that's the environment I'm in right now, but I believe if the equivalent work was done in SCCM or in SQL 2000, the outcome would be the same...just a hunch) If you're like any normal SMS administrator, you've...

Posted to Number2 Blog - MyITForum.com (Weblog) by jnelson on 04-04-2008
Filed under: SMS, SMS 2003, web reports, ANSI_NULLS, ANSI_WARNINGS, External data, Linked Server, Heterogeneous queries, Distributed Queries, stored procedures
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
UPDATE - SMS 2003 - Selecting from v_Add_Remove_Programs still slow, even after applying 939872

I previously wrote an article talking about the slowness we were having even after applying 939872 --> HERE There are some additional things I'd like to mention: We have reorganized the data in the Add/Remove Programs tables based on the DisplayName, Publisher, etc. since that's 98% of what...

Posted to Number2 Blog - MyITForum.com (Weblog) by jnelson on 01-02-2008
Filed under: SQL, SMS, SMS 2003, Add_Remove_Programs_Data, performance tips, scalar-valued user defined function, add remove programs, add_remove_programs_64_data, indexes, v_add_remove_programs
SMS 2003 - Selecting from v_Add_Remove_Programs still slow, even after applying 939872

!!!! UPDATE !!!! WHEN YOU'RE DONE, THIS ARTICLE HAS BEEN UPDATED --> HERE PROBLEM I don't know if this is a function of the massive size of our SMS environment (100-200K clients) or if others are having this problem still, but after following the steps in KB 939872 , we're still seeing...

Posted to Number2 Blog - MyITForum.com (Weblog) by jnelson on 12-27-2007
Filed under: SQL, SMS, SMS 2003, Add_Remove_Programs_Data, performance tips, scalar-valued user defined function, add remove programs, add_remove_programs_64_data, indexes, v_add_remove_programs
SMS - #2's #1 suggestion - Learn to read/write WQL/SQL by hand

My #1 suggestion after years of working with SMS/SQL/WQL and then coaching/mentoring/training people is that it REEEALLLY pays to know how to read/write SQL/WQL by hand. I know, there are those people who don't type well and those people who haven't learned how to really read and understand SQL...

Posted to Number2 Blog - MyITForum.com (Weblog) by jnelson on 12-27-2007
Filed under: SQL, SMS, SMS 2003, performance tips, aliases, WQL, beautifier, query desiger, sms 2.0, query builder, sms 1.2

Page 1 of 3 (30 items) 1 2 3 Next >