SMSUG.ca

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

Garth Jones

June 2010 - Posts

  • How to connect to Windows Internal db using SQL Server Management Studio

    I was troubling shooting a WSUS issue and I need to connect to the db to edit some settings. This turns out to be harder than you think when you using Windows Internal db. So how do you connect to the db? Well this post will answer that for you.

    http://www.mssqltips.com/tip.asp?tip=1577

    Digg This
  • Remote Assistance and ConfigMgr

    Today I was trying to use the Remote Assistance from ConfigMgr, I keep getting a error message Your Offer to help could not be sent see screen shot below

     

    image

     

    Of course I did the normal troubleshooting stuff.

    ·        Check the GPO to ensure it was enabled

    ·        Pinged the server

    ·        Mapped a drive to the server

    ·        Etc.

     

    Eventually I checked the server itself and notice RA was not enabled, so I tried to enabled it. and got a new error message Unable to locate remote assistance. The remote assistance feature may not be installed on this machine. I quickly learned that on Windows 2008 that Remote Assistance is a feature that is NOT installed by default! Once I add it to the server, all was good.

    Digg This
  • List of Disabled Programs

    SELECT  [AdvertisementID]
          ,[AdvertisementName]
    ,[ProgramFlags]
          ,[PackageID]
          ,[ProgramName]
          ,[CollectionID]
          ,[PresentTime]
          ,[TimeFlags]
          ,[ExpirationTime]
          ,[AdvertisementSourceSite]
          ,[PackageName]
          ,[PackageVersion]
          ,[PackageLanguage]
          ,[PackageManufacturer]
          ,[CollectionName]
         
    FROM [dbo].[v_AdvertisementInfo]
    where (0x00001000 & Programflags) != 0

    Digg This
  • List of user with X

    Select distinct
        TopConsoleUser0
    from
        dbo.v_Add_Remove_Programs ARP
        Join dbo.v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP SCUM on ARP.ResourceId = SCUM.ResourceID
    Where
        ARP.DisplayName0 = 'Update for Windows Server 2003 (KB923845)'

    Digg This
  • Are you serious? You want me to install Firefox?

    Dear Secure Certificate Customer,

    Thank you for contacting Secure Certficate Support. It appears as though this is a common issue when installing the .spc file to Internet Explorer (IE) 8. Once installed the private is marked as not exportable. You may wish to try and rekey and reinstall the certificate to a Firefox browser. Firefox does not seem to have an issue with exporting the private key similarly IE7 reacts in much the same way.”

     

    Are you serious? You want me to install Firefox?  Have you even thought about contacting Microsoft support to figure out why this might be happening? I bet not.

     

    To be honest, I was total skeptical that using Firefox would work. I was getting annoyed that I had to download and install Firefox, but I was going to prove them wrong that this was not going to work.  

     

    I have contact Go Daddy support a few times now and the more I contact them the more I wonder if it would have been better to pay the few extra dollars and use another company such a  Entrust or VeriSign.

     

    Well it does work! (Maybe, I have not fully test the PFX certification that I need for Visual Studio 2008 but I don’t see why it shouldn’t work! Being that today is father day I’m not go to test this today.)

     

    So this bring up some interesting questions:

    ·        Why is the not on the FAQ page!

    ·        Why have they not worked with MS to resolve this issue with IE8?

    ·        Why doesn’t their support staff know this when I called?

    ·        Why does it take 24 hours to get an answer from them? (Honestly it was 10+ but I have stop working for the day about 1.5 hours before this email came in and I didn’t check out my email until this morning.)

    ·        Why do Go Daddy say it take 72 hours before I should expect to get an answer?

    Digg This
  • Free Training Summer 2010!!!

    CTE has done it again!! The are giving away 140, 000 worth of Training for ITIL and Win2k8 Boot Camp!

    Here are the details!

    Hi Garth,

     
    This summer CTE Solutions, will again, be giving away over $140,000 worth of free training and certification programs to help the unemployed technology professionals in our region.  We are hoping you can help us get the word out to qualified candidates.


    The two programs that are being offered are ITIL Foundation Certification and Microsoft Administration MCITP: Server 2008 Administrator Boot Camp.  For more information on both programs visit www.makememarketable.ca


    Last year, we were inundated with news reports about the economic recession and the impact on many people’s lives.  We don’t hear about it as much anymore, but the effects are still being felt by many in the community who have either remained unemployed or found only part-time work.  We want to help!  These certification programs are designed to make professionals more marketable by providing training and certification in the technologies currently in demand in the marketplace.


    Please direct any interested participants to the website to apply for these sessions
    www.makememarketable.ca
     

    Thanks,
    Mia

    Digg This
  • List of Random PCs by Condition

    Here is a nice and simple way to get a list of Random PCs.

     

    Create a query based on what you want to find, in my example Windows XP.

    Then add to the query a condition to find those with a “3” as the last character in the SMSID,

    Since the SMSID/GUID is HEX this will give you ~1/16 of all of those PCs.

     

    select

                   R.Name,

                   R.SMSAssignedSites,

                   R.IPAddresses,

                   R.IPSubnets,

                   R.OperatingSystemNameandVersion,

                   R.ResourceDomainORWorkgroup,

                   R.LastLogonUserDomain,

                   R.LastLogonUserName,

                   R.SMSUniqueIdentifier,

                   R.ResourceId,

                   R.NetbiosName

    from 

                   SMS_R_System R

    where

                   R.OperatingSystemNameandVersion like "%Workstation 5.1%"

                   and R.SMSUniqueIdentifier like "%3"

    Digg This
  • Vista without SP1 or SP2 (WQL)

    select
        R.Name,
        OS.Caption,
        OS.CSDVersion
    from 
        SMS_R_System R
        inner join SMS_G_System_OPERATING_SYSTEM OS on OS.ResourceID = R.ResourceId
    where
        OS.CSDVersion is null
        and OS.Caption like "%Vista%"

    Digg This
  • Outlook.exe FILEPATH LIKE '%\Microsoft Office\OFFICE%'

    select
    SYS.Netbios_Name0,
    SF.FileName,
    SF.FileDescription,
    SF.FileVersion,
    SF.FileSize,
    SF.FileModifiedDate,
    SF.FilePath
    From
    v_GS_SoftwareFile SF
    join v_R_System SYS on SYS.ResourceID = SF.ResourceID
    Where
    SF.FileName = 'OUTLOOK.EXE'
    AND FILEPATH LIKE '%\Microsoft Office\OFFICE%'
    ORDER BY
    SYS.Netbios_Name0

    Digg This
  • Vista without SP1 or SP2

    Select
    CS.Name0,
    OS.Caption0,
    OS.CSDversion0
    From
    dbo.v_GS_COMPUTER_SYSTEM CS
    join dbo.v_GS_OPERATING_SYSTEM OS on CS.ResourceID = OS.ResourceID
    Where
    OS.Caption0 like '%Vista%'
    and OS.CSDversion0 is Null

    Digg This
    Posted Jun 12 2010, 12:16 PM by Garth with no comments
    Filed under: , , ,
  • Count of PCs by AD site

    SELECT
        R.AD_Site_Name0,
        Count(SMS_Installed_Sites0) AS 'Count'
    From
        v_R_System R
        JOIN v_RA_System_SMSInstalledSites SIS ON R.ResourceID = SIS.ResourceID
    WHERE
        R.AD_Site_Name0 = 'Default-First-Site-Name'
    Group By
        R.AD_Site_Name0

    Digg This
  • List of PCs by AD site

    SELECT
        R.Netbios_Name0,
        R.User_Name0,
        R.Operating_System_Name_and0,
        R.AD_Site_Name0,
        IP.IP_Addresses0
    From
        v_R_System R
        JOIN v_RA_System_IPAddresses IP ON R.ResourceID = IP.ResourceID
        JOIN v_RA_System_SMSInstalledSites SIS ON R.ResourceID = SIS.ResourceID
    WHERE
        R.AD_Site_Name0 = 'Default-First-Site-Name'

    Digg This

This Blog

Syndication

News

Training

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