in

SMSUG.ca

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

Browse by Tags

  • List of PCs by OU

    select R . Name0 as 'PC' , right( OU . System_OU_Name0 , CHARINDEX ( '/' , reverse ( Max ( OU . System_OU_Name0 )))- 1 ) as 'OU' from dbo . v_R_System R left outer join dbo . v_RA_System_SystemOUName OU on R . ResourceID = OU . ResourceID Group by R . Name0 , OU . System_OU_Name0...
    Posted to Garth Jones (Weblog) by Garth on 07-24-2011
  • Modified version of “Hardware 03B - Computers for a specific primary console user”

    Select D istinct R . Netbios_Name0 AS 'Computer Name' , SCU . SystemConsoleUser0 as 'User' , S . SiteName as 'SMS Site Name' , SEU . SerialNumber0 AS 'Serial Number' , SEU . SMBIOSAssetTag0 AS 'Asset Tag' , CS . Manufacturer0 AS 'Manufacturer' , CS . Model0...
    Posted to Garth Jones (Weblog) by Garth on 06-08-2011
  • Canadian Microsoft Management Summit 2011

    Did you miss MMS this year? Well here is you change to see the highlight! (aka Put your head in the cloud)   When: Friday, May 6 Where: Microsoft Canada Headquarters in Mississauga, Ontario Registration Details: http://www.microsoft.com/canada/events/event_details.aspx?event_id=1032484234
    Posted to Garth Jones (Weblog) by Garth on 05-02-2011
  • Talk TechNet: take a ways

    As promised here are a few good resource to help you with ConfigMgr. ConfigMgr focused websites http://www.myitforum.com/ http://faqshop.com/ Mailing list http://www.myitforum.com/absolutenm/EmailLists.aspx Forums http://faqshop.com/forums/ http://www.myitforum.com/forums/ http://social.technet.microsoft...
    Posted to Garth Jones (Weblog) by Garth on 04-22-2011
  • TechNet Webcast: Talk TechNet with Keith Combs and Matt Hester – Episode 24: Garth Jones on System Center Configuration Manager

    I also most forgot to blog about this! Make sure that you register for this event. :-) https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032483834&EventCategory=4&culture=en-US&CountryCode=US Language(s): English. Product(s): Microsoft System Center Configuration Manager...
    Posted to Garth Jones (Weblog) by Garth on 04-18-2011
  • 70-243 & 70-242 – Call to Action!

    Ok Everyone, it is time to tell MS what you think a stem Center Configuration Manager 2012 and System Center Operations Manager 2012. http://borntolearn.mslearn.net/btl/b/weblog/archive/2011/03/24/system-center-folks-we-need-your-input.aspx The Survey is 5 questions lone with the most “taxing” question...
    Posted to Garth Jones (Weblog) by Garth on 03-25-2011
  • PC’s last Heartbeat Date & Time

    select     CS.Name0,     max(AD.AgentTime) as 'Date/Time' from     dbo.v_AgentDiscoveries ad     JOIN dbo.v_GS_COMPUTER_SYSTEM cs on AD.ResourceID = CS.ResourceId     join dbo.v_FullCollectionMembership FCM on FCM.ResourceID...
    Posted to Garth Jones (Weblog) by Garth on 02-03-2011
  • 2011 myITforum.com Donation

    With the start of a new year, it is that time again to support the System Management Community, with that in mind I have made my yearly donation of $250 USD to MyITForum (MIF). Have you made a donation to your community yet? http://www.myitforum.com/donations/donate.asp
    Posted to Garth Jones (Weblog) by Garth on 01-02-2011
  • Adding user name to “Computers with a specific file” report

    select     SYS.Netbios_Name0,     SYS.User_Name0,     SF.FileName,     SF.FileDescription,     SF.FileVersion,     SF.FileSize,     SF.FileModifiedDate,     SF.FilePath From    ...
    Posted to Garth Jones (Weblog) by Garth on 10-30-2010
  • Find PCs like TTDRxxxACxxWxxx

    select *  from  SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Name like "TTDR___AC__W___"
    Posted to Garth Jones (Weblog) by Garth on 09-03-2010
Page 5 of 7 (63 items) « First ... < Previous 3 4 5 6 7 Next >
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems