August 2011 - Posts

PC Var data
Sunday, August 28, 2011 4:38 PM

select

Name, Value,

Masked

from

MEP_MachineVariables

where

MachineID

= 63

by Garth Jones

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

Replace
Sunday, August 28, 2011 4:17 PM

Declare

@MAC as Varchar(250)

Set

@Mac=''

begin

if (@__filterwildcard = '') SELECT DISTINCT dbo.v_GS_NETWORK_ADAPTER.MACAddress0 FROM dbo.v_R_System INNER JOIN dbo.v_GS_NETWORK_ADAPTER ON dbo.v_R_System.ResourceID = dbo.v_GS_NETWORK_ADAPTER.ResourceID WHERE dbo.v_R_System.Client0 = 1 else begin set @mac= REPLACE(@__filterwildcard,'-',':') --- Added by me SELECT DISTINCT dbo.v_GS_NETWORK_ADAPTER.MACAddress0 from dbo.v_R_System INNER JOIN dbo.v_GS_NETWORK_ADAPTER ON dbo.v_R_System.ResourceID = dbo.v_GS_NETWORK_ADAPTER.ResourceID and dbo.v_GS_NETWORK_ADAPTER.MACAddress0 like @Mac WHERE dbo.v_R_System.Client0 = 1 and dbo.v_GS_NETWORK_ADAPTER.MACAddress0 like @Mac ORDER By dbo.v_GS_NETWORK_ADAPTER.MACAddress0 end

end

by Garth Jones

Filed under: ConfigMGr, Code, SQL

Announcing ITProTeach Ottawa, November 2-4, 2011
Tuesday, August 23, 2011 11:17 PM

Announcing ITProTeach Ottawa, November 2-4, 2011

For the first time since its creation, DevTeach (ITProTeach) will be presenting a conference in Ottawa. This event taking place on November 2-4 2011 at the brand new Ottawa Convention Center will include pre-conference workshops as well as 2 full days of conferences.

We have a grand total of 48 sessions planned for the weekend: 12 sessions by ITProTeach for IT Professionals, 12 sessions by SQLTeach for DBAs and finally 24 sessions by DevTeach for developers. The contents of the sessions will be announced soon.

Take advantage of our low prices right now! Attendees registering before September 1st 2011 will only have to pay $449. That’s only $224.50 per day! This event is limited to 350 attendees, so register as soon as you can! See you there. - Garth

by Garth Jones

Filed under: Canada, TechDays Canada, DevTeach

Throwing a bone.
Monday, August 22, 2011 7:20 PM

select

distinct

R

.Name0,

SAS

.SMS_Assigned_Sites0,

R

.Operating_System_Name_and0,

R

.User_Name0,

R

.Netbios_Name0,

CS

.Manufacturer0,

CS

.Model0,

BIOS

.SerialNumber0,

CS

.NumberOfProcessors0,

Pro

.Manufacturer0,

Pro

.IsMobile0,

Pro

.IsMulticore0,

Pro

.MaxClockSpeed0,

HD

.Size0,

RAM

.TotalPhysicalMemory0,

CS

.SystemType0

from

v_R_System R

inner join dbo.v_RA_System_SMSAssignedSites SAS on SAS.ResourceID = R.ResourceId inner join dbo.v_GS_DISK HD on HD.ResourceID = R.ResourceId inner join dbo.v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = R.ResourceId inner join dbo.v_GS_PC_BIOS BIOS on BIOS.ResourceID = R.ResourceId inner join dbo.v_GS_PROCESSOR Pro on Pro.ResourceID = R.ResourceId inner join dbo.v_GS_X86_PC_MEMORY RAM on RAM.ResourceID = R.ResourceId

order

by

R

.Name0

by Garth Jones

RAM by User name
Saturday, August 06, 2011 2:00 PM

SELECT

Distinct

SYS.Netbios_Name0

,

SYS.Operating_System_Name_and0

,

MEM

.TotalPhysicalMemory0/1024 As C083

FROM

v_R_System SYS

JOIN v_GS_X86_PC_MEMORY MEM on SYS.ResourceID = MEM.ResourceID

WHERE

User_Name0

= 'Garth'

by Garth Jones

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