-
-
The CHM file (help file) has been updated, download it from here.
http://www.microsoft.com/downloads/details.aspx?FamilyID=71816b0f-de06-40e0-bce7-ad4b1e4377bb&displaylang=en
Thanks you Docs Team!!! :-)
-
-
This week I was introduced to a new drinking game.
In this game you take a drink each time you see Susan Ibach (from our friend at CTE Solutions) within this Video.
I Love Learning
Ok it is not really a drink game but it is a cool video. If you ever meet Susan ask her to tell you the story behind this video and how her boss (Mia) first saw it!
BTW I counted 9 times! How many times did you see her?
-
-
select
OS.Caption0,
CS.SystemType0,
Count(*)
from
dbo.v_GS_COMPUTER_SYSTEM CS Left Outer Join dbo.v_GS_OPERATING_SYSTEM OS on CS.ResourceID = OS.ResourceId
Group by
OS.Caption0,
CS.SystemType0
Order by
OS.Caption0,
CS.SystemType0
-
-
select
CS.Name0,
PSE.Status0,
count(PSE.Status0)
from
dbo.v_GS_Computer_System cs left outer join dbo.v_GS_PATCHSTATEEX PSE on CS.ResourceID = PSE.ResourceID
left outer join dbo.v_GS_SYSTEM S on CS.ResourceID = S.ResourceID
Where
S.SystemRole0 = 'Server'
Group by
CS.Name0,
PSE.Status0
-
-
The output of this query can be used to create a batch file to execute service control to fix BITS service.
-
Open SQL Server Management Studio and paste this query.
-
Edit it as you need.
-
Execute the query
-
Save the result panel as fixbits.bat
-
Finally open a DOS Prompt
-
Make sure that sc.exe is located within the path.
-
Run fixbits.bat
select
'sc \\'+CS.Name0 +' sdset bits "bla bla"'
from
dbo.v_GS_SERVICE S left outer join dbo.v_GS_Computer_system cs on CS.ResourceID = S.ResourceID
where
(displayname0 = 'Background Intelligent Transfer Service') and
( State0 != 'Running' or isnull(State0, 'NULL') = 'NULL')
-
-
Select
CS.Name0,
ARP.DisplayName0
From
dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_Add_Remove_Programs ARP on CS.REsourceID = ARP.ResourceID
Where
ARP.DisplayName0 in ('Microsoft SQL Server 2005 Tools', 'Virtual Machine Additions','Windows Resource Kit Tools')
-
-
Select
cs.Name0,
DateDiff(hour,os.LastBootUpTime0,ws.LastHWScan) as 'Uptime (in Hours)',
os.LastBootUpTime0 as 'Last Reboot Date/Time',
ws.LastHWScan as 'Last Hardware Inventory'
From
dbo.v_GS_WORKSTATION_STATUS ws Left Outer Join dbo.v_GS_Operating_System os on ws.ResourceID = os.ResourceID
left outer join dbo.v_GS_COMPUTER_SYSTEM cs on cs.ResourceID = os.ResourceID
left outer join dbo.v_GS_SYSTEM sys on sys.ResourceID = os.ResourceID
Where
Sys.SystemRole0='Server'
Order by
Cs.Name0
-
-
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 small compared to MIF! Our network traffic is nothing compared to what the MIF site gets. I’m will to bet that the network traffic to the MIF site in less than 12 hours, is the equivalent of what the www.OWSUG.ca gets in one year! I will also tell you that it cost more that $100 as year (USD) to host the www.OWSUG.ca site.
So, have you made a donation to your community yet? http://www.myitforum.com/donations/myITpaypal.asp
-
-
ops, I posted the wrong link in this post , here is the update link.
https://mvp.support.microsoft.com/profile=48CDC5C8-ABFF-46FE-89D8-27A68CE221DE
-
-
I was talking to another senior ConfigMgr guy today, who is thinking of updating his certification. We talked about what certification he should get to meet his goals. Anyway after reviewing my blog post about System Center Configuration Manager Enterprise Administrator, he said “Wow that is a lot of certs!”. I thought about and following the idea of MCSE and MCSA. Here is was I think that you need for a MCSA version and I think it should be called System Center Configuration Manager Administrator.
Workstation
If a ConfigMgr Admin does not know about workstations then what are they doing working with ConfigMgr.
70-620 or CHAMP
OS Deployment
In this day and age, OS Deployment is an important part of ConfigMgr as an Administrator you must know this.
70-635, 70-624 or 70-622
Server
Just like workstations, ConfigMgr administrator must know about IIS, PKI, Networks, DHPC, DNS, etc.
one of 70-640, 70-642, 70-643
ConfigMgr exam of course
70-401
These gives a good base for a ConfigMgr administrator and will give you a good start on becoming an ConfigMgr Enterprise Administrator. So for this I would middle level certification, I have passed all of the requirements for this already.
OpsMgr Enterprise Admin
I still need 70-400. I am slowly working on it but holidays and work are getting in the way of me completing this exam. It is not going to help that I have just booked myself into a personal interest course for the next 7 weeks either! So I’m not sure when I will get this done.
ConfigMgr Enterprise Admin
I still need the Packaging exam and the Licensing exam to complete this high level title.
Does OpsMgr Enterprise Administrator also require an MCSA equivalent? If so what should the requirements be?
Do you meet the requirements for any of these certifications as I have laid them out? If so send me an email with your transcript sharing information.
-
-
Congratulation go out to Brad Bird, the VP of www.OWSUG.ca and study group leader for being awarded an MVP for OpsMgr. Brad has been working hard with the OWSUG to help the community grow. Without his help the study groups would still be struggling.
http://owsug.ca/blogs/brad/archive/2009/01/01/I-made-Microsoft-MVP-_2D00_-Management-Infrastructure.aspx
