SMSUG.ca

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

Garth Jones

October 2010 - Posts

  • 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
        v_GS_SoftwareFile SF
        join v_R_System SYS on SYS.ResourceID = SF.ResourceID
    Where
        SF.FileName LIKE @variable
    ORDER BY
        SYS.Netbios_Name0

  • When I’m 107!

    This is just too good to not share!

    So I received my MasterCard Statement this month and there is a new law in Canada which requires Credit Card companies to tell you how long it will take to pay off your current balance assuming that you make only make the minimum payments.

    clip_image002

    This month is a higher than normal month for me, as I purchased a new laptop and anniversary trip for Ellen, plus my miscellaneous spending but I have to laugh out loud when I saw my bill! Here is what I saw!

    clip_image004

    Yes that says, 64 Years and 7 Months!!

    BTW, it not due until the Nov 10 or so and I already have it covered but if you want to donate to my MasterCard fund, feel free to send $$ to my paypal account. :-)

  • Sunday Morning Funnies!!!

    This morning I woke up late after I booked a few hours in my calendar last night to just “walk away” from my PC. Even before starting to make coffee, I pushed the power button on my laptop, Then started to make coffee!

    Now that the coffee is brewing, I started the triage of my inboxes!, Yes inboxes! Since it is the weekend, my inbox is not full of stuff that I have to do today. After that I started to read my RSS feeds.

    I stumble on a blog folder called “Latest Blogs” I don’t remember whose blog it is so I looked at it. Normally, I just delete all RSS feeds but this one title piqued my interest. Blog: You might need to unplug if… So I started to read it.

    As soon as I read the first item on the top 10 list, I was howling! Ellen walked into the living room to see what was so funny! Then we both LOL at the whole list. Ellen asked to see the comments of this blog so we went online and laughed at Stefan Koell’s comments.

    I agree with Cameron’s top 10 list and I know that I’m burning the candle at both ends right now. But I have also planned some downtime soon. I will be going on holidays with my wife (Ellen) for our anniversary. With the exception of one year, I never bring a laptop or smart phone so for 7 days no one can get a hold of me! Heck, yesterday I even planned for the Enhansoft Christmas Party and we are going out of town too! So no laptop!

    IMO, the first step is to recognize that you are overloaded and the second step is to make a plan on how you are going to solve it. Hence why I have booked the trips and I’m trying to hire more staff!

    P.S.

    · I did check my email before going to bed last night, right after the hockey game! :-)

    · Last week, I talked to Brad while driving at 100 km/h on my way to a gig.

    · I have scheduled time to walk our dog “Nabby” with my wife Ellen today!

    Posted Oct 24 2010, 10:49 PM by Garth with 2 comment(s)
    Filed under: ,
  • How to determine the average number of EXEs on a PC

    SELECT Count(SF.Filename) AS 'Count0'
    into #avge2
    FROM dbo.v_GS_SoftwareFile SF
    Where Filename like '%.exe'
    GROUP BY SF.ResourceID

    select avg(count0) from #avge2
    drop table #avge2

  • List of anti-malware program cleanup/uninstall tools

    While research an issue I’m having with Forefront, I ran across this forum post. Since I found it useful, I’m sure that other will find it useful too.
    http://social.answers.microsoft.com/Forums/en-US/msestart/thread/407bf6da-c05d-4546-8788-0aa4c25a1f91

    Posted Oct 10 2010, 03:43 PM by Garth with 1 comment(s)
    Filed under:
  • PC with app x but exclude PC y

    select
        SMS_R_System.ResourceId,
        SMS_R_System.ResourceType,
        SMS_R_System.Name,
        SMS_R_System.SMSUniqueIdentifier,
        SMS_R_System.ResourceDomainORWorkgroup,
        SMS_R_System.Client
    from 
        SMS_R_System
        inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId
    where
        SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "<app name>"
        and SMS_R_System.Name != "<PC name in upper case>"

  • Sum of JPG by PC

    select
        SYS.Netbios_Name0,
        sum(SF.FileSize)
    From
        v_GS_SoftwareFile SF
        join v_R_System SYS on SYS.ResourceID = SF.ResourceID
    Where
        SF.FileName like '%.jp%'
    group by
        SYS.Netbios_Name0
    ORDER BY
        SYS.Netbios_Name0

This Blog

Syndication

News

Training

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