Browse by Tags

All Tags » SMS (RSS)

ConfigMgr/SMS - Query to enumerate the ProgramFlags (from v_Program) by jnelson

I know you've looked at the ProgramFlags field from v_Program and wondered what the heck those crazy numbers mean. Well, each bit (it's a 32-bit...

SMS/ConfigMgr - Refresh/Recompile Views to Keep MetaData in Sync by jnelson

THE ISSUE SMS & ConfigManager (Microsoft Systems Management Server & Microsoft System Center Configuration Manager) are wonderful at dealing with...

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 - Query to pull logged on user records from all sources by jnelson

I was trolling the forums lately on MyITForm.com and was reading some conversations about logged on user records. It made me think of all the sources where...
Filed under: , ,

SMS/SCCM vs Promisec Spectator - Part 2 of 2 (The rebuttal) by jnelson

If you read my previous post on the blood-boiling comparison between SMS/SCCM & Promisec Spectator, you've likely developed all kinds of responses...
Filed under: , ,

SMS/SCCM vs Promisec Spectator - Part 1 of 2 (Their Comparison) by jnelson

If you're an SMS or SCCM guy and you want to get your blood boiling, just look at this writeup the people at Promisec created that compares SMS to...
Filed under: , ,

SMS/SCCM & Batch Files - Important notes on running .BAT files from UNC in SMS/SCCM by jnelson

THE PROBLEM When you run a .BAT file from a UNC path, the first thing you might notice is the warning about "UNC paths are not supported. Defaulting...

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

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

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...
More Posts Next page »
Powered by Community Server (Commercial Edition), by Telligent Systems