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
Month: July 2011
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
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 […]
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
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
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
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 […]