Browse by Tags

All Tags » SMS 2003 (RSS)

SMS 2003 - SQL to compare software on two systems by jnelson

OVERVIEW You want to look at the difference in software between 2 computers, but you either don't have Desired Configuration Management (DCM) implemented...

SMS 2003 - What do those C054 columns mean in reports? (Localized Name Lookup) by jnelson

If you look at certain pre-canned reports that come with SMS 2003, you'll notice some of them have wierd column names like C054, but show up in the...

SMS 2003 - Verify WMI Stability Backport on Windows XP/Server 2003 with this report SQL (deploy to them with this collection query WQL) by jnelson

BACKGROUND (click HERE to skip to the summary) I've been looking into our client health a lot deeper recently and something that I keep coming back...
Filed under: , , ,

SMS 2003 - SMS Permissions Matrix by jnelson

This SQL query pulls all SMS permissions for each user and displays them in a matrix. Put this into an SMS Web report. This should work for SQL 2000, SQL...

M@d Skillz - Use data outside the SMS DB in your SMS Web Reports by jnelson

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...

VBScript - (UPDATED) Script to export SMS Web report results to an Excel spreadsheet by jnelson

BACKGROUND In a previous post I created a VBScript in response to a discussion in the forums where somebody wanted to automatically run a report once per...

SMS 2003 Performance - The performance benefits of an x64 DP in a busy SMS 2003 hierarchy by jnelson

QUICK BACKGROUND Although x64 is officially unsupported in SMS 2003 for any site components, the reality is that you CAN put the Distribution Point role...

WinBatch - Script to add boundaries to SMS by jnelson

This is a VERY old script I wrote in 2000 for SMS 2.0, that I've used for SMS 2003 too. I have no idea how well it works anymore, but I know it worked...

SMS 2003 Database - Where can I find things? by jnelson

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,...

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...

UPDATE - SMS 2003 - Selecting from v_Add_Remove_Programs still slow, even after applying 939872 by jnelson

I previously wrote an article talking about the slowness we were having even after applying 939872 --> HERE There are some additional things I'd...

SMS 2003 - Selecting from v_Add_Remove_Programs still slow, even after applying 939872 by jnelson

!!!! 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...

SMS - #2's #1 suggestion - Learn to read/write WQL/SQL by hand by jnelson

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...

SMS 2003 - ITMU Patch Data - Service Packs and other low severity patches show up multiple times by jnelson

SYMPTOMS You're trying to determine your patch compliance for the latest round of Microsoft patches, but you notice that if you include low severity...

SMS 2003 - Getting information about advertisements when package or ad has been deleted by jnelson

THE PROBLEM There are canned reports that come with SMS that let you see advertisements and the machines that were targeted and the package that was sent...
More Posts Next page »
Copyright - www.myITforum.com, Inc. - 2010 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems