in

myITforum.com
All Tags » SMS 2003 » sql 2005 » v_GS_SoftwareFile (RSS)

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

  • SQL Oddity - OUTER JOINs with criteria act like INNER JOIN

    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 table or view that is outer joined. But when you do that, the query acts like an inner join. Consider the following query: It's designed to show...
    Posted to Number2 Blog - MyITForum.com (Weblog) by jnelson on 11-16-2007
    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

  • 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 (4 items)
Copyright - www.myITforum.com, Inc. - 2007 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems