Browse by Tags

All Tags » SCCM (RSS)
ConfigMgr / SCCM Documentation Script v1.24
Tuesday, March 02, 2010 9:58 AM
The ConfigMgr / SCCM documentation script has been updated to v1.24 for more details please see http://tinyurl.com/yfpgocw Read More...
by Garth Jones
Filed under: , , , ,
Customized Report "computers with specific software registered in Add Remove Programs"
Sunday, February 14, 2010 10:35 AM
SELECT Distinct         sys.Netbios_Name0,     fcm.SiteCode,     sys.User_Domain0,     sys.User_Name0,     sys.Operating_System_Name_and0,     arp.DisplayName0,     u.department0 FROM     dbo.v_R_System AS sys    ... Read More...
by Garth Jones
Filed under: , , , ,
Routers?
Wednesday, January 20, 2010 9:45 AM
This might NOT list all routers in your environment, and it will has lots of false positives too.   Of the 7 device marked as a router, only 3 are right, the remaining 4 are false positives.   In my test lab it found 3 out of 7, Routers /Switches.   Plus it lists ·         1 WS, that is not acting like routers... Read More...
by Garth Jones
Filed under: , , ,
2010 myITforum Donation
Thursday, January 07, 2010 1:39 PM
With the start of a new year, it is that time again to support the System Management Community, with that in mind I have made my yearly donation of $250 USD to MyITForum (MIF). Why do I do it? Well as a past User Group leader for www.OWSUG.ca , I know how much it cost to host a small user group community. OWSUG is small in comparison to MIF! Our network traffic... Read More...
by Garth Jones
Filed under: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
Collection Query - AD group membership & filter for Add\Remove Programs
Monday, January 04, 2010 8:08 AM
select     R.*  from      SMS_R_System R where     R.SystemGroupName != "GARTEK\\Domain Admins"     and R.ResourceId not in (    select                        ... Read More...
by Garth Jones
Filed under: , , , , ,
Null and Not like
Thursday, December 31, 2009 8:51 AM
SELECT     DisplayName0,     Count(*) AS 'Count',     Publisher0,     @CollID as CollectionID FROM     v_Add_Remove_Programs arp     JOIN v_FullCollectionMembership fcm on arp.ResourceID=fcm.ResourceID WHERE     fcm.CollectionID = @CollID    ... Read More...
by Garth Jones
Filed under: , , , ,
Testing for exist codes with SMSI
Monday, December 28, 2009 10:26 AM
Here is sample code on how to test for an exist code using SMS Installed.   item: Execute Program   Pathname=%win%\notepad.exe   Default Directory=%win%\   Flags=00000010 end item: If/While Statement   Variable=PROCEXITCODE   Value=0 end item: Display Message   Title English=Exist Code   Text English=Notepad exited with... Read More...
by Garth Jones
Filed under: , , , , , ,
management nightmare
Wednesday, December 23, 2009 2:31 PM
SELECT Distinct R . Netbios_Name0 , ARP . DisplayName0 , OS . Caption0 FROM dbo . v_R_System R INNER JOIN dbo . v_GS_ADD_REMOVE_PROGRAMS ARP ON R . ResourceID = ARP . ResourceID INNER JOIN dbo . v_GS_OPERATING_SYSTEM OS ON OS . ResourceID = ARP . ResourceID WHERE ARP . DisplayName0 in ( 'Microsoft Office Professional Edition 2003' , 'Microsoft Office... Read More...
by Garth Jones
Filed under: , , , ,
OS version using v_R_System
Monday, December 21, 2009 1:03 PM
select R . Name0 , R . Operating_system_Name_And0 from dbo . v_R_System R Where r . ResourceId not in ( Select ResourceId from dbo . v_R_System R where r . Client_Version0 <> '' ) and R . Operating_system_Name_And0 <> '' order by R . Name0 , R . Operating_system_Name_And0 Read More...
by Garth Jones
Filed under: , , , ,
Limiting to a Collection.
Monday, December 14, 2009 10:02 PM
  SELECT Distinct R . Netbios_Name0 , ARP . DisplayName0 FROM dbo . v_R_System R INNER JOIN dbo . v_GS_ADD_REMOVE_PROGRAMS ARP ON R . ResourceID = ARP . ResourceID Inner Join dbo . v_FullCollectionMembership FCM ON R . ResourceID = FCM . ResourceID and CollectionID = 'SMS00001' WHERE ARP . DisplayName0 in ( 'Microsoft Office Professional Edition... Read More...
by Garth Jones
Filed under: , , , ,
Why v_GS_OPERATING_SYSTEM.Caption0 is better than v_R_System.Operating_System_Name_and0
Friday, December 04, 2009 10:04 AM
Take the following query, if you only used v_R_System . Operating_System_Name_and0 then you would have no idea as to which PCs are installed with “Microsoft Windows 7 Ultimate" or “Microsoft Windows 7 Professional”.     Select       R . Name0 ,       R . Operating_System_Name_and0 ,      ... Read More...
by Garth Jones
Filed under: , , , , ,
Servers Report Query
Friday, December 04, 2009 8:14 AM
SELECT         R.Netbios_Name0,     os.Caption0,     ARP.DisplayName0 As 'Softwarename',     ARP.Publisher0 as 'Publisher',     ARP.Version0 as 'version',     ARP.ProdID0 as 'productID',     ARP.InstallDate0... Read More...
by Garth Jones
Filed under: , , , , ,
System Center Configuration Manager 2007 with Service Pack 2 (x86) - DVD (English) is now available on TechNet.
Friday, December 04, 2009 7:55 AM
The fully integrated ConfigMgr 2007 with SP2 is now available on TechNet. Now you can install with SQL 2008 from the start, no upgrading from SQL 2005.   Read More...
by Garth Jones
Filed under: , , ,
Planning, Deploying and Managing Microsoft Systems Center Configuration Manager 2007 (6451a) in Ottawa
Wednesday, December 02, 2009 2:22 PM
If you are looking to take this course, I have been told that CTE Solutions will be running 6451a course the week of Dec 14th - 18th 2009. http://www.ctesolutions.com/course/Systems-Center-Training/Systems-Center-Configuration-Manager-2007-Training.htm?l=ottawa%2Dtraining%2Dfacility&checkout   Don’t forget to ask for your User Group discount! ;-) (They... Read More...
by Garth Jones
Filed under: , , , ,
ConfigMgr and OpsMgr Exam Discounts
Friday, November 27, 2009 11:08 AM
  Are you looking to become certified on ConfigMgr 2007 (70-401) or OpsMgr 2007 (70-400)?   Well you are in Luck! Prometric is offering a 20% discount on both exam! http://www.prometric.com/Microsoft/CareerOffer.htm#vouchers20   So what are you waiting for? Read More...
by Garth Jones
Filed under: , , , , , ,
More Posts Next page »
Go

This Blog

Syndication