Month: March 2012


I have big news but there is a catch….. I can’t say much until Wednesday at noon PST! J Which works out perfectly, as that is almost the exact time that I will be finishing my SCCM Guru webcast! So make sure that your register for the session to hear it Live!   oh, […]

Link to Name

For full details see post here.   select ARP.resourceid, CS.Name0, max(ARP.version0)as JavaVersion from dbo.v_GS_COMPUTER_SYSTEM as CS join dbo.v_ADD_REMOVE_PROGRAMS as ARP on CS.ResourceID = ARP.ResourceID where ARP.DisplayName0 like ‘Java(TM) 6 Update%’ group by ARP.resourceid, CS.Name0

Cannot get rid of duplicate rows on an Add or Remove Programs query

For for details see post. Select DISTINCT SYS.Netbios_Name0 AS ‘Name’, case SEM.ResourceID When NULL THEN ‘N’ Else ‘Y’ End AS ‘SafeNet?’, ARP.Timestamp From dbo.v_R_System SYS left outer JOIN dbo.v_Add_Remove_Programs ARP ON SYS.ResourceID = ARP.ResourceID and ARP.DisplayName0 = ‘Update for Windows Server 2003 (KB943295)’ LEFT OUTER JOIN (SELECT ARP.ResourceID From dbo.v_Add_Remove_Programs ARP WHERE ARP.DisplayName0 = […]

Custom ChassisType Report – wrong counts

See the full details within the forum declare @Manufacturer0 as varchar(250) set @Manufacturer0 = ‘All’ declare @Version0 as varchar(250) set @Version0 = ‘All’ declare @CollectionID as varchar(250) set @CollectionID = ‘SMS00001’ SELECT SE.ChassisTypes0, count (*) as ChassisCount FROM dbo.v_GS_SYSTEM_ENCLOSURE SE INNER JOIN dbo.v_GS_OPERATING_SYSTEM OS ON OS.ResourceID = SE.ResourceID INNER JOIN dbo.v_FullCollectionMembership FCM ON FCM.ResourceID […]