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, […]
Month: March 2012
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
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 = […]
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 […]
select CS.Name0, MRIB.ProductName, MD.* from dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_MeterData MD on CS.ResourceID = MD.ResourceID join dbo.v_MeterRuleInstallBase MRIB on MD.FileID = MRIB.MeteredFileID where MD.starttime > ‘2012-02-16’