Month – October 2010

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. This month is […]

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 […]

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