...your virtual communITy
All Tags » SMS (RSS)

Browse by Tags

  • Link v_MeteredUser.FullName to a full name from ad

    To see the full post select R.Netbios_Name0 as ' Computernavn ', -- U.displayName0 as 'Bruger', Full_User_Name0, MU.FullName as ' Brugernavn ', MUS.LastUsage as ' Sidst brugt...
    Posted to Garth Jones (Weblog) by Garth on 03-12-2012
  • BIG NEWS!!!!

    I have big news but there is a catch….. I can’t say much until Wednesday at noon PST! J Which works out perfectly, as that is almost the exact time that I will be finishing my SCCM Guru webcast! So make sure that your register for the session to hear it Live!   oh, you want...
    Posted to Garth Jones (Weblog) by Garth on 03-11-2012
  • Link to Name

    For full details see post here.   select ARP.resourceid, CS.Name0, max (ARP.version0) as JavaVersion from dbo.v_GS_COMPUTER_SYSTEM as CS join dbo.v_ADD_REMOVE_PROGRAMS as ARP on CS.ResourceID = ARP.ResourceID where ARP...
    Posted to Garth Jones (Weblog) by Garth on 03-11-2012
  • Custom ChassisType Report - wrong counts

    See the full details within the forum declare @Manufacturer0 as varchar (250) set @Manufacturer0 = ' All ' declare @Version0 as varchar (250) set @Version0 = ' All ' declare...
    Posted to Garth Jones (Weblog) by Garth on 03-04-2012
  • Tips and Tricks for SSRS

    I want to let everyone know that I will be giving a webcast on SSRS Report Writing for CM07/CM12 on Wednesday, March 14, 2012, at  11:00 a.m. to 12:30 pm PST.    Episode 9: Garth Jones A Deep Dive into SCCM Data! Bring Your Snorkel!   In this session, I will dive deep into the depths...
    Posted to Garth Jones (Weblog) by Garth on 02-24-2012
  • ONE Row for each Server

    For full details see the forum post. SELECT Distinct R.Name0 as ' PC ', LD.FreeSpace0 as ' Free Space ', LD. Size 0 as ' Size ', isnull(Share.Path0,' n/a ')...
    Posted to Garth Jones (Weblog) by Garth on 02-23-2012
  • Display the User Group Name in 1 column

    To see full forum post see SELECT R.User_Name0 as ' user name ', U.Full_User_Name0 as ' full name ', U.givenName0 as ' First Name ', U.sn0 as ' Surname ', U...
    Posted to Garth Jones (Weblog) by Garth on 02-17-2012
  • AD discovery and add the following attributes (givenname, sn, mail & ou) report

    For full details see. I fix the query to make it work, change OS to a readable name, formatting etc.. SELECT R.Name0 as ' Host Name ', CS.Model0 as ' model ', BIOS.SerialNumber0...
    Posted to Garth Jones (Weblog) by Garth on 02-14-2012
  • PC not logon for 14 days.

    For full details see.   select CS.Name0, LCU. date From dbo.v_GS_COMPUTER_SYSTEM CS join ( Select ResourceID, max (LastConsoleUse0) as ' date ' from dbo.v_GS_SYSTEM_CONSOLE_USER SCU...
    Posted to Garth Jones (Weblog) by Garth on 02-06-2012
  • SCCM Query for Memory & CPU

    See Forum post for fill details. select distinct SMS_R_System.Name, SMS_R_System.Client, SMS_R_System.LastLogonUserName, SMS_R_System.ADSiteName, SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory, SMS_G_System_PROCESSOR.NormSpeed from SMS_R_System inner join SMS_G_System_X86_PC_MEMORY on SMS_G_System_X86_PC_MEMORY...
    Posted to Garth Jones (Weblog) by Garth on 01-31-2012
Page 5 of 48 (479 items) « First ... < Previous 3 4 5 6 7 Next > ... Last »
©2010 Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems