Garth's Blog
What is on his mind, aka Does he have a mind?
Browse by Tags
All Tags
»
SMS
(
RSS
)
70-400
70-401
70-431
70-640
Canada
Code
ConfigMGr
exam
Fun Links
Joke
MOM
OpsMgr
Ottawa
self-study
SoftGrid
SQL
Study group
System Center
Training
User Groups
Windows 2008
List routers that ConfigMgr / SMS knows about
Saturday, September 06, 2008 1:08 PM
Select RASIP.IP_addresses0, RASR.System_roles0 from dbo.v_RA_System_IPAddresses RASIP, dbo.v_RA_System_SystemRoles RASR where RASR.ResourceID = RASIP.ResourceID and RASR.System_Roles0 = 'Router'
Read More...
Count of Unidentified & Uncategorized software
Thursday, September 04, 2008 2:56 PM
SELECT ISC.NormalizedPublisher, ISC.NormalizedName, ISC.NormalizedVersion, ISC.CategoryName, count(*) as 'count' FROM dbo.v_GS_Installed_Software_Categorized ISC WHERE ISC.FamilyName In ('Unidentified','Uncategorized') group by ISC.NormalizedPublisher, ISC.NormalizedName, ISC.NormalizedVersion, ISC.CategoryName order by ISC.NormalizedPublisher...
Read More...
ConfigMgr Command line
Friday, August 29, 2008 3:44 PM
Did you know that you can add command line switches in he command line?
Read More...
PCs with the no logon information for 30 days
Wednesday, August 27, 2008 9:26 AM
SELECT distinct CS.Name0 AS 'Computer', isnull(CS.UserName0,HCS.UserName0) AS 'User Name' , CS.TimeStamp FROM v_GS_COMPUTER_SYSTEM CS Left outer join v_HS_COMPUTER_SYSTEM HCS on CS.ResourceID = HCS.ResourceID WHERE HCS.UserName0 is not NULL and datediff(dd,CS.TimeStamp,getdate()) > 30 Group by CS.Name0, CS.UserName0, CS.TimeStamp, HCS.UserName0...
Read More...
Forum Reply - T-SQL Best Practice
Friday, August 22, 2008 9:40 AM
SELECT DISTINCT ARP.DisplayName0, ARP.Publisher0, ARP.Version0, CS.Name0, CS.UserName0, WS.LastHWScan, BIOS.SerialNumber0, R.AD_Site_Name0 FROM dbo.v_GS_ADD_REMOVE_PROGRAMS ARP INNER JOIN dbo.v_GS_Computer_System CS ON ARP.ResourceID = CS.ResourceID INNER JOIN dbo.v_GS_PC_BIOS BIOS ON CS.ResourceID = BIOS.ResourceID INNER JOIN dbo.v_R_System R ON CS.ResourceID...
Read More...
How to restore the default collections within ConfigMgr!
Friday, August 22, 2008 8:35 AM
Are you like me have you accidentally deleted the “All systems” collection instead of a PC? Have you wonder how to get it back? Well after some digging and asking around, I finally determine the answer! (with being pointed in the right direction) <Drum Roll> Install / Reinstall the last service pack! BTW This might work in SMS 2003 too. If you try it and...
Read More...
Query Help
Thursday, August 21, 2008 8:21 AM
declare @olddate datetime set @olddate=dateadd(day,-8, getdate()) select CS.Name0 as 'Computer Name', arp.installdate0 as 'Installed Date', arp.displayname0 as 'Application Name', from dbo.v_GS_ADD_REMOVE_PROGRAMS arp, dbo.v_GS_Computer_System CS where CS.resourceid = arp.resourceid and datediff(DD,arp.installdate0, @olddate) < 8 and...
Read More...
List all discovered devices which are not a client
Wednesday, August 20, 2008 11:24 AM
This query will display all devices (PCs, routers, etc.) that ConfigMgr / SMS knows about which are not clients. select Name0, Resource_Domain_Or_Workgr0, Operating_system_name_and0, AD_Site_Name0, Community_name0 from v_R_System R where R.ResourceID Not in (Select CS.ResourceID From v_GS_Computer_System CS) Order by Name0
Read More...
Find PCs by Manufacturer and Model
Friday, August 15, 2008 8:51 AM
SELECT CS.Name0, CS.UserName0 FROM dbo.v_GS_COMPUTER_SYSTEM CS WHERE CS.Manufacturer0='Microsoft Corporation' AND CS.Model0='Virtual Machine'
Read More...
Add Date filter to Advert status
Thursday, August 14, 2008 10:21 AM
SELECT CS.Name0, adv.AdvertisementName, stat.LastStateName, adv.Comment AS C072, pkg.Name AS C062, adv.ProgramName AS C071, adv.SourceSite, adv.AdvertisementID FROM v_Advertisement adv JOIN v_Package pkg ON adv.PackageID = pkg.PackageID JOIN v_ClientAdvertisementStatus stat ON stat.AdvertisementID = adv.AdvertisementID JOIN v_GS_Computer_System CS ON stat.ResourceID...
Read More...
Managers and web reports
Thursday, August 14, 2008 9:56 AM
During a discussion on the myITforum ConfigMgr /SMS mailing this statement was made “ It’s never bad admin mojo to provide a report based on what management seeks. You can either do it or you can’t. “ Without going into all of the details of what this person was looking, I will attempt to explain why what this person was looking for is a bad idea. This is the...
Read More...
Learning TSQL
Tuesday, August 12, 2008 8:37 AM
The question of learning T-SQL comes up all the time with ConfigMgr/SMS/MOM/OpsMgr Admins, here are some resources to help you out. Part of this are taken for a previous article I wrote on the subject and it still applies, today. http://www.myitforum.com/articles/18/view.asp?id=5694 Here are two free website to help you learn TSQL. http://sqlcourse.com/ http...
Read More...
Active workstations in the last 30 days
Friday, August 08, 2008 11:28 AM
Select CS.Name0, WS.LastHWScan From dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_WORKSTATION_STATUS WS Where CS.Resourceid = WS.ResourceID and datediff(dd,WS.LastHWScan,getdate())< 30
Read More...
History install date for ARP (example)
Friday, August 08, 2008 10:57 AM
Select ARP.DisplayName0, HARP.InstallDate0 from dbo.v_GS_ADD_REMOVE_PROGRAMS ARP, dbo.v_HS_ADD_REMOVE_PROGRAMS HARP Where ARP.ResourceID = HARP.ResourceID and ARP.ProdID0 = HARP.ProdID0 Group by ARP.DisplayName0...
Read More...
ARP Dates
Friday, August 08, 2008 9:49 AM
select CS.Name0 as 'Computer Name', convert(datetime,isnull(ARP.installdate0,'1980-1-1')) as 'Installed Date' From dbo.v_GS_ADD_REMOVE_PROGRAMS ARP, dbo.v_GS_COMPUTER_SYSTEM CS Where CS.ResourceID = ARP.ResourceID
Read More...
Two NICs enabled at the same time
Friday, August 08, 2008 9:42 AM
Select Distinct CS.Name0, NIC.Description0, NAC.IPAddress0, NAC.DefaultIPGateway0, NIC.*, Nac.* from dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_NETWORK_ADAPTER NIC, dbo.v_GS_NETWORK_ADAPTER_CONFIGUR...
Read More...
70-640 Week 10
Friday, August 01, 2008 8:27 AM
I posted this early because of the long weekend. Have a great long weekend. This weeks reading for the self study group is: 9.0 DNS and IPv6 13 38 9.1 Understanding and Installing Domian Name System 25
Read More...
Count of Device by AD site
Wednesday, July 30, 2008 7:03 PM
Select B.ADSite as 'AD Site', Count(B.ADSite) as 'Count' from (SELECT Case When R.AD_Site_Name0 = '' Then '<No AD Site>' When R.AD_Site_Name0 = NULL Then '<No AD Site>' When isnull(R.AD_Site_Name0,'one') = 'one' Then '<No AD Site>' else R.AD_Site_Name0 End as 'ADSite'--...
Read More...
Network Report
Tuesday, July 29, 2008 8:36 AM
Select Distinct CS.Name0, NIC.Description0, NAC.IPAddress0, NAC.DefaultIPGateway0 from dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_NETWORK_ADAPTER NIC, dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC Where CS.ResourceID = NIC.ResourceID and CS.ResourceID = NAC.ResourceID and NAC.ServiceName0 = NIC.ServiceName0 and NAC.IPAddress0 != '' and NAC.IPAddress0 != '0.0.0...
Read More...
List PCs by PC Description
Monday, July 21, 2008 9:09 AM
select CS.Name0, OS.Description0 from dbo.v_GS_OPERATING_SYSTEM OS, dbo.v_GS_COMPUTER_SYSTEM CS Where CS.ResourceID = OS.ResourceID Order by CS.Name0
Read More...
Configuration Manager 2007 or SMS 2003 Backups
Sunday, July 13, 2008 5:00 PM
Have you ever wanted to do a backup of your ConfigMgr or SMS site before doing anything? Have you noticed that the default configuration allows you to only back up the site once a day? Well, here is a trick that Wally passed on to me. It is some simple yet... Start the “SMS_Site_Backup” service, Depending on your site size but a few minutes later it will be done...
Read More...
SCCM
Tuesday, June 17, 2008 3:49 PM
Is this the reason why we should not be using SCCM ?
Read More...
SMS 2003 3rd level support - 1yr contract DND
Friday, June 13, 2008 4:42 PM
Did you see that another job posting was listed on the SMSUG.ca site? http://smsug.ca/forums/t/668.aspx
Read More...
SMS/MOM/Systems Centre Premier Field Engineer job posting
Wednesday, June 11, 2008 5:46 PM
Did you see the SMS/MOM Field Engineer job posting? No then go check it out at http://smsug.ca/forums/p/666/1210.aspx#1210
Read More...
It’s Still SMS to Me
Tuesday, June 10, 2008 8:18 AM
Bob Lawler post this within the MCT newsgroup (yes, Ron newsgroup ;-) ), I thought that I would re-posted it here. It’s Still SMS to Me (Sung to the tune of Billy Joel’s It’s Still Rock-n-Roll to Me) What’s the matter with the new stuff, baby? Can’t you tell all names are wrong? Maybe you could stop calling it “MOM” “ System Center Operations Manager ” 's...
Read More...
OpsMgr and ConfigMgr Exam forums created on OWSUG.ca
Sunday, May 11, 2008 11:56 AM
We have created study group forums for both of the available System Center exams. 70-400 System Center Operations Manager 2007, Configuring 70-401 System Center Configuration Manager 2007, Configuring
Read More...
Calgary Systems Management User Group (CSMUG)
Friday, May 09, 2008 9:51 AM
The Calgary Systems Management User Group (CSMUG) is an informal association of area professionals working in IT Infrastructure with a specialization in Application Management. We are dedicated to informing and educating members about advancements in systems management with a special emphasis on virtualization technologies. It is the mandate of this congregation...
Read More...
MMS rumours and sound bytes
Monday, May 05, 2008 10:26 AM
This is a Collection of rumours and sound bytes, listed in no particular order. ConfigMgr Rules One of the OpsMgr MVPs is a MAC user (I don't say this one! I know the person in question will seek revenge on the "original" quoter, I'm just stirring the pot. <Evil Grin> ) Did you bring the boots? Do you want a puck! I want meat! That was...
Read More...
Todd's Blog post...
Friday, April 25, 2008 9:11 PM
I have been so busy that I haven't had time to do things like read blog post. However very late today I was cleaning up my Inbox before heading to MMS on Sunday morning. While up my inbox I found this Blog post from Todd. http://todds.typepad.com/posts/2008/04/garth-jones-fea.html The funny thing is that I forgot that I did this! It was back in March!
Read More...
Go
This Blog
Home
Contact
Links
About
Tags
2830
70-293
70-294
70-298
70-299
70-400
70-401
70-402
70-403
70-431
70-536
70-620
70-622
70-624
70-640
70-642
70-643
70-646
70-647
70-649
70-652
A+
Canada
Code
ConfigMGr
CTE Solutions
EnergizeIT
exam
Fun Links
Joke
MOM
MS Support
MVP
OpsMgr
Ottawa
Ottawa Windows Server User Group
Podcast
Q&A
Q&A
SCE
SCMDM
SCSM
SCVMM
self-study
SMS
SoftGrid
SQL
Study group
System Center
Training
UK
User group
User Groups
Virtual Server
Vista
VS 2008
Windows 2003
Windows 2008
Navigation
Site Home
Home
Bloggers List
Blogs
Photos
Downloads
Archives
September 2008 (17)
August 2008 (72)
July 2008 (57)
June 2008 (46)
May 2008 (39)
April 2008 (4)
January 2007 (1)
November 2006 (5)
October 2006 (5)
May 2006 (5)
April 2006 (3)
March 2006 (7)
February 2006 (4)
January 2006 (8)
December 2005 (2)
November 2005 (1)
October 2005 (5)
September 2005 (6)
August 2005 (9)
April 2005 (1)
March 2005 (1)
February 2005 (2)
January 2005 (10)
December 2004 (26)
Syndication
RSS
Atom
Comments RSS