Month – August 2011

Replace

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

Announcing ITProTeach Ottawa, November 2-4, 2011

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

Throwing a bone.

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

RAM by User name

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’