Month – July 2011

Harddisk changes

Select CS .Name0, HD .DeviceID0, HD .Index0, HD .Size0, HHD .Size0 from dbo .v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_DISK HD on CS.ResourceID = HD.ResourceID join dbo.v_HS_DISK HHD on CS.ResourceID = HHD.ResourceID Where HD .Size0 <> HHD.Size0 And HD.DeviceID0 = HHD.DeviceID0 and HD.Index0 = HHD.Index0

Report for software update article ID

SELECT DISTINCT UI .BulletinID as ‘BulletinID’, UI .ArticleID as ‘ArticleID’, UI .Title as ‘Title’, ‘Deployed’ = (case when CTM.ResourceID is not null then ‘Yes’ else ‘No’ end), UI .InfoURL as ‘URL’, UI .CI_UniqueID as ‘Unique ID’ FROM v_UpdateComplianceStatus UCS join v_UpdateInfo UI on UI.CI_ID = UCS.CI_ID join v_R_System SYS on UCS.ResourceID = SYS.ResourceID join v_ClientCollectionMembers […]

Query for Drivers within the Boot Image

SELECT bip .PkgID as ‘Boot Package’, SMS_Driver .DisplayName as ‘Driver Name’, SMS_Driver .LocaleID as ‘Local’, bip .SourcePath as ‘SourcePath’, drv .DriverINFFile as ‘INF’ FROM BootImgPkg_References as bip INNER JOIN CI_ConfigurationItems as cc ON cc.CI_ID = bip.CI_ID INNER JOIN v_CI_DriversCIs as drv ON drv.CI_ID = bip.CI_ID join fn_ListDriverCIs(1033) AS SMS_Driver on SMS_Driver.CI_ID = bip.CI_ID

List of PCs by OU

select R .Name0 as ‘PC’, right(OU.System_OU_Name0, CHARINDEX(‘/’,reverse(Max(OU.System_OU_Name0)))-1) as ‘OU’ from dbo .v_R_System R left outer join dbo.v_RA_System_SystemOUName OU on R.ResourceID = OU.ResourceID Group by R .Name0, OU .System_OU_Name0 Order by R .Name0

Garth Jones

I subscribe to Forrester group’s blog and I saw this blog about Porter airline!, I had the luxury of flying with Porter a few times!  Any time I have to fly to downtown Toronto, I will fly Porter, no other airline will do! Heck I have even tried to convince Microsoft Canada to move […]