November 2007 - Posts - Number2 Blog

0
Comments

Number2 Links - Links/Aliases to everything Number2 by jnelson

FYI, I've set up some aliases/shortcuts to all my Number2 stuff so I can get to it quickly from anywhere on the web. In case anyone else wants this...

Filed under: contact information, aliases, email, shortcuts, number2

1
Comments

SQL for SMS - Concatenate MAC addresses and IP Addresses into their own columns by jnelson

If you've ever written a report that also selects IP addresses or MAC addresses, you've noticed that there can be multiple addresses per machine...

Filed under: SQL, SMS, UDF, SMS 2003, web report, sql 2005, SQL 2000, ip address, mac address, user defined function, FOR XML PATH, sms report

1
Comments

M@d Skillz Update - Revised for SQL 2000 - Manual PIVOT by jnelson

You know, I got to thinking about yesterday's first-ever M@d Skillz article after Tom Watson lamented the fact that he's got SQL 2000 and it could...

Filed under: SQL, PIVOT, web report, order by, GROUP BY, v_UserClassPermissions, v_SecuredObject, view, bitwise and, case, SQL 2000

1
Comments

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

Filed under: SQL, SMS, PIVOT, SMS 2003, sql 2005, web reports, inner join, BYTE, v_UserClassPermissions, table, MAX, v_SecuredObject, forums, sms permissions, view, bitwise and, BIT

1
Comments

M@d Skillz - Introducing a new degree of difficulty by jnelson

I've been getting some positive feed back on how much detail I've been putting into my posts and how appreciative people are that I include the...

Filed under: SQL, SCCM, SMS, SCOM, shell scripting, Winbatch, batch scripting, powershell, scripting, vbscript

0
Comments

SQL Oddity - OUTER JOINs with criteria act like INNER JOIN by jnelson

SYMPTOMS You have a query with an OUTER JOIN (aka LEFT JOIN, RIGHT JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN), and you need to put filter criteria on the...

Filed under: SQL, SMS, SMS 2003, sql 2005, v_GS_SoftwareFile, right outer join, inner join, right join, join, v_FullCollectionMembership, left outer join, outer join, V_R_System, left join

1
Comments

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

Filed under: SQL, SMS, table scan, clustered index seek, SMS 2003, index, sql 2005, LIKE, web reports, clustered index scan, index scan, wildcard, index seek

2
Comments

SMS Web Report - Outlook machine counts by version (Plus a trick to order by version PROPERLY) by jnelson

RECOMMENDED READING First of all, you should read this article I wrote entitled " How to get the CORRECT order when sorting on version numbers like...

Filed under: SQL, SMS, SMS 2003, Microsoft Systems Management Server, web report, webreport, outlook, v_ProductFileInfo, BIGINT, CAST, itemExtract, sql 2005, v_GS_SoftwareFile, v_GS_SoftwareProduct, GROUP BY, DISTINCT

2
Comments

SQL for SMS/SCCM - How to get the CORRECT order when sorting on version numbers like xx.xx.xx.xx by jnelson

(UPDATE: This post was updated 2008-08-16. Skip to the end to see the update) THE PROBLEM Let's say you query SMS to find all versions of Outlook you...

Filed under: SQL, SMS, SMS 2003, outlook, udf_ItemExtract, v_ProductFileInfo, INT, BIGINT, CAST, itemExtract, order by, sql 2005, v_GS_SoftwareFile, SUBSTRING, CHARINDEX, sorting, v_GS_SoftwareProduct

Number2 Blog - myITforum

Search

Tags

News

Navigation

Archives