Number2 Blog - myITforum

UPDATE - ConfigMgr 2007 - Dynamic SQL to show missing hardware inventory

jnelson — Fri, 13 Mar 2009 18:05:00 GMT

UPDATE: This is an update to yesterday's post which used dynamic SQL to show missing hardware inventory in ConfigMgr. I noticed that we had like 95+ classes, but many of them had NO records for any...(read more)

M@d Skillz - ConfigMgr 2007 - Dynamic SQL to show missing hardware inventory

jnelson — Fri, 13 Mar 2009 00:23:00 GMT

My fellow ConfigMgr MVP Torsten Meringer hit me up with an interesting question this morning. He wanted to identify those machines that are missing hardware inventory. He mentioned the v_GroupMap view...(read more)

SMS/ConfigMgr - Create status MIFs using batch script with no dependencies

jnelson — Tue, 13 Jan 2009 20:39:00 GMT

In a past position, I've tried to use a utility from the Back Office Resource Kit called ismif32.exe to create status MIFs for those programs that aren't MSI-based or don't have the ability...(read more)

Digital Decor - Digital Pocket Viewer - How to get it to work (DPCI: 056-13-0705) (ASIN: B001GN416O) (Catalog #: 11018416)

jnelson — Sat, 27 Dec 2008 17:39:00 GMT

OVERVIEW So, it's Christmas time and you've either just received or just given the perfect $20 gift, a digital pocket viewer like the one from Digital Decor that you can find at Target DPCI: 056...(read more)

Calculate a client's subnet mask when defining subnet boundaries (using BITWISE AND "&" in SQL)

jnelson — Wed, 29 Oct 2008 19:36:00 GMT

OVERVIEW I was recently pointed to Jeff Gilbert's blog where he has an article on determining a client's subnet mask and using them in subnet boundaries. http://myitforum.com/cs2/blogs/jgilbert...(read more)

WQL - Using the bracket wildcard to match a range of version numbers (MNSCUG)

jnelson — Fri, 17 Oct 2008 06:23:00 GMT

At the Minneapolis area System Center User Group meeting last night, I mentioned the notion of using LIKE and the bracket wildcard [] to match a range of version numbers (which incidentally works for versions...(read more)

SMS 2003 - SQL to compare software on two systems

jnelson — Thu, 16 Oct 2008 03:34:00 GMT

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

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

jnelson — Thu, 02 Oct 2008 16:39:00 GMT

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 report output as "Operating System". The...(read more)

SMS 2003 - Query to pull logged on user records from all sources

jnelson — Thu, 28 Aug 2008 19:31:00 GMT

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 you could get that information. Off the top of...(read more)

SQL/WQL Tip - How to escape special SQL/WQL wildcard characters like % _

jnelson — Wed, 27 Aug 2008 07:31:00 GMT

THE PROBLEM You've written a SQL query or a WQL query (like an SMS/CM collection query) and you need to look for a string that has a percent % or underscore _ in it. The problem is, those characters...(read more)

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

jnelson — Fri, 22 Aug 2008 15:12:00 GMT

If you read my previous post on the blood-boiling comparison between SMS/SCCM & Promisec Spectator, you've likely developed all kinds of responses in your head about how they're so wrong on...(read more)

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

jnelson — Fri, 22 Aug 2008 14:55:00 GMT

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 their Promisec Spectator. I mean no disrespect to...(read more)

SQL 2005 Security - Revoke EXECUTE rights for PUBLIC on (potentially) unsafe extended stored procedures

jnelson — Sat, 16 Aug 2008 06:15:00 GMT

Where I work, we have an amazing crew of security architects and analysts who have decades of experience in all things security. Sure, at times they may seem paranoid, but that's just because they've...(read more)

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

jnelson — Fri, 15 Aug 2008 21:31:00 GMT

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 to the Windows Directory" All this really...(read more)

Troubleshooting 301 - Finding a needle (bad program) in a haystack (list of 150 programs) in 7 tries.

jnelson — Wed, 16 Jul 2008 20:06:00 GMT

THE PROBLEM Stay with me on this one, I think it's a concept that every techie should understand and use at some point in their careers. The problem goes like this: There's one program somewhere...(read more)

SMS Web Report (SQL 2005+) - Show SMS program execution chaining hierarchy visually using CTE (Common Table Expressions) in SQL 2005+

jnelson — Fri, 20 Jun 2008 00:10:00 GMT

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 hierarchy. (something like this) 00000000 - ProgramA...(read more)

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

jnelson — Thu, 05 Jun 2008 01:05:00 GMT

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 to is how fragile WMI seems. After some great conversations...(read more)

SCCM 2007 - SCCM Permissions Matrix

jnelson — Fri, 30 May 2008 17:38:00 GMT

This SQL query pulls all SCCM permissions for each user and displays them in a matrix. Put this into an SCCM Web report. This should work for SQL 2000, SQL 2005 and higher. SELECT UCP.UserName, SO.ObjectName...(read more)

SMS 2003 - SMS Permissions Matrix

jnelson — Fri, 30 May 2008 17:32:00 GMT

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 2005 and higher. SELECT UCP.UserName, SO.ObjectName...(read more)

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

jnelson — Wed, 21 May 2008 05:23:00 GMT

THE PROBLEM So I'm digging through the SMS status message views (v_StatusMessage, v_StatMsgAttributes, v_StatMsgInsStrings, v_StatMsgModuleNames) to find some pretty specific data to do my job, but...(read more)

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

jnelson — Fri, 04 Apr 2008 05:32:00 GMT

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...(read more)

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

jnelson — Wed, 02 Apr 2008 07:06:00 GMT

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 month and was looking for ideas. I wrote a first...(read more)

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

jnelson — Thu, 27 Mar 2008 14:45:00 GMT

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 on an x64 server in SMS 2003. Now, I'm sure...(read more)

Perfmon - Common counters to find bottlenecks on a server with SQL (SMS/SCCM/SCOM)

jnelson — Wed, 26 Mar 2008 18:10:00 GMT

I'm seriously busy right now at my day job so I don't have time to get cr@zy with the det@ilz, but I would like to quickly post the Perfmon counters I use if I want to determine if a server has...(read more)

WinBatch - Script to add boundaries to SMS

jnelson — Mon, 17 Mar 2008 14:56:00 GMT

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 for SMS 2.0 and SMS 2003 RTM. The purpose of it...(read more)

VBScript - Script to export SMS Web report results to a CSV file

jnelson — Mon, 10 Mar 2008 18:01:00 GMT

THE PROBLEM You want to automatically run a set of SMS Web reports, but you don't have something like SQL Server Reporting Services installed (which would give you the ability to have people subscribe...(read more)

Windows Shell Script - Better way to run CMD as System

jnelson — Fri, 15 Feb 2008 17:00:00 GMT

Most people are familiar with using AT to open a command prompt as SYSTEM (LOCAL SYSTEM) at 11:05 /interactive cmd.exe This will open a command prompt as system (or actually, as whatever account the task...(read more)

SMS 2003 Database - Where can I find things?

jnelson — Wed, 23 Jan 2008 05:57:00 GMT

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...(read more)

M@d Skillz - SMS Web Reports - Passing a delimited list to SMS Web Reports like a table - (also convert list to rows in SQL)

jnelson — Wed, 16 Jan 2008 11:25:00 GMT

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...(read more)

SQL Function - Convert Bytes to KB, MB, GB, TB, PB or EB and format the output to human readable format

jnelson — Fri, 11 Jan 2008 07:14:00 GMT

When you query a bunch of SMS/SCCM data that has it's output in bytes or KB or MB, often times you want that expressed in a more human readable format. This function takes 2 parameters: a number, and...(read more)