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
Month: October 2010
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 […]
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 […]
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