in

SMSUG.ca

...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 http://www.myitforum.com/forums/How-to-link-v_MeteredUserFullName-to-a-full-name-from-ad-m234899.aspx 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! http://bit.ly/yMimvp   oh, you want...
    Posted to Garth Jones (Weblog) by Garth on 03-11-2012
  • Link to Name

    For full details see post here. http://www.myitforum.com/forums/tm.aspx?high=&m=234875&mpage=1#234894   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 http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/d8477233-4b10-4a6d-a5ea-de73abc9b815/ 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. http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/bbc5e667-085f-47a2-a5b6-8a5089aa9e91 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 http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/986960ba-8a50-4e69-9e5a-64a40c9d8df5/ 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. http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/7f48aa48-d260-4ad1-babc-8b2496d103fb 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. http://social.technet.microsoft.com/Forums/en-US/configmgrsdk/thread/cf7d80a0-1a7c-430c-b33a-ee47a0efa806   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 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems