-
-
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
-
-
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 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!
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. :-)
-
-
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!
-
-
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
-
-
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
-
-
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>"
-
-
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
