Browse by Tags

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

This is the SQL code for THIS ARTICLE SNIPPET #2 - UDF_ITEMEXTRACT - SQL FUNCTION TO EXTRACT AN ITEM OUT OF A DELIMITED LIST -- ============================================= -- Author: John Nelson (Number2) -- Create date: 2007-05-26 -- Description: Given a delimited list, a position and a delimiter...

Posted to Number2 Blog - MyITForum.com (Weblog) by jnelson on 11-13-2007
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
SMS Web Report - Outlook machine counts by version (Plus a trick to order by version PROPERLY)

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 xx.xx.xx.xx " That article lays out a good explaination of the V_ProductFileInfo view, the CAST(dbo.udf_ItemExtract()) stuff, and information on...

Posted to Number2 Blog - MyITForum.com (Weblog) by jnelson on 11-15-2007
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
SQL for SMS/SCCM - How to get the CORRECT order when sorting on version numbers like xx.xx.xx.xx

(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 have out there, and you order the results by the ProductVersion (if you use V_GS_SoftwareProduct) or fileVersion (if you use V_GS_SoftwareFile), you...

Posted to Number2 Blog - MyITForum.com (Weblog) by jnelson on 11-13-2007
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

Page 1 of 1 (3 items)

myITforum.com

Browse by Tags

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

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

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