July 2011 - Posts

Harddisk changes
Friday, July 29, 2011 9:25 AM

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

by Garth Jones

Filed under: ConfigMGr, SMS, Code, SQL, SCCM, vNext

Report for listing all the devices a users has logged onto along with their last logon time
Wednesday, July 27, 2011 7:46 AM

SELECT

DISTINCT Max(HCU.LastConsoleUse0),

HCU

.SystemConsoleUser0,

S

.Name0

FROM

dbo

.v_GS_SYSTEM S join dbo.v_HS_SYSTEM_CONSOLE_USER HCU on S.ResourceID = HCU.ResourceID

WHERE

HCU

.SystemConsoleUser0='Enhansoft\Garth'

group

by

S

.Name0,

HCU

.SystemConsoleUser0

Order

by

S

.Name0,

HCU

.SystemConsoleUser0

by Garth Jones

Filed under: ConfigMGr, SMS, Code, SCCM, vNext

Report for software update article ID
Monday, July 25, 2011 9:48 PM

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 CCM on CCM.ResourceID = SYS.ResourceID left join v_CITargetedMachines CTM on CTM.CI_ID=UCS.CI_ID and CTM.ResourceID = UCS.ResourceID

WHERE

UCS

.Status=2 and SYS.Name0 = @ComputerName

ORDER

BY

UI

.BulletinID DESC

by Garth Jones

Filed under: ConfigMGr, SMS, Code, SQL, SCCM, vNext, SU, URL

Query for Drivers within the Boot Image
Monday, July 25, 2011 9:17 AM

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

by Garth Jones

Filed under: ConfigMGr, SMS, Code, SQL, SCCM, vNext, Boot Image, Drivers

List of PCs by OU
Sunday, July 24, 2011 9:57 AM

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

by Garth Jones

Filed under: SMS, Code, SCCM, vNext, OU

Configuration Manager 2007 Documentation Library for June 2011
Wednesday, July 13, 2011 3:30 PM

Did you see Rob’s note!!! There is a NEW Configuration Manager 2007 Help File!

 

Download it from http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=17214

 

To see Rob full blog, click here.

http://blogs.technet.com/b/configmgrteam/archive/2011/07/12/configuration-manager-2007-documentation-library-downloadable-update-for-june-2011.aspx

 

by Garth Jones

Filed under: SCCM

Best Airline Ever!
Monday, July 11, 2011 4:07 PM

I subscribe to Forrester group’s blog and I saw this blog about Porter airline!  http://blogs.forrester.com/harley_manning/11-07-11-the_best_airline_experience_you_havent_heard_of_yet, 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 their office from Mississauga to Downtown Toronto so that I can fly Porter more often!

 

What I would “love” Porter to do, is expand their services to provide a vacation getaways to Mexico or Jamaica!

by Garth Jones

Filed under: Canada