SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

August 2011 - Posts

  • PC Var data

    select

    Name,
    Value,

    Masked

    from

    MEP_MachineVariables

    where

    MachineID

    = 63
  • 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 = 1 and dbo.v_GS_NETWORK_ADAPTER.MACAddress0 like @Mac ORDER By dbo.v_GS_NETWORK_ADAPTER.MACAddress0 end

    end

    Posted Aug 28 2011, 03:17 PM by Garth with no comments
    Filed under: , ,
  • 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 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

  • 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 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
  • 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'

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems