Month – January 2009

Drinking Game?

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 […]

Server HF Status

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

How to create a batch file using SQL

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 […]

List PCs with particular ARP

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’)

Server Uptime

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 […]

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 […]

System Center Configuration Manager Administrator

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 […]