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!!! 🙂
Month: January 2009
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 […]
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.ResourceIdGroup by OS.Caption0, CS.SystemType0Order 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 […]
Select CS.Name0, ARP.DisplayName0From dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_Add_Remove_Programs ARP on CS.REsourceID = ARP.ResourceIDWhere 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 […]
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 […]
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 […]