October 2008 - Posts

3
Comments

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

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

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

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

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

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