Month: November 2007

Which Computers have Winfile.exe installed? version 2

Oops the old version left duplicate PCs. This version fixes that. SELECT DISTINCT CS.Name0, — (Case when SF.FileName=’winfile.exe’ then ‘Yes’ else ‘ ‘ end) as ‘WinFile’ ‘Yes’ as ‘WinFile’ FROM dbo.v_GS_SoftwareFile SF, dbo.v_GS_COMPUTER_SYSTEM CS Where SF.ResourceID = CS.ResourceID and SF.FileName=’winfile.exe’ Union SELECT DISTINCT CS.Name0, –(Case when SF.FileName=’winfile.exe’ then ‘Yes’ else ‘ ‘ end) as ‘WinFile’ […]

if…then.. example

Here is a sampel of using a if … them within a SQL query. set nocount on SELECT soft.ARPDisplayName0 as ‘Ansys Software’, soft.VersionMajor0 as ‘Major Version’, COUNT(soft.VersionMajor0) AS ‘Count’, @dep AS ‘Department’ into #tmp FROM dbo.v_RA_System_SystemOUName ou, dbo.v_GS_INSTALLED_SOFTWARE soft LEFT JOIN dbo.v_GS_System sys ON sys.ResourceID = soft.ResourceID WHERE ou.ResourceID = sys.ResourceID –and soft.ARPDisplayName0 like ‘Ansys%’ […]

TechNet Canada Innovation Awards

  In recognition of Canadian IT Professionals who make an impact The TechNet Canada Innovation Awards are awarded to an Individual or a Team of Canadian IT Professionals who are bright stars in the IT community. The Innovation Awards are given in recognition of Canadian IT professionals who make a positive impact in their communities […]