Month: March 2012

BIG NEWS!!!!

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! http://bit.ly/yMimvp   oh, […]

Link to Name

For full details see post here. http://www.myitforum.com/forums/tm.aspx?high=&m=234875&mpage=1#234894   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. http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/thread/3bea8fa6-968a-4f0e-b412-469577e409aa 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 http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/d8477233-4b10-4a6d-a5ea-de73abc9b815/ 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 […]