Browse by Tags

All Tags » web reports (RSS)

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 Web Report (SQL 2005+) - Show SMS program execution chaining hierarchy visually using CTE (Common Table Expressions) in SQL 2005+ by jnelson

In response to a request on the forums, here's a SQL query that uses common table expressions (CTE) to visually return the program execution chain...

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

M@d Skillz - SMS Status Messages - ASP to show all MessageIDs and their meanings by jnelson

THE PROBLEM So I'm digging through the SMS status message views (v_StatusMessage, v_StatMsgAttributes, v_StatMsgInsStrings, v_StatMsgModuleNames) to...

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

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

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

Update - Rewritten for SQL 2000 - SMS 2003 - Getting information about advertisements when package or ad has been deleted by jnelson

Apparently there are enough people that still have SQL 2000 that I get hounded with questions whenever I post something that only works on SQL 2005, which...

M@d Skillz - SMS Permissions - BITWISE "AND" with a PIVOT thrown in for pretty :) by jnelson

M@d SKILLZ ARTICLE ALERT! (This is gonna get cr@zy, if you have a helmet, now's the time to put it on) So I was trolling the forums here on MyITForum...

SQL Performance - Indexes and the LIKE clause by jnelson

INDEXES AND THE LIKE CLAUSE Often times, people will make the generalization that when you have LIKE in your WHERE clause it won't use indexes. The...
Powered by Community Server (Commercial Edition), by Telligent Systems