Browse by Tags

myITForum Donation

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 to MyITForum (MIF). Why do I do it? Well as a User Group leader for www.OWSUG.ca , I know how much it cost to host a small user group community. OWSUG is extremely...

Posted to Garth Jones at myITforum.com (Weblog) by Anonymous on 01-08-2009
Filed under: Joke, Virtual Server , User Groups, 70-401, ConfigMGr, 70-400, MOM, Study group, SMS, OpsMgr, Canada, SoftGrid, 70-299, 70-640, 70-643, 70-642, MS Support, Training, Windows 2008, self-study, Podcast, System Center, Ottawa, 70-620, 70-536, 70-293, 70-622, 70-294, SCMDM, SCSM, SCE, SCVMM, Vista, exam, 70-652, 70-403, 70-402, MVP, Code, VS 2008, 70-624, Q&A, 70-298, A+, SQL, Windows 2003, 70-649, 70-646, 70-647, 70-431, MCSE, Hyper-v, WQL, MDT, 70-635, 70-671, 70-672, 70-673, Flowcharts
myITForum Donation

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 to MyITForum (MIF). Why do I do it? Well as a User Group leader for www.OWSUG.ca , I know how much it cost to host a small user group community. OWSUG is extremely...

Posted to Garth Jones at myITforum.com (Weblog) by Anonymous on 01-08-2009
Filed under: Joke, Virtual Server , User Groups, 70-401, ConfigMGr, 70-400, MOM, Study group, SMS, OpsMgr, Canada, SoftGrid, 70-299, 70-640, 70-643, 70-642, MS Support, Training, Windows 2008, self-study, Podcast, System Center, Ottawa, 70-620, 70-536, 70-293, 70-622, 70-294, SCMDM, SCSM, SCE, SCVMM, Vista, exam, 70-652, 70-403, 70-402, MVP, Code, VS 2008, 70-624, Q&A, 70-298, A+, SQL, Windows 2003, 70-649, 70-646, 70-647, 70-431, MCSE, Hyper-v, WQL, MDT, 70-635, 70-671, 70-672, 70-673, Flowcharts
List PCs with Static IP Addresses

select CS.Name0, NAC.IPAddress0 from dbo.v_GS_COMPUTER_SYSTEM cs JOIN dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC on CS.ResourceId = NAC.ResourceId Where NAC.IPAddress0 !='' and DHCPEnabled0...

Posted to Garth Jones at myITforum.com (Weblog) by Anonymous on 08-20-2009
Filed under: ConfigMGr, SMS, System Center, Code, SQL
Servers Report Query

SELECT R.Netbios_Name0, os.Caption0, ARP.DisplayName0 As 'Softwarename', ARP.Publisher0 as 'Publisher', ARP.Version0 as 'version', ARP.ProdID0...

Posted to Garth Jones at myITforum.com (Weblog) by Anonymous on 12-04-2009
Filed under: ConfigMGr, SMS, System Center, Code, SQL, SCCM
OS version using v_R_System

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

Posted to Garth Jones at myITforum.com (Weblog) by Anonymous on 12-21-2009
Filed under: ConfigMGr, SMS, System Center, Code, SCCM
Testing for exist codes with SMSI

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...

Posted to Garth Jones at myITforum.com (Weblog) by Anonymous on 12-28-2009
Filed under: ConfigMGr, SMS, System Center, Code, SCCM, SMSI, SMS Installer
Null and Not like

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...

Posted to Garth Jones at myITforum.com (Weblog) by Anonymous on 12-31-2009
Filed under: ConfigMGr, SMS, System Center, Code, SCCM
Collection Query - AD group membership & filter for Add\Remove Programs

select R.* from SMS_R_System R where R.SystemGroupName != "GARTEK\\Domain Admins" and R.ResourceId not in ( select ...

Posted to Garth Jones at myITforum.com (Weblog) by Anonymous on 01-04-2010
Filed under: ConfigMGr, SMS, System Center, Code, WQL, SCCM
2010 myITforum Donation

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...

Posted to Garth Jones at myITforum.com (Weblog) by Anonymous on 01-07-2010
Filed under: Virtual Server , User Groups, 70-401, ConfigMGr, 70-400, MOM, SMS, OpsMgr, Fun Links, 70-299, 70-640, 70-643, 70-642, MS Support, Training, Windows 2008, self-study, System Center, 70-620, 70-536, 70-293, 70-622, 70-294, SCMDM, SCSM, SCE, SCVMM, Vista, exam, 70-652, 70-403, 70-402, Code, VS 2008, 70-624, Q&A, 70-298, SQL, Windows 2003, 70-649, 70-646, 70-647, 70-431, MCSE, Hyper-v, WQL, MDT, 70-635, 70-671, 70-672, 70-673, 70-631, 70-089, MMS, Enhansoft, myITforum, Rant, 70-630, 70-236, Windows 7, MSN, SCCM, SMSI, SMS Installer
2010 myITforum Donation

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...

Posted to Garth Jones at myITforum.com (Weblog) by Anonymous on 01-07-2010
Filed under: Virtual Server , User Groups, 70-401, ConfigMGr, 70-400, MOM, SMS, OpsMgr, Fun Links, 70-299, 70-640, 70-643, 70-642, MS Support, Training, Windows 2008, self-study, System Center, 70-620, 70-536, 70-293, 70-622, 70-294, SCMDM, SCSM, SCE, SCVMM, Vista, exam, 70-652, 70-403, 70-402, Code, VS 2008, 70-624, Q&A, 70-298, SQL, Windows 2003, 70-649, 70-646, 70-647, 70-431, MCSE, Hyper-v, WQL, MDT, 70-635, 70-671, 70-672, 70-673, 70-631, 70-089, MMS, Enhansoft, myITforum, Rant, 70-630, 70-236, Windows 7, MSN, SCCM, SMSI, SMS Installer

Page 1 of 2 (20 items) 1 2 Next >